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 engineer needs to create a reporting solution that has predefined filters and the ability to

download .csv files. Which of the following is the best solution?

Options :

A : Developing a dynamic dashboard that refreshes daily

B : Generating a weekly executive summary

C : Creating a self-service portal on the company's intranet

D : Building an email template to request ad hoc reports

Answer: C

Question 3

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 4

The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the dataset. Given the following table: Employee_ID Level Salary 001 1 10000 2 20000 003 2 256000 004 2 125000 001 1 10000 2 20000 Which of the following SQL statements resolves this issue?

Options :

A : SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000

B : SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000

C : SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000

D : SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000

Answer: B

Question 5

Which of the following best enables the retrieval and manipulation of data that is stored in a relational database?

Options :

A : XML

B : SQL

C : Excel

D : JavaScript

Answer: B

Free DA0-002 Mock Exam – Practice Online Confidently

Buying Options: