DA0-001 Exam Questions

A product department wants to review the performance of all products that launched in 2019 in the Midwest. The data provided in the table below is for all sales throughout the enti...

Which of the following inferential statistical methods would be used to determine if there is a significant difference between the means of two groups?

A data analyst works for a condominium development company. The company is undergoing unit number changes. Which of the following would be MOST appropriate to include on the unit i...

Which of the following will always result in a null value when aggregate operations are applied?

The accounting team has requested a series of self-serve, dynamic reports. Aside from the reporting time frame, the report criteria are identical. Which of the following should the...

Which of the following BEST describes an ad hoc report?

A home builder is offering a 30% discount on condominium units. Given the table below: Which of the following is the range of savings for the units listed in the table?

A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

A data set was recorded using multimedia technology. Which of the following is a necessary step on the way to interpretation?

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

An analyst modified a data set that had a number of issues. Given the original and modified versions: Which of the following data manipulation techniques did the analyst use?

Which of the following best describes a difference between JSON and XML?

A data analyst is attempting to understand how ice cream consumption is affected by different attributes. such as cost, temperature. and income level. Which of the following regres...

An analyst is building a new dashboard for a user. After an initial conversation with the user. the analyst created a mock-up of the dashboard. Which of the following best explains...

Which of the following techniques is used to quantify data?

A research analyst collects ten data points from 1.000 specimens. The analyst will not need any additional data to complete the analysis and will not need to retrieve information b...

Which of the following best describes the process of examining data for statistics and information about the data?

A financial analyst is creating a daily billing report for a company. One night, the company's data warehouse did not update the data, which caused the data to be reported incorrec...

An analyst is creating a resource to improve users' experience when they select specific records based on particular dates. Which of the following should the analyst use to create...

Which of the following is an example of structured data?

A data analyst is working with a team to create a dashboard for a client who requires on-demand access. Which of the following is the best delivery method to support the clients' r...

Which of the following is an example of a flat file?

Which of following is a non-relational database?

A data analyst is performing a data merge within a spreadsheet using the tables below: The analyst is attempting to pull the addresses from Table 2 into Table 1 using the last name...

An employer needs to maintain adequate office staffing during the winter and wants to track storm data. Which of the following data collection methods should the employer use?

A data analyst has a set of data that shows the number of gallons of oil produced each day. The company would like to know the standard deviation for the data set. The variance for...

An analyst needs to create an analytics dashboard for an employee intranet site to improve the search functionality, display relevant information, and maintain an updated FAQ page....

Which of the following is a domain-specific language used in programming that is designed for managing data that is held in a relational data stream management system?

A data analyst received a large amount of third-party data that needs to be joined with in-house data files. After the data is joined, the analyst notices three columns all contain...

Which of the following data types best describe 4Ac1? (Select two).

The senior management team at a company receives a detailed sales report at the end of each quarter. The report is several pages long and includes data from dozens of offices acros...

A customer survey reveals 90% positive feedback. Which of the following statistical methods would be best to utilize to determine the reliability of a data set and predict how a la...

Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?

An analyst is reviewing the following data: Car ID Speed 123155 566436 564418 650567 546436 645638 Which of the following should the analyst include in the measures of central tend...

A marketing analytics team received customer transaction data from two different sources. The data is complete and accurate; however, the field names appear to be inconsistent. Giv...

An analyst has written the following code: SELECT * FROM Cust_table WHERE age > 60 AND City = "New York" Which of the following criteria is the analyst retrieving?

Given the customer table below: Which of the following chart types is the most appropriate to represent the average spending of active customers vs. inactive customers?

A data analyst has removed the outliers from a data set due to large variances. Which of the following central tendencies would be the best measure to use?

Given the following grocery store orders: If a query is made to the table with the following logic: Order_Total > 132 OR (Order Total >= 25 AND Order_Total < 74) Which of the follo...

A data analyst needs to create a dashboard to help identify trends in the data sets. Which of the following is an appropriate consideration for dashboard development?

A report is scheduled to run and be distributed at the end of business each day. On Mondays, one of the recipients opens the previous week's reports and combines them to calculate...

Given the diagram below: Which of the following steps is missing?

An analyst reviews the following data: 7 3 5 2 3 7 7 10 Which of the following is the value of the mode?

Which of the following is a KPI metric for tracking sales performance?

An analyst develops an IT document and needs to describe the technical terms used in the document. Which of the following is where the analyst should include descriptions of the te...

Given the table below: Which of the following variables can be considered inconsistent, and how many distinct values should the variable have?

Given the following tables: Which of the following will be the dimensions from a FULL JOIN of the tables above?

Given the image below: Which of the following file formats is depicted?

A JSON file is an example of:

Standardized tests are given to students in the middle of each month, and the results are ready by the end of the month. The superintendent needs a quick view of test performance....