DA0-001 Exam Questions

An analyst wants to test the association between the number of doors in a car and the number of gears in the car. Which of the following is the best test to use?

An analyst is compiling a series of reports for the new executive board to review. Which of the following elements provides a snapshot of what is contained in the reports for the e...

An analyst wants to determine whether a relationship between an individual's age and voting preferences exists. Which of the following is the best statistical method for the analys...

A data architect is designing a data solution for a retail clothing store chain. Each store has a database that tracks sales transactions. The data architect needs to create a summ...

Consider two different datasets, one with gas prices and the other with food prices. Which of the following measures is most affected by outliers?

A data analyst was asked to create a visual representation of sales for the first quarter of 2020. Which of the following visualizations should be used when a time element is prese...

Which of the following formulas correctly illustrates an IF statement?

A user wants a dynamic report that presents a moving average of sales throughout the company's history and also for select periods. Which of the following attributes should the rep...

A user needs a live report that always displays the current week performance and can also show the past weeks, months, and years performance for all time, if needed. Which of the f...

A sales director wants a report that provides a view into company sales over multiple quarters in order to gain a better understanding of trends. Which of the following report type...

Which of the following activities is most likely performed during data preparation in the ETL process?

Which of the following data quality features can be added to a technology platform?

A membership organization wants to determine whether renewals have declined in specific regions over the past three years. Which of the following types of analysis would be best fo...

A manager would like to see a report that details lost deals for the week. Which of the following report delivery methods best supports this requirement?

Given the following data sets: Which of the following data manipulation techniques was performed?

After returning from a vacation, a sales manager finds multiple hard copies of the prior week's sales report on a desk with the same date but different information. Which of the fo...

Which of the following data types is the "number of packages delivered" an example of?

Which of the following is a key feature of a temporary table?

An intern needs to compile a report that will be used in a customer proposal at the end of the month. Which of the following best describes the type of report the intern should use...

Which of the following is an example of a structured data type?

An analyst is working with a data set that contains information regarding refugee status, income, identification numbers, place of residence, and employment status. The analyst nee...

An analyst wrote the following code: Which of the following formats did the analyst use?

A healthcare data analyst is working with data sets containing patient information, medical records, and metrics. The data analyst needs to combine two data sets that have a common...

Which of the following is a characteristic of structured data?

Which of the following best describes structured data?

A college student has taken four exams in a class. The student hopes to finish the class with a weighted average of at least 90% to get an A. Given the following: With one test rem...

Which of the following relationships is necessary to define a third table called a "joining table" in relational databases?

An analyst is conducting a survey to measure height. Which of the following is the most likely to decrease as the analyst collects more survey responses?

An analyst is reviewing a company document to identify why sales have declined over multiple sales quarters. Which of the following analysis techniques should the analyst use?

A field marketing team needs to assess the relationship between gender and volume of sales. The team provided an analyst with the data to be modified. The data sets are shown below...

A data analyst added some missing data to a list of observations, since only a small amount of the data was absent. Which of the following actions did the data analyst perform?

A director wants a data set that can be used to visualize how various marketing campaigns have performed. The information will be provided by internal and external sources and then...

An analyst wants to show the population of each district in a city and the associated crime rates. Which of the following describes the appropriate analytical technique that the an...

Which of the following should a developer use to interact with data from external resources?

Given the following data table: Which of the following data editing methods is the best to use to make the data usable for analysis?

An analyst is looking at the relationship between age and certain health disparities. Which of the following analysis techniques should the analyst use?

A business analyst has performed the following steps: - Reviewed research questions and business needs. - Identified data needs and how to collect this information. - Scoped the ty...

A company CRM has more than one million email addresses. The company wants to create a new reduced and simplified table that can be exported in a flat file. Which of the following...

The marketing team has a C-level executive who requires a dashboard that displays real-time sales data and performance metrics. The dashboard needs to be accessible on the executiv...

During an interview, a hiring manager asks an analyst about the analyst's experience using programming languages. The analyst has used HTML, Python, and SQL. Which of the following...

An analyst is creating a chart that shows the frequencies of values of a variable bucketed into ranges. Which of the following is the most appropriate visual for the analyst to use...

Which of the following data types is most commonly used to store address data?

Which of the following is a reason to remove duplicate data?

A retail data analyst needs to create a new variable that represents the total purchase amount for each customer. Which of the following data manipulation techniques should the ana...

Which of the following is a characteristic of alphanumeric data in a table?

A biologist is recording the length of five fish with the following measurements: 5.6in (152mm) 11in (280mm) 3.6in (91mm) 13in (330mm) 4.4in (112mm) Which of the following is the m...

An analyst is working to identify trends in a study and finds the data set has a lot of missing values. Which of the following best describes the data quality issue?

A team is working on a quarterly business review deck and needs to ensure the team is always working on the most recent iteration. Which of the following does the deck need?

Given a database with the following fields: - Item_Name - First_Name - Item_Price - Customer_ID Which of the following is the best primary key?

Which of the following statistical methods would be best for an analyst to use to determine if two nominal variables are unrelated?