CompTIA Data+ Practice Test

Answer choices

1. A. Mean and median only, for this task.
2. B. Skewness and multimodality, for the stated data analysis (24%) requirement.
3. C. Row count and file size, for the required outcome.
4. D. Primary and foreign keys, for the stated implementation and support requirements.

Wrong-answer review

• A. Mean and median only, for this task.: Mean and median describe location rather than asymmetry or multiple peaks.
• C. Row count and file size, for the required outcome.: Row count and file size do not characterize distribution shape.
• D. Primary and foreign keys, for the stated implementation and support requirements.: Keys describe relational structure, not statistical distribution.

Answer choices

1. A. Merge the datasets using 'account_number' as the key to combine contact information and purchase history for each customer, as the recommended implementation across the complete governed service lifecycle.
2. B. Append the customer records from both systems to create a larger dataset for broader campaign reach, for the described technical objective and its associated operational control requirements, for this requirement.
3. C. Explode the customer contact information fields into individual rows to facilitate analysis of communication preferences, for the stated implementation and support requirements.
4. D. Create a new calculated field to concatenate the first and last names from both systems to generate a unified customer name field, within cross-functional operational-accountability boundaries.

Answer choices

1. A. A map, effectively representing geographic relationships between crime rates, as presented.
2. B. A pivot table, allowing for grouped summaries of crime data, under the documented operational and governance requirements.
3. C. A table, providing precise lookup of crime statistics by district, for the specified implementation requirement.
4. D. An infographic, offering a concise narrative of crime trends, for the specified implementation requirement.

Answer choices

1. A. Assign all users the highest level of access to all data systems to simplify administration, in this situation.
2. B. Implement RBAC based on data classification, assigning permissions to roles and users through role membership, within the described operational context.
3. C. Establish a centralized data governance team to manage all RBAC configurations, under the stated technical, operational, and governance constraints.
4. D. Utilize a single, global data refresh interval to maintain data security, for the described technical objective and its associated operational control requirements.

Answer choices

1. A. Matching the storage type to the access interface and workload requirement, for the stated scenario.
2. B. Selecting the lowest-cost storage option regardless of workload requirements, under the documented operational and governance requirements.
3. C. Choosing a storage type based solely on its physical location, within the proposed design.
4. D. Implementing a single storage solution for all data types, under this approach.

Answer choices

1. A. ELT involves transforming data before loading it into the target, while ETL loads data first and transforms it within the target environment, for the described technical objective and its associated operational control requirements.
2. B. ETL involves transforming data before loading it into the target, while ELT loads data first and transforms it within the target environment, leveraging the cloud data warehouse's processing power, within the described operational context.
3. C. ETL is only suitable for small datasets, while ELT is only suitable for large datasets, for the described technical objective and its associated operational control requirements, for this scenario.
4. D. Both ETL and ELT are identical processes and can be used interchangeably, for the described technical objective and its associated operational control requirements, under the documented operational and governance requirements.

Answer choices

1. A. Utilize a complex dashboard with numerous charts to maximize data display and provide granular detail, within the documented scope, ownership, and validation boundaries.
2. B. Create a mock-up of the chart to validate layout and aesthetics before production implementation, focusing on visual appeal, for this scenario.
3. C. Employ a simple chart with text that clearly communicates key transaction trends, minimizing the risk of exposing sensitive data, in this situation.
4. D. Generate a report with raw data, prioritizing accessibility for all team members, assuming all recipients have appropriate security clearances, as the organization’s selected response.

Answer choices

1. A. Increase the report’s data processing capacity to handle the load, within the stated policy framework.
2. B. Immediately update the report’s refresh schedule to a more frequent interval, when applied.
3. C. Review the report’s user access permissions to prevent unauthorized modifications, under the documented operational and governance requirements.
4. D. Validate source freshness and schema against a known, reliable data sample, within this context.

Answer choices

1. A. Data versioning, to manage different revisions of the product information, under this approach.
2. B. Metadata, including source of truth and lineage, to track data origin and changes, for the stated security, delivery, and accountability requirements.
3. C. Snapshots for point-in-time preservation, to capture data states at specific intervals, as the proposed data governance (14%) approach.
4. D. Refresh intervals for data delivery, to control the frequency of data updates, for the stated scenario.

Answer choices

1. A. Create a single, large fact table containing all operational data to simplify querying and maintenance, within the documented scope, ownership, and validation boundaries.
2. B. Implement a star schema with a central fact table representing sales transactions and dimensional tables providing customer and product context, within the described context.
3. C. Utilize a snowflake schema with multiple interconnected fact tables to optimize query performance for complex reports, for the affected environment.
4. D. Employ a data vault modeling approach to accommodate evolving business requirements and future data integration needs, within the described operational context.