DA0-002Preview

Which of the following makes data unreadable without a required key?

An analyst is building a reporting deck. The deck must include tracking and visualizing metrics and row-level security. Which of the following actions should the analyst take after meeting the initial requirements?

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

A data analyst needs to use one table's data to refine data selection from a second table. Which of the following is the most efficient way?

A data analysis team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table:

Which of the following techniques should the team use for this task?

Which of the following is found in metadata?

A data analyst is analyzing the following data set:

Which of the following methods should the analyst use to determine the total cost for each transaction?

Which of the following allows the transfer of isolated applications to multiple environments?

A data breach occurs at a company. Which of the following actions should be taken?

A data analyst is modeling a new data warehouse to analyze sales. One of the requirements is to analyze sales by region. Which of the following best describes the region table?

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

A data analyst must combine service calls into low-, medium-, and high-priority levels in order to analyze organizational responses. Which of the following techniques should the analyst use for this task?

Which of the following explains the purpose of UAT?

A data analyst notices that a certain field that stores customer IDs in a defined format has incorrect values. Which of the following could help the analyst identify the issue?

Which of the following tools would a data analyst most likely use to modify a simple data connection property in a configuration file?

After a database upgrade, a report using datetime calculations does not complete due to an arithmetic overflow error. Which of the following is the best way for a data analyst to troubleshoot the issue?

A data analyst is preparing a report for external users. The analyst must ensure that visuals can be identified as belonging to the organization. Which of the following should the analyst add to the report to best meet this requirement?

A data analyst is evaluating all conditions in a query. Which of the following is the best logical function to accomplish this task?

A data analyst is helping a company achieve its strategic goals. Which of the following types of analytics should the analyst incorporate into the dashboards and tools delivered to the company?

Given the following data set:

Which of the following is the mode?

A data analyst needs to join data from two tables in a way that all data from one table is shown even if a matching row is not in the other table. Which of the following should the analyst use to achieve the desired output?

Which of the following best represents a type of infrastructure that requires a company to purchase and maintain all of its own servers?

A data analyst receives a flat file that includes dates. The analyst needs to calculate the number of days from the dates on the file to the current date. Which of the following is the best way to complete this task?

A manager wants a report that contains the days off for each direct report. The manager needs this report to always be up-to-date with the latest data. Which of the following describes the refresh frequency that the manager is requesting?

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?