DA0-002 Exam Questions

A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call center. The traffic data is current, but the mean response time has not update...

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

A data analyst receives four files that need to be unified into a single spreadsheet for further analysis. All of the files have the same structure, number of columns, and field na...

A data analyst 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...

A data analyst receives a notification that a customized report is taking too long to load. After reviewing the system, the analyst does not find technical or operational issues. W...

Which of the following best describes the reason an analyst would reference a data dictionary versus a source's metadata?

A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?

A data analyst pulls a table similar to the following one: Which of the following best explains the data issue with TypeID?

Which of the following AI types is the best option for time-series forecasting?

A data analyst is following up on a recent, company-wide data audit of customer invoice data. Which of the following is the best option for the analyst to use?

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...

A data analyst is analyzing the following dataset: Which of the following methods should the analyst use to determine the total cost for each transaction?

A business intelligence analyst is creating an employee retention dashboard that looks at data from the last five years. The analyst is interested in identifying patterns that can...

Which of the following elements is the most important to include in a dashboard for internal technical audiences?

A data analyst creates a report, and some of the fields are empty. Which of the following conditions should the analyst add to a query to provide a list of all the records with emp...

A data analyst needs to get an accurate idea of how data components are automated. Which of the following types of documentation should the analyst review first?

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 data analyst needs to join together a table data source and a web API data source using Python. Which of the following is the best way to accomplish this task?

A data analyst creates a report that identifies the middle 50% of the collected data. Which of the following best describes the analyst's findings?

A sales manager wants to understand how sales are trending year over year. Which of the following chart types is the most appropriate to display the information?

A data analyst deployed a report for public access. A user states that the report is not showing the latest information, even though the user updated the source an hour ago. Which...

A data professional wants to identify all customers who made a purchase in January. Given the following table: Which of the following types of functions should the professional use...

Which of the following data sources makes online data consumption easier?

A user needs a report that shows the main causes of customer churn rate in a three-year period. Which of the following methods provides this information?

The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table: Which of the follo...

A company reports on seven years of data in a sales dashboard. The dashboard pulls from a sales database that has 30 years of data. The dashboard performance is slow. Which of the...

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

A data analyst is designing a report for the business review team. The team lists the following requirements for the report: - Specific data points - Color branding - Labels and te...

A data analyst needs to remove all duplicate values between two tables, "Employees" and "Managers," using SQL SELECT statements. Which of the following should the analyst use for t...

Which of the following tables holds relational keys and numeric values?

A data analyst is creating a pivot table for a large dataset for an upcoming board meeting. Which of the following is the purpose of the pivot table?

An administrator needs to design a table that will include foreign words. Which of the following is the best option for storing non-native language characters?

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?

Which of the following file types separates data using a delimiter?

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

A data analyst needs to create a report that anticipates the number of calls received daily. Which of the following is the best statistical method to use?

A product goes viral on social media, creating high demand. Distribution channels are facing supply chain issues because the testing and training models that are used for sales for...

Given the following table: Which of the following data types should an analyst use for the numeric values in the Value column?

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 presen...

Which of the following best describes the function of a data type?

A project manager requests an unscheduled report that provides a list of clients. Which of the following frequencies is best for this report?

Which of the following supports capabilities such as automatic versioning, corruption checks, KPIs, and user authentication?

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?

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

Due to new reporting requirements, a data analyst must add new classification codes to historical data. Which of the following is the best technique for this task?

A company's entire server environment is located at the company's headquarters. Which of the following describes this type of environment?

An analyst must use the same data to create reports for police patrol supervisors, the city council, and a public website. Which of the following is the best way to differentiate t...

Which of the following is found in metadata?

A table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data anal...

A Chief Executive Officer requests a report that must: - Summarize the company metrics in a simple way. - Be clear and concise. - Be easily understood by all company levels. - Be a...