DA0-001 Free Questions

Question #11

An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard.

The following data is available:

Which of the following types of charts should be considered to BEST display the data?

A . Include a bar chart using the site and the percentage of new customers data.
B . Include a line chart using the site and the percentage of new customers data.
C . Include a pie chat using the site and percentage of new customers data.
D . Include a scatter chart using the site and the percent of new customers data.

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

This is because a bar chart is a type of chart that shows the value or the amount of a single variable for different categories or groups, such as the percentage of new customers for different sites in this case. A bar chart can be used to display and analyze the comparison, ranking, or proportion among the categories or groups, as well as identify any differences, similarities, or outliers in the data. For example, a bar chart can show which site has the highest or lowest percentage of new customers, as well as show how much each site contributes to the total percentage of new customers. The other types of charts are not the best charts to display the data.

Here is why:

A line chart is a type of chart that shows the change or the trend of a single variable over time, such as the percentage of new customers over months or years in this case. A line chart can be used to display and analyze the movement, cycle, or pattern of the variable, as well as identify any peaks, valleys, or fluctuations in the data. For example, a line chart can show how the percentage of new customers increases or decreases over time, as well as show if there are any seasonal or periodic variations in the data.

A pie chart is a type of chart that shows the proportion or the percentage of a single variable for different categories or groups, such as the percentage of new customers for different sites in this case. A pie chart can be used to display and analyze the composition, distribution, or share of the variable, as well as identify any segments, slices, or fractions in the data. For example, a pie chart can show how much each site represents of the total percentage of new customers, as well as show if there are any dominant or minor sites in the data.

A scatter chart is a type of chart that shows the relationship between two variables for each observation or unit in a data set, such as the percentage of new customers and another variable for each site in this case. A scatter chart can be used to display and analyze the correlation, trend, or pattern among the variables, as well as identify any outliers or clusters in the data. For example, a scatter chart can show if there is a positive, negative, or no correlation between the percentage of new customers and another variable, such as sales revenue or customer satisfaction.

Question #12

Which of the following is used for calculations and pivot tables?

A . IBM SPSS
B . SAS
C . Microsoft Excel
D . Domo

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

This is because Microsoft Excel is a type of software application that allows users to create, edit, and analyze data in spreadsheets, which are composed of rows and columns of cells that can store various types of data, such as numbers, text, or formulas. Microsoft Excel can be used for calculations and pivot tables, which are two common features or functions in data analysis. Calculations are mathematical operations or expressions that can be performed on the data in the cells, such as addition, subtraction, multiplication, division, average, sum, etc. Pivot tables are interactive tables that can summarize and display the data in different ways, such as by grouping, filtering, sorting, or aggregating the data based on various criteria or categories. The other software applications are not used for calculations and pivot tables.

Here is why:

IBM SPSS is a type of software application that allows users to perform statistical analysis and modeling on data sets, such as regression, correlation, ANOVA, etc. IBM SPSS does not use spreadsheets or cells to store or manipulate data, but rather uses data views or variable views to display the data in rows and columns. IBM SPSS does not have pivot tables as a feature or function, but rather has output views or charts to display the results of the analysis.

SAS is a type of software application that allows users to perform data management and analysis using a programming language that consists of statements and commands. SAS does not use spreadsheets or cells to store or manipulate data, but rather uses data sets or tables that are stored in libraries or folders. SAS does not have pivot tables as a feature or function, but rather has procedures or macros that can produce summary tables or reports based on the data.

Domo is a type of software application that allows users to create and share dashboards and visualizations that display data from various sources and systems, such as databases, cloud services, or web applications. Domo does not use spreadsheets or cells to store or manipulate data, but rather uses connectors or APIs to access and integrate the data from different sources. Domo does not have pivot tables as a feature or function, but rather has cards or widgets that can show different aspects or metrics of the data.

Question #13

A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales.

If the report will be published on November 1, 2020, which of the following months shouts the report cover?

A . October 1, 2019 to October 31, 2020
B . October 31, 2020 to November 1, 2021
C . November 1, 2019 to October 31, 2020
D . October 31, 2019 to October 31, 2020

Reveal Solution Hide Solution

Question #14

Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

A . Duplicate data
B . Missing data
C . Data outliers
D . Invalid data type

Reveal Solution Hide Solution

Question #15

A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment.

Which of the following should the data analyst use to BEST communicate this information to the manager?

A . A real-time monitor that allows the manager to view performance the day the campaign was launched
B . A sell-service dashboard that allows the manager to look at the company’s annual budget performance
C . A spreadsheet of the raw data from all marketing campaigns and channels
D . A summary with statistics, conclusions, and recommendations from the data analyst

Reveal Solution Hide Solution

Question #16

Which of the following value is the measure of dispersion "range" between the scores of ten students in a test.

The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

A . 90
B . 60
C . 70
D . 80

Reveal Solution Hide Solution

Question #17

An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence.

Which of the following is the MOST important to convey that information?

A . The date of the dashboard build
B . The data refresh date
C . A report summary
D . Frequently asked questions

Reveal Solution Hide Solution

Question #18

Which of the following BEST describes standard deviation?

A . A measure that is used to establish a relationship between two variables
B . A measure of how data is distributed
C . A measure of the amount of dispersion of a set of values
D . A measure that is used to find the significant difference between variables

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

A measure of the amount of dispersion of a set of values. This is because standard deviation is a type of statistical measure that quantifies how much the values in a data set vary or deviate from the mean or the average of the data set. Standard deviation can be used to describe the spread or the distribution of the data, as well as to identify any outliers or extreme values in the data. For example, a low standard deviation indicates that the values are close to the mean, while a high standard deviation indicates that the values are far from the mean. The other options are not correct descriptions of standard deviation.

Here is why:

A measure that is used to establish a relationship between two variables is not a correct description of standard deviation, but rather a description of correlation or regression, which are types of statistical measures that quantify how two variables are related or associated with each other. Correlation or regression can be used to test or model the dependence or the influence of one variable on another variable, as well as to predict or estimate the value of one variable based on the value of another variable.

A measure of how data is distributed is not a correct description of standard deviation, but rather a description of frequency or probability, which are types of statistical measures that quantify how often or how likely a value or an event occurs in a data set. Frequency or probability can be used to describe the occurrence or the chance of the data, as well as to compare or contrast different categories or groups of the data.

A measure that is used to find the significant difference between variables is not a correct description of standard deviation, but rather a description of hypothesis testing or inferential statistics, which are types of statistical methods that use sample data to make generalizations or conclusions about a population or a parameter. Hypothesis testing or inferential statistics can be used to test or verify a claim or an assumption about the data, as well as to measure the confidence or the error of the estimation.

Question #19

The number of phone calls that the call center receives in a day is an example of:

A . continuous data.
B . categorical data.
C . ordinal data.
D . discrete data.

Reveal Solution Hide Solution

Question #20

Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year’s Q3 promotion.

Which of the following date parameters should the analyst use?

A . 2019 vs. YTD 2020
B . Q3 2019 vs. Q3 2020
C . YTD 2019 vs. YTD 2020
D . Q4 2019 vs. Q3 2020

Reveal Solution Hide Solution

[email protected]

Monday - Sunday 9:00am - 6:00pm

CompTIA DA0-001 Real Exam Questions

The questions for DA0-001 were last updated at Dec 01,2024.

[email protected]

Monday - Sunday 9:00am - 6:00pm