ExamGecko
Home Home / CompTIA / DA0-001

CompTIA DA0-001 Practice Test - Questions Answers, Page 10

Question list
Search
Search

List of questions

Search

Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average.

What should Andy's null hypothesis be?

A.
People who receive electronic coupons spend more on average.
A.
People who receive electronic coupons spend more on average.
Answers
B.
People who receive electronic coupons spend less on average.
B.
People who receive electronic coupons spend less on average.
Answers
C.
People who receive electronic coupons do not spend more on average.
C.
People who receive electronic coupons do not spend more on average.
Answers
D.
People who do not receive electronic coupons spend more on average.
D.
People who do not receive electronic coupons spend more on average.
Answers
Suggested answer: C

Explanation:

The null hypothesis presumes the status quo. Andy is testing whether or not people who receive an electronic coupon spend more on average, so, the null hypothesis states that people who receive the coupon do spend more on average.

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.
A.
QuickSight.
Answers
B.
Tableau.
B.
Tableau.
Answers
C.
Power BI.
C.
Power BI.
Answers
D.
SPSS Modeler.
D.
SPSS Modeler.
Answers
Suggested answer: D

Explanation:

SPSS Modeler.

QuickSight, Tableau, and Power BI are all powerful analytics and reporting tools that can pull data from a variety of sources. SPSS Modeler is a powerful predictive analytics platform that is designed to bring predictive intelligence to decisions made by individuals, groups, systems and your enterprise.

Daniel is using the structured Query language to work with data stored in relational database.

He would like to add several new rows to a database table.

What command should he use?

A.
SELECT.
A.
SELECT.
Answers
B.
ALTER.
B.
ALTER.
Answers
C.
INSERT.
C.
INSERT.
Answers
D.
UPDATE.
D.
UPDATE.
Answers
Suggested answer: C

Explanation:

INSERT

The INSERT command is used to add new records to a database table.

The SELECT command is used to retrieve information from a database. It's the most commonly used command in SQL because it is used to pose queries to the database and retrieve the data that you're interested in working with.

The UPDATE command is used to modify rows in the database.

The CREATE command is used to create a new table within your database or a new database on your server.

Jhon is working on an ELT process that sources data from six different source systems.

Looking at the source data, he finds that data about the sample people exists in two of six systems.

What does he have to make sure he checks for in his ELT process?

Choose the best answer.

A.
Duplicate Data.
A.
Duplicate Data.
Answers
B.
Redundant Data.
B.
Redundant Data.
Answers
C.
Invalid Data.
C.
Invalid Data.
Answers
D.
Missing Data.
D.
Missing Data.
Answers
Suggested answer: C

Explanation:

Duplicate Data.

While invalid, redundant, or missing data are all valid concerns, data about people exists in two of the six systems. As such, Jhon needs to account for duplicate data issues.

Samantha needs to share a list of her organization's top 50 customers with the VP of sales.

She would like to include the name of the customer, the business they represent, their contact information, and their total sales over the past year.

The VP does not have any specialized analytics skills or software but would like to make some personal notes on the dataset.

What would be the best tool for Samantha to use to share this information?

A.
Power BI.
A.
Power BI.
Answers
B.
Microsoft Excel.
B.
Microsoft Excel.
Answers
C.
Minitab.
C.
Minitab.
Answers
D.
SAS.
D.
SAS.
Answers
Suggested answer: B

Explanation:

Microsoft Excel.

This scenario presents a very simple use case where the business leader needs a dataset in an easyto-access form and will not be performing any detailed analysis.

A simple spreadsheet, such as Microsoft Excel, would be the best tool for this job.

There is no need to use a statistical analysis package, such as SAS or Minitab, as this would likely confuse the VP without adding any value. The same is true of an integrated analytics suite, such as Power BI.

Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.

Which of the following systems is the most appropriate?

Choose the best answer.

A.
Data mart.
A.
Data mart.
Answers
B.
OLAP.
B.
OLAP.
Answers
C.
Data Warehouse.
C.
Data Warehouse.
Answers
D.
OLTP.
D.
OLTP.
Answers
Suggested answer:

Explanation:

Correct answer: C. Data Warehouse.

Data warehouse bring together data from multiple systems used by an organization.

A data mart is too narrow, as Alex needs data from across multiple divisions.

OLAP is a broad term of analytical processing, and OLTP systems are transactional and not ideal for this task.

Analytics reports should follow corporate style guidelines.

A.
True.
A.
True.
Answers
B.
False.
B.
False.
Answers
Suggested answer: A

Which one of the following is a measure of dispersion?

A.
Variance.
A.
Variance.
Answers
B.
Mode.
B.
Mode.
Answers
C.
Median.
C.
Median.
Answers
D.
Mean.
D.
Mean.
Answers
Suggested answer: A

Which one of the following in NOT a common data integration tool?

A.
XSS
A.
XSS
Answers
B.
ELT
B.
ELT
Answers
C.
ETL
C.
ETL
Answers
D.
APIs
D.
APIs
Answers
Suggested answer: A

Explanation:

Cross-site Scripting (XSS) is a security vulnerability usually found in websites and/or web applications that accept user input.

XSS is a client-side vulnerability that targets other application users, while SQL injection is a serverside vulnerability that targets the application's database. How do I prevent XSS in PHP? Filter your inputs with a whitelist of allowed characters and use type hints or type casting.

Which one of the following is a common data warehouse schema?

A.
Snowflake.
A.
Snowflake.
Answers
B.
Square.
B.
Square.
Answers
C.
Spiral.
C.
Spiral.
Answers
D.
Sphere.
D.
Sphere.
Answers
Suggested answer: A

Explanation:

Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. The Snowflake data platform is not built on any existing database technology or "big data" software platforms such as Hadoop.

Total 263 questions
Go to page: of 27