DA0-001 — questions

Given the following report: Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

Given the following customer and order tables: Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

A development company is constructing a new unit in its apartment complex. The complex has the following floor plans: Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

Given the following data: Which of the following BEST describes the data set?

Which of the following will MOST likely be streamed live?

A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and standard deviation of the scores for each of the courses: Using this information, which of the following students had the BEST score?

A commissions analyst has just completed second-quarter payout statements. The analyst created a dashboard to distribute the statements as quickly as possible. Which of the following will ensure only designated employees can view this information?

The current date is July 14, 2020. A data analyst has been asked to create a report that shows the company’s year-over-year Q2 2020 sales. Which of the following reports should the analyst compare?

A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN: Customer Table - In-store Transactions - Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day’s performance. Which of the following reports should the analyst provide?

Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5,000,000 rows?

Which of the following best describes how discrete data differs from continuous data?

Which of the following file formats is best suited to start exploratory analysis within statistical software?

An analyst wants to model the relationship between a set of continuous variables in order to predict the value of an output variable based on the values of a set of input variables. Which of the following types of analyses should the analyst use?

A data analyst needs to create a dashboard using the company’s yearly revenue data sets. Which of the following would be the best way to plot the information to show the top performing region?

The duration of a phone call in milliseconds is an example of: