Question 1

A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the analyst consider? (Select two).

Options :

A : Real-time

B : Snapshot

C : Dynamic

D : Static

E : Ad hoc

F : Time series

Answer: A,C

Question 2

A company gives users adequate data access permissions to allow them to fulfill their duties but nothing more. Which of the following concepts best describes this practice?

Options :

A : Active Directory

B : Hierarchical access

C : Zero Trust

D : Least privilege

Answer: D

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

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 5

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

Free DA0-002 Mock Exam – Practice Online Confidently

Buying Options: