Question 1

A data analyst is designing a report for the business review team. The team lists the following requirements for the report: Specific data points Color branding Labels and terminology Suggested charts and tables Which of the following components is missing from the requirements?

Options :

A : Source validation

B : Design elements

C : Delivery method

D : Report type

Answer: C

Question 2

The following SQL code returns an error in the program console: SELECT firstName, lastName, SUM(income) FROM companyRoster SORT BY lastName, income Which of the following changes allows this SQL code to run?

Options :

A : SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) 10000000

B : SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName

C : SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income

D : SELECT firstName, lastName, SUM(income) FROM companyRoster

Answer: B

Question 3

An analyst needs to create a collection of dashboards for multiple teams within their organization. Which of the following should the analyst do first before starting the project?

Options :

A : Evaluate the user persona type for the dashboards.

B : Determine the number of team members who need to access the dashboards.

C : Determine the delivery method of the dashboards.

D : Evaluate the KPIs for the dashboards.

Answer: A

Question 4

Which of the following best describes the semi-structured data that is gathered when web scraping?

Options :

A : JSON

B : CSV

C : CSS

D : HTML

Answer: A

Question 5

Which of the following tables holds relational keys and numeric values?

Options :

A : Fact

B : Graph

C : Dimensional

D : Transactional

Answer: A

Free DA0-002 Mock Exam – Practice Online Confidently

Buying Options: