DA0-002 Real Exam Questions and Verified Answers

Question 1 Single choice

A manager needs a report to be sent by email every Monday for the next six months.

Which of the following is the best way to accomplish this task?

A
Building self-service access
B
Creating a data snapshot
C
Developing a recurring process
D
Waiting for the request each week

Show answer and explanation

Correct answer: C

Question 2 Single choice

Which of the following is a difference between a primary key and a unique key?

A
A unique key cannot take null values, whereas a primary key can take null values.
B
There can be only one primary key in a data set, whereas there can be multiple unique keys.
C
A primary key can take a value more than once, whereas a unique key cannot take a value more than once.
D
A primary key cannot be a date variable, whereas a unique key can be.

Show answer and explanation

Correct answer: B

Question 3 Single choice

A data analyst troubleshoots a dashboard every day for a week.

Which of the following techniques best addresses how to validate the data moving forward?

A
Inquiring about structure changes
B
Setting up monitoring alerts
C
Reaching out to users daily
D
Rebuilding the dashboard

Show answer and explanation

Correct answer: B

Question 4 Single choice

A data analyst receives an email from the IT department about renewing the company password, and the analyst follows the password reset link as required. Later in the week, the analyst receives the following notification when running a recurring analysis that connects to the database:

Log-in failed for user `<username>'

Which of the following is most likely the reason for this issue?

A
The company changed its database authentication method.
B
The password expiration process locked the account.
C
The analyst did not change the password used to launch the report.
D
The company is experiencing issues with password replication.

Show answer and explanation

Correct answer: C

Question 5 Single choice

Which of the following reports can be used when insight into operational performance is needed each Wednesday?

A
Static report
B
Tactical report
C
Recurring report
D
Ad hoc report

Show answer and explanation

Correct answer: C

Question 6 Single choice

A data analyst is evaluating all conditions in a query.

Which of the following is the best logical function to accomplish this task?

A
OR
B
NOT
C
AND
D
IF

Show answer and explanation

Correct answer: C

Question 7 Single choice

A company's entire server environment is located at the company's headquarters.

Which of the following describes this type of environment?

A
Cloud
B
On-premises
C
Public
D
Hybrid

Show answer and explanation

Correct answer: B

Question 8 Single choice

A data company needs a visualization that shows the availability zones from the last ten years and any future availability zones that the company will be using in the next five years.

Which of thefollowing is the most appropriate visualization to display this information?

A
Bar chart
B
Mosaic plot
C
Map
D
Pie chart

Show answer and explanation

Correct answer: C

Question 9 Single choice

An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

A
Aggregate
B
Logical
C
Date
D
Sort

Show answer and explanation

Correct answer: B

Question 10 Single choice

Which of the following is an example of a at flat file?

A
CSV file
B
PDF file
C
JSON file
D
JPEG file

Show answer and explanation

Correct answer: D