QUESTION 60
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?

QUESTION 61
A developer builds an online survey that requires all questions to have an answer. Which of the following inconsistencies does this setting prevent?

QUESTION 62
Which of the following pieces of information, if made public, results in a data privacy violation?

QUESTION 63
An analyst needs to produce a final dataset using the following tables:

The expected output should be formatted as follows:
| CourseID | SectionNumber | StudentID | FirstName | LastName |
Which of the following actions is the best way to produce the requested output?

QUESTION 64
A data analyst is working on an initial analysis of the dataset in the following table:
DateTime
Count
2024-01-01
12
2024-01-02
245
2024-01-02
13
2024-01-03
13
2024-01-03
12
00:00:00
12
Which of the following issues should the analyst flag in the data report?

QUESTION 65
A sales analyst is using the following table to produce a report on January sales data:

Which of the following inconsistencies is present in the data set?

QUESTION 66
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?

QUESTION 67
The human resources department wants to understand the relationship between the ages and incomes of all employees. Which of the following graphics is the most appropriate to present the analysis?

QUESTION 68
Which of the following data repositories stores unformatted data in its original, raw form?

QUESTION 69
A data analyst wants to understand several datasets at the variable level. Which of the following should the analyst consult to find this information?

QUESTION 70
A database administrator needs to implement security triggers for an organization’s user information database.
Which of the following data classifications is the administrator most likely using? (Select two).

QUESTION 71
Which of the following is the best example of a slowly changing dimension for a data warehouse?

QUESTION 72
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?

QUESTION 73
Which of the following is a flat file data format?

QUESTION 74
A company has a document that includes the names of key metrics and the standard for how those metrics are calculated company-wide. Which of the following describes this documentation?

QUESTION 75
Which of the following allows a data analyst to send out a spreadsheet containing sensitive information without revealing personal details?

QUESTION 76
A data analyst is creating a new dataset that involves bringing together the following datasets:

Which of the following would be the output if the data analyst does a FULL JOIN?

QUESTION 77
A data analyst learns that a report detailing employee sales is reflecting sales only for the current month. Which of the following is the most likely cause?