DA0-001 Tested & Approved CompTIA Data+ Study Materials [Q178-Q200]

NO.178 An analyst is working with a data set that lists individuals’ first and last names in separate columns. Which of the following processes should the analyst use to combine the first and last names into a single spreadsheet cell?

Transpose

Blend

Concatenate

Merges

NO.179 A data analyst needs to observe the relationship between two numeric variables and identify the clustering pattern as well as the outliers. Which of the following visualizations should the analyst use?

Heat map

Tree map

Scatter plot

Stacked chart

NO.180 An analyst reviews the following data:
7
3
5
2
3
7
7
10
Which of the following is the value of the mode?

3

5

7

10

NO.181

Which of the following summary statements upholds integrity in data reporting?

Sales are approximately equal for Product A and Product B across all strategies.

Strategy 4 provides the best sales in comparison to other strategies.

While Strategy 2 does not result in the highest sales of Product D. over all products it appears to be the most effective.

Product D should be promoted more than the other products in all strategies.

NO.182 Given the below:

Which of the following numbers represents a Type I error?

1

2

3

4

NO.183 Given the following report:

Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

A control group for the phrases

A summary of the KPIs

Filter buttons for the status

The date when the report was last accessed

The time period the report covers

The date on which the report was run

Explanation
The date on which the report was run. This is because the time period the report covers and the date on which the report was run are two components that need to be added to ensure the report is point-in-time and static, which means that the report shows the data as it was at a specific moment or interval in time, and does not change or update with new data. By adding the time period the report covers and the date on which the report was run, the analyst can indicate when and for how long the data was collected and analyzed, as well as avoid any confusion or ambiguity about the currency or validity of the data. The other components do not need to be added to ensure the report is point-in-time and static. Here is why:
A control group for the phrases is a type of group that serves as a baseline or a reference for comparison with another group that is exposed to some treatment or intervention, such as a target phrase in this case. A control group for the phrases does not need to be added to ensure the report is point-in-time and static, because it does not affect the time frame or the stability of the data. However, a control group for the phrases could be useful for evaluating the effectiveness or impact of the target phrases on customer satisfaction or retention.
A summary of the KPIs is a type of document that provides an overview or a highlight of the key performance indicators (KPIs), which are measurable values that indicate how well an organization or a process is achieving its goals or objectives. A summary of the KPIs does not need to be added to ensure the report is point-in-time and static, because it does not affect the time frame or the stability of the data. However, a summary of the KPIs could be useful for communicating or presenting the main findings or insights from the report.
Filter buttons for the status are a type of feature or function that allows users to select or deselect certain values or categories in a column or a table, such as ticket statuses in this case. Filter buttons for the status do not need to be added to ensure the report is point-in-time and static, because they do not affect the time frame or the stability of the data. However, filter buttons for the status could be useful for exploring or analyzing different aspects or segments of the data.

NO.184 Which of the following would be the best way to identify multicollinear attributes in a data set?

Correlation coefficient

Chi-squared test

Two-sample f-test

Two-way ANOVA

NO.185 Which of the following concepts should be applied if a data set with 40 fields needs to be pared down to 20 fields and contains similar data across multiple fields?

Duplication

Consolidation

Compliance

Standardization

NO.186 A research analyst wants to determine whether the data being analyzed is connected to other datapoints.
Which of the following is the BEST type of analysis to conduct?

Performance analysis

Trend analysis

Exploratory analysis

Link analysis

NO.187 What is NOT a characteristic of a good data steward?

A good technology expert.

Collaborative.

A subject matter expert.

Influential.

NO.188 Five dogs have the following heights in millimeters:
300,430, 170, 470, 600
Which of the following is the standard deviation for the five dogs?

147mm

154mm

394 mm

21,704mm

NO.189 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 stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.

A systematic survey that is sent to 100 single-family homes in the county

Surveys sent to ten randomly selected homes within 5mi (8km) of the county’s office

Surveys sent to 100 randomly selected homes that are reflective of the population

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.

NO.190 A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

transactional schema.

star schema.

non-relational schema.

snowflake schema.

NO.191 Given the following report:

Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

A control group for the phrases

A summary of the KPIs

Filter buttons for the status

The date when the report was last accessed

The time period the report covers

The date on which the report was run

NO.192 Given the following data:

Which of the following BEST describes the data set?

There is data bias.

The data is incomplete.

The data is inconsistent.

The data is outliers.

This is because inconsistency is a type of data quality issue that occurs when the data does not follow a common format, structure, or rule across different sources or systems, which can affect the efficiency and performance of the analysis or process. Inconsistency can be caused by having different spellings, punctuations, capitalizations, or abbreviations for the same or similar values in a data set, such as “M”, “m”,
“Male”, or “male” for gender in this case. Inconsistency can be eliminated or reduced by using data cleansing techniques, such as standardizing or normalizing the data values. The other options are not correct descriptions of the data set. Here is why:
* Data bias is a type of data quality issue that occurs when the data is not representative or proportional of the population or the parameter, which can affect the validity and reliability of the analysis or process.
Data bias can be caused by having a sample that is too small, too large, or too skewed for the population or the parameter, such as having only male customers for a product that targets both genders in this case. Data bias can be eliminated or reduced by using sampling techniques, such as stratified or cluster sampling.
* The data is incomplete is a type of data quality issue that occurs when the data is absent or missing in a data set, which can affect the accuracy and reliability of the analysis or process. The data is incomplete can be caused by various factors, such as human error, system error, or non-response. The data is incomplete can be addressed by using various methods, such as replacing or imputing the missing values with some reasonable estimates, such as mean, median, mode, or regression.
* The data is outliers is a type of data quality issue that occurs when the data has values that are unusually high or low compared to the rest of the data set, which can affect the quality and validity of the analysis or process. The data is outliers can be caused by various factors, such as measurement error, natural variation, or extreme events. The data is outliers can be addressed by using various methods, such as removing or filtering out the outliers, or using robust statistics that are less sensitive to outliers, such as median, interquartile range, or box plot.

NO.193 An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

Scatter plot

Heat map

Pie chart

Infographic

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

WHERE

AGGREGATE

BOOLEAN

IF

NO.195 The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable.
Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.

NO.196 While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

Replace missing data.

Remove duplicate data.

Replace redundant data.

Remove invalid data.

NO.197 A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?

Trend analysis

Performance analysis

Link analysis

Exploratory analysis

NO.198 Which of the following is an example of PII?

Age

Name

Ethnicity

Gender

NO.199 Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

SAS

Microsoft Power B1

IBM SPSS

Python

NO.200 Given the following customer and order tables:
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

Five rows, eight columns

Seven rows, eight columns

Eight rows, seven columns

Nine rows, five columns

Leave a Reply Cancel reply