DA0-002 Exam Questions

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 data analyst is creating a forecast for a product line introduced early last year. Which of the following should the analyst use to create projected sales and customer satisfacti...

A company wants to limit an employee's access to a production environment. Which of the following access control practices is the best to implement?

A data analyst encounters an issue with new software and a code that they are using. The analyst includes print statements in the code to try to identify the issue, without success...

A data analyst receives a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees' birth months. Which of the following i...

A sales manager wants a dashboard that shows sales aggregated by region and identifies high- volume sales by salesperson per region. Which of the following communication techniques...

Before distributing a report, a marketing analyst notices that the total distinct promotional email messages is less than the combined total of emails sent. Which of the following...

A data analyst needs to create a combined report that includes information from the following two tables: Which of the following query methods should the analyst use for this task?

Given the following tables: Which of the following is the best option to display output from FirstName and LastName as FullName?

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

The following SQL code returns an error in the program console: SELECT firstName, lastName, SUM(income) FROM companyRoster SORT BY lastName, income Which of the following changes a...

Which of the following is the most efficient to use when programming repeatable tasks?

Which of the following data repositories stores unaltered data?

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

A data analyst needs to identify outliers from a given dataset. Which of the following visualizations is the best way to identify outliers?

A data analyst is preparing a survey for Paralympic Games athletes. Which of the following should the analyst consider when creating this survey?

The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the dataset. Given the foll...

Which of the following best explains the purpose of data lineage?

A data analyst needs to modify a dashboard that was created by another employee. Upon opening the dashboard, the analyst notices that the information is not loading properly. Which...

A data analyst wants to use the following tables to find all the customers who have not placed an order: Which of the following SQL statements is the best way to accomplish this ta...

Given the following dataset: Which of the following is the mode?

A data analyst calculated the average score per student without making any changes to the following table: Which of the following exploration techniques should the analyst have con...

A marketing firm wants to find the average age of its consumers to better promote its products. Given the following dataset: Which of the following is the mean of the consumer ages...

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

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

Which of the following is a NoSQL database?

A data analyst needs to provide a weekly sales report for the Chief Financial Officer. Which of the following delivery methods is the most appropriate?

An analyst compiled data on the preferred color of various models of cars over a period of time. Which of the following visualizations is best way to present this information?

Which of the following should a data analyst use to most efficiently gather recently released statistical information from one site?

A complex report is being created from a database. Within the database the storage location of the orders, packaging, and logistics details is unclear. The table's attributes names...

Which of the following report types is considered the most important in a legal and compliance context?

Giving the following values: 47 59 83 33 51 39 52 Which of the following is the mean?

Which of the following is the best tool for creating a dynamic dashboard?

Which of the following best describes the semi-structured data that is gathered when web scraping?

A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analys...

Which of the following explains the purpose of UAT?

A data analyst is generating a custom report for a Chief Executive Officer's executive meeting. Later, the analyst learns that other custom reports will be required for future exec...

A grocery store wants to view the revenue from the previous year, highlighting individual departments. Which of the following is the most appropriate chart to communicate this info...

A data analyst receives the following sales data for a convenience store: The analyst needs to provide information on the products that contain chocolate. Which of the following Re...

A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide employee outreach. Which of the following report types is the bes...

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

A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the an...

A data analyst receives a request for the current employee head count and runs the following SQL statement: SELECT COUNT(EMPLOYEE_ID) FROM JOBS The returned head count is higher th...

Which of the following situations best describes an unclear and inconsistent column definition that can lead to an enabled analysis process?

An analyst is developing a form to collect data from clients. Which of the following techniques should the analyst use to best ensure data integrity?

Which of the following data integration concepts should be used if only new data is being added to a table since the previous load?

Which of the following statistical measures is the most suitable and simple measure of the strengthsimple measure of the strength and direction of the linear relationship between p...

An analyst needs to produce a final dataset using the following tables: The expected output should be formatted as follows: | CourseID | SectionNumber | StudentID | FirstName | Las...

Which of the following data repositories stores unstructured and structured data?