Question 1

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 2

A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?

Options :

A : Match the records of the related columns and merge the tables.

B : Create a cluster to facilitate data integration between the tables.

C : Explode both tables to identify unique values and reorder the fields in one table.

D : Append the values of the matching columns and concatenate the other data fields.

Answer: A

Question 3

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 4

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

Options :

A : Fact

B : Graph

C : Dimensional

D : Transactional

Answer: A

Question 5

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

Higher Test Marks with Free Online DA0-002 Exam Practice

Buying Options: