CompTIA DA0-001 CompTIA Data+ Certification Online Training

Question #31

An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

A . Aggregate
B . Logical
C . Date
D . Sort

Reveal Solution Hide Solution

Question #32

While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January.

Which of the following steps should be taken to ensure data consistency?

A . Delete any of the responses that do not have “January” written out.
B . Replace any of the responses that have “01”.
C . Filter on any of the responses that do not say “January” and update them to “January”.
D . Sort any of the responses that say “Jan” and update them to “01”.

Reveal Solution Hide Solution

Question #33

Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

A . Missing data
B . Duplicate data
C . Redundant data
D . Invalid data

Reveal Solution Hide Solution

Question #34

A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km).

Which of the following sampling methods would MOST likely result in a representative sample?

A . A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.
B . A systematic survey that is sent to 100 single-family homes in the county
C . Surveys sent to ten randomly selected homes within 5mi (8km) of the county’s office
D . Surveys sent to 100 randomly selected homes that are reflective of the population

Reveal Solution Hide Solution

Correct Answer: D
D

Explanation:

Surveys sent to 100 randomly selected homes that are reflective of the population. This is because a random sample is a type of sample that is selected by using a random method, such as a lottery or a computer-generated number, which ensures that every element in the population has an equal chance of being selected. A random sample can result in a representative sample, which means that the sample reflects the characteristics and diversity of the population. By sending surveys to 100 randomly selected homes that are reflective of the population, the analyst can ensure that the sample is representative of the county’s households and their income levels. The other sampling methods are not likely to result in a representative sample.

Here is why:

A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m. would result in a biased sample, which means that the sample favors or excludes certain groups or elements in the population. By conducting the survey only between 2:00 p.m. and 3:00 p.m., the analyst would miss out on people who are not available or reachable at that time, such as those who are working or sleeping. This could affect the representativeness and generalizability of the sample. A systematic survey that is sent to 100 single-family homes in the county would result in an unrepresentative sample, which means that the sample does not reflect the characteristics and diversity of the population. By sending surveys only to single-family homes, the analyst would ignore other types of households, such as apartments, condos, or mobile homes. This could affect the accuracy and reliability of the sample.

Surveys sent to ten randomly selected homes within 5mi (8km) of the county’s office would result in a small sample, which means that the sample size is too low to capture the variability and diversity of the population. By sending surveys only to ten homes within a limited area, the analyst would miss out on many households that are located in different parts of the county. This could affect the precision and confidence of the sample.

Question #35

Which of the following statistical methods requires two or more categorical variables?

A . Simple linear regression
B . Chi-squared test
C . Z-test
D . Two-sample t-test

Reveal Solution Hide Solution

Question #36

Which of the following data manipulation techniques is an example of a logical function?

A . WHERE
B . AGGREGATE
C . BOOLEAN
D . IF

Reveal Solution Hide Solution

Question #37

A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals’ earned commissions and projected commissions based on sales, but they want that information to be kept confidential.

Which of the following would be the BEST way to provide this visibility?

A . Create a dashboard displaying a data refresh date so users know the current sales numbers and configure permissions to control access.
B . Create a dashboard for sales numbers, pipeline, and team and individual performance for the management team.
C . Create a dashboard with filters for the overall team, individuals, and management. Users can filter to see the data they want.
D . Create a dashboard with views for team, individuals, and management. Configure permissions to control access.

Reveal Solution Hide Solution

Correct Answer: D
D

Explanation:

Create a dashboard with views for team, individuals, and management. Configure permissions to control access. This is because a dashboard is a type of visualization that displays multiple charts or graphs on a single page, usually to provide an overview or summary of some data or information. A dashboard can be used to provide visibility of current sales numbers, pipeline, and team performance by showing different metrics and indicators related to these aspects. By creating a dashboard with views for team, individuals, and management, the analyst can customize the content and layout of the dashboard for different audiences and purposes. By configuring permissions to control access, the analyst can ensure that the confidential information, such as individuals’ earned commissions and projected commissions based on sales, is only visible to the authorized users. The other ways are not the best way to provide this visibility.

Here is why:

Creating a dashboard displaying a data refresh date so users know the current sales numbers and configuring permissions to control access would not be sufficient to provide visibility of pipeline and team performance, as well as individuals’ earned commissions and projected commissions based on sales. The dashboard would only show the current sales numbers and the date when the data was updated, which would not give a comprehensive or detailed view of the sales situation.

Creating a dashboard for sales numbers, pipeline, and team and individual performance for the management team would not be appropriate to provide visibility for the sales team, as they would not have access to the dashboard or the information they need. The dashboard would only be available for the management team, which would limit the transparency and collaboration among the sales team members.

Creating a dashboard with filters for the overall team, individuals, and management would not be secure to provide visibility of confidential information, such as individuals’ earned commissions and projected commissions based on sales. The dashboard would allow users to filter and see the data they want, which could expose sensitive or personal information to unauthorized users.

Question #38

Which of the following is a characteristic of a relational database?

A . It utilizes key-value pairs.
B . It has undefined fields.
C . It is structured in nature.
D . It uses minimal memory.

Reveal Solution Hide Solution

Question #39

A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day.

Which of the following date ranges should be on the report?

A . January 1, 2020 to April 1, 2020
B . January 1, 2020 to April 7, 2020
C . January 1, 2020 to April 8, 2020
D . January 1, 2020 to April 9, 2020

Reveal Solution Hide Solution

Question #40

Refer to the exhibit.

Given the following data tables:

Which of the following MDM processes needs to take place FIRST?

A . Creation of a data dictionary
B . Compliance with regulations
C . Standardization of data field names
D . Consolidation of multiple data fields

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

This is because a data dictionary is a type of document that defines and describes the data elements, attributes, and relationships in a database or a data set. A data dictionary can be used to facilitate the MDM (Master Data Management) process, which is a process that aims to ensure the quality, consistency, and accuracy of the data across different sources and systems. By creating a data dictionary first, the analyst can establish a common understanding and standardization of the data field names, types, formats, and meanings, as well as identify any potential issues or conflicts in the data, such as missing values, duplicate values, or inconsistent values. The other MDM processes can take place after creating a data dictionary.

Here is why:

Compliance with regulations is a type of MDM process that ensures that the data meets the legal and ethical requirements and standards of the industry or the organization. Compliance with regulations can take place after creating a data dictionary, because the data dictionary can help the analyst to identify and apply the relevant rules and policies to the data, such as data privacy, security, or retention.

Standardization of data field names is a type of MDM process that ensures that the data field names are consistent and uniform across different sources and systems. Standardization of data field names can take place after creating a data dictionary, because the data dictionary can provide a reference and a guideline for naming and labeling the data fields, as well as resolving any discrepancies or ambiguities in the data field names.

Consolidation of multiple data fields is a type of MDM process that combines or merges the data fields from different sources or systems into a single source or system. Consolidation of multiple data fields can take place after creating a data dictionary because the data dictionary can help the analyst to map and match the data fields from different sources or systems based on their definitions and descriptions, as well as eliminating any redundant or duplicate data fields.