DA0-001 Exam Questions

An analyst is currently working on a ticket to revamp a company-wide dashboard that has been in use for five years. Which of the following should be the first step in the developme...

Which of the following is the best reason for removing data outliers?

After the daily ETL jobs are completed, the data in the reports does not appear complete, and a lot of data seems to be missing. Which of the following concepts should be used to a...

A client wants a new report that will be automatically emailed to all global sales teams on a weekly basis. Each sales team must be able to view the sales for its region and the co...

Given the following data sample: Which of the following best describes the data quality issue?

Which of the following is an example of discrete data?

Which of the following defines the policies and procedures for managing the master data?

Which of the following occurs if a 90% confidence interval increases to 95%?

An analyst reviews the following table: Which of the following data types is represented in the values in the RefNo column?

An analyst is explaining the company's financial systems and reporting tools to a new coworker. Which of the following data quality dimensions are the most important? (Choose three...

A data engineer is creating a database field to capture whether a customer likes vanilla ice cream. Which of the following data types is the best to capture this information?

An analyst is updating a customer contacts database with information obtained from a survey of new customers. Which of the following data manipulation techniques should the analyst...

A database administrator is required to mask certain table columns containing PII in order to comply with the company privacy policy. Which of the following are the most likely typ...

An analyst conducted a preliminary analysis for a data set and identified several patterns and anomalies. Which of the following analysis techniques did the analyst use?

Which of the following activities occurs during the ETL process?

Which of the following data analysis tools increases the efficiency of data visualizations?

Given the following data set: Which of the following is the best reason for cleansing the data?

Which of the following are the first steps a company should take after discovering a data breach? (Choose two.)

Which of the following best describes a 95% confidence interval?

A healthcare data analyst notices that one data set in the column for BloodPressure contains several outliers that need to be replaced with meaningful values. Which of the followin...

Which of the following analysis techniques is an unsupervised data mining process?

Which of the following types of analysis would be best for an analyst to use to examine the relationships between authors who cited other authors in a library of research papers?

A reporting analyst needs to create a report that refreshes automatically and is accessible to the entire sales organization. Which of the following tools is the most appropriate t...

Which of the following is the most appropriate to consider when creating a schema of a central group broken into detailed subcategories?

Which of the following is the best reason to use database views instead of tables?

Which of the following is the median of the number set: 3, 7, 5, 6, 9?

A data set has the following values: Which of the following is the best reason for cleansing the data?

An analyst needs to join two data sets that compare vehicle weights. One data set is in pounds, and the other has various units of measure. Which of the following should the analys...

A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the best access control m...

A data analyst needs to observe the relationship between two numeric variables and identify the clustering pattern as well as the outliers. Which of the following visualizations sh...

An analyst needs to know what data an organization possesses. Which of the following is the best document for the analyst to consult?

A data analyst who works for a government agency is required to obtain the average income of citizens. The list of citizens is given in the following table: A value for one citizen...

Given the following table: Which of the following describes the data quality issues with the age data?

An organization wants to evaluate whether project activities are within the set projections and in line to meet the desired project targets. Which of the following types of analysi...

Which of the following data types should an analyst use to provide the most flexibility when recording emails on a form?

Which of the following explains why standardization of data field names is important to master data management concepts?

A data analyst is working for a shipping company and calculating the volume of boxes according to the following formula: volume = height ?width ?depth. Which of the following varia...

A business intelligence engineer needs to reduce the size of a data model for reporting purposes. The data set contains more than one million rows, and the table has a date-time co...

Given the following data: Which of the following best describes the main issue in the data set?

An analyst for a small business with multiple locations is using each location's quarterly sales reports from last year to create a single revenue report for the year. Which of the...

Which of the following best describe qualitative data? (Select two).

Which of the following techniques should an analyst use to analyze a data set to get a snapshot of basic measures of central tendency?

A database administrator needs to increase performance on a large dimension table. Which of the following is the best way to accomplish this task?

A data analyst is setting up a data dashboard to monitor several ETL data streams to ensure that data is complete for later analysis. Which of the following audiences should the an...

A sales manager requested a report that contains the first name, last name, and phone number of all the company's customers and employees. The data engineer needs to return all the...

Which of the following data types is best for representing count data?

Which of the following types of dashboards should a business intelligence engineer develop in order to provide information about failed data pipelines?

Which of the following is concatenate typically used to combine?

A dataset requires an analysis for investigating and discovering abnormalities. Which of the following best describes the nature of the exploratory analysis conducted?

A company needs a report that provides executives an overview and regional managers with both an overview and specifics. Which of the following reporting elements will achieve thes...