DA0-001 Free Questions

Question #21

A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers.

Which of the following would be the BEST method to automate and ensure successful delivery for this task?

A . Use scheduled report delivery.
B . Implement subscription access delivery.
C . Print out a copy.
D . Upload the report to the server.

Reveal Solution Hide Solution

Question #22

An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe.

Which of the following is the NEXT step the analyst should take in the dashboard creation process?

A . Optimize the dashboard.
B . Create subscriptions.
C . Get stakeholder approval.
D . Deploy to production.

Reveal Solution Hide Solution

Question #23

Which of the following contains alphanumeric values?

A . 10.1Ε²
B . 13.6
C . 1347
D . A3J7

Reveal Solution Hide Solution

Question #24

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 #25

Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders.

Which one of the following tools is least likely to meet her needs?

A . QuickSight.
B . Tableau.
C . Power BI.
D . SPSS Modeler.

Reveal Solution Hide Solution

Question #26

Which of the following would be used to store unstructured data from different sources?

A . A data lake
B . A database management system
C . A database
D . A data warehouse

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

This is because a data lake is a type of storage system that stores unstructured data from different sources, such as text, images, audio, video, etc. A data lake can be used to store unstructured data from different sources by using a schema-on-read approach, which means that it does not impose any structure or format on the data when it is stored, but rather applies it when it is read or accessed. A data lake can also be used to store unstructured data from different sources by using a distributed file system, such as Hadoop, which means that it can store large volumes and varieties of data across multiple servers or nodes. The other storage systems are not used to store unstructured data from different sources.

Here is why:

A database management system is a type of software application that manages and controls databases, which are collections of structured or semi-structured data that are organized into tables, rows, and columns. A database management system is not used to store unstructured data from different sources, but rather to store structured or semi-structured data from specific sources by using a schema-on-write approach, which means that it imposes a structure or format on the data when it is stored, and requires it to follow certain rules and constraints, such as primary keys, foreign keys, or referential integrity.

A database is a type of storage system that stores structured or semi-structured data that are organized into tables, rows, and columns. A database is not used to store unstructured data from different sources, but rather to store structured or semi-structured data from specific sources by using a relational model, which means that it establishes and maintains relationships between different tables based on common columns or keys. A database can also be used to store structured or semi-structured data from specific sources by using a query language, such as SQL, which means that it can access and manipulate the data using statements or commands.

A data warehouse is a type of storage system that stores structured or semi-structured data that are integrated and aggregated from different sources or systems, such as databases, cloud services, or web applications. A data warehouse is not used to store unstructured data from different sources, but rather to store structured or semi-structured data from various sources by using an ETL process, which means that it extracts, transforms, and loads the data into a common format, structure, or schema. A data warehouse can also be used to store structured or semi-structured data from various sources by using an OLAP model, which means that it supports online analytical processing of the data using multidimensional cubes or queries.

Question #27

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 #28

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 #29

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 #30

Angela is aggregating data from CRM system with data from an employee system.

While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system.

What kind of issues is Angela facing? Choose the best answer.

A . ETL process.
B . Record linkage.
C . ELT process.
D . System integration.

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 02,2024.

[email protected]

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