Free CompTIA DA0-001 Practice Exams

Question #1

An analyst has conducted a review of business questions.

Which of the following should the analyst do next to conduct an analysis?

A . Determine the data needs and review the observations.
B . Determine the data needs and sources for analysis.
C . Determine the data needs and schedule interviews.
D . Determine the data needs and begin the analysis.

Reveal Solution Hide Solution

Question #2

Which of the following will MOST likely be streamed live?

A . Machine data
B . Key-value pairs
C . Delimited rows
D . Flat files

Reveal Solution Hide Solution

Question #3

Which of the following is a difference between a primary key and a unique key?

A . A unique key cannot take null values, whereas a primary key can take null values.
B . There can be only one primary key in a data set, whereas there can be multiple unique keys.
C . A primary key can take a value more than once, whereas a unique key cannot take a value more than once.
D . A primary key cannot be a date variable, whereas a unique key can be.

Reveal Solution Hide Solution

Question #4

A business unit made the following modification to the values in a table:

Which of the following data quality dimensions was applied in this scenario?

A . Integrity
B . Consistency
C . Completeness
D . Accuracy

Reveal Solution Hide Solution

Question #5

Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?

A . To return a subset of records
B . To insert a temporary table
C . To prevent SQL injections
D . To increase the query speed

Reveal Solution Hide Solution

Question #6

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?

A . Five rows, eight columns
B . Seven rows, eight columns
C . Eight rows, seven columns
D . Nine rows, five columns

Reveal Solution Hide Solution

Question #7

An analyst needs to join two data sets that compare vehicle weights. One data set is in pounds, and the other has various units of measure.

Which of the following should the analyst do first to the data prior to any type of join?

A . Blend
B . Reduce
C . Concatenate
D . Normalize

Reveal Solution Hide Solution

Question #8

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

A . SAS
B . Microsoft Power BI
C . IBM SPSS
D . Python

Reveal Solution Hide Solution

Question #9

Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5.000.000 rows?

A . Microsoft Excel
B . R
C . Snowflake
D . SQL

Reveal Solution Hide Solution

Question #10

A data analyst is creating a report that will provide information about various regions, products, and time periods.

Which of the following formats would be the most efficient way to deliver this report?

A . A workbook with multiple tabs for each region
B . A daily email with snapshots of regional summaries
C . A static report with a different page for every filtered view
D . A dashboard with filters at the top that the user can toggle

Reveal Solution Hide Solution

Correct Answer: D
D

Explanation:

The best format to deliver this report is D. A dashboard with filters at the top that the user can toggle.

A dashboard is a visual display of the most important information needed to achieve one or more objectives, consolidated and arranged on a single screen so the information can be monitored at a glance1A dashboard with filters at the top that the user can toggle would allow the user to easily and quickly access the information they need about various regions, products, and time periods, without having to navigate through multiple tabs, pages, or emails. A dashboard with filters would also enable the user to compare and contrast different views of the data and see how they change over time. A dashboard with filters would also be more interactive and engaging than a static or email report2

A workbook with multiple tabs for each region would not be an efficient way to deliver this report, because it would require the user to switch between different tabs to see the information they need. This would make it harder to compare and contrast different regions, products, and time periods, and also increase the risk of errors or confusion. A workbook with multiple tabs would also be less visually appealing and more cluttered than a dashboard3

A daily email with snapshots of regional summaries would not be an efficient way to deliver this report, because it would limit the user’s ability to explore the data in depth and customize their view. A daily email would also be dependent on the frequency and timing of the email delivery, which might not match the user’s needs or preferences. A daily email would also be more likely to be ignored or deleted than a dashboard that is always accessible.

A static report with a different page for every filtered view would not be an efficient way to deliver this report, because it would create a very long and cumbersome report that would be difficult to read and understand. A static report would also not allow the user to change or update the filters as they wish, or see how the data changes over time. A static report would also be less interactive and engaging than a dashboard.