DA0-001 — questions

Given the table below: Which of the following boxes indicates that a Type II error has occurred?

A user imports a data file into the accounts payable system each day. On a regular basis, the field input is not what the system is expecting, so it results in an error for the row and a broken import process. To resolve the issue, the user opens the file, finds the error in the row, and manually corrects it before attempting the import again. The import sometimes breaks on subsequent attempts, though. Which of the following changes should be made to this process to reduce the number of errors?

Given the table below: Which of the following numbers represents a Type I error?

A sales manager wants quarterly sales reports broken down by unit and week. Which of the following data output lists includes the most necessary information?

An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit, but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

Which of the following statements would be used to append two tables that have the same number of columns?

A data analyst has been asked to create a daily manufacturing report for the floor manager. Which of the following metrics should be included in the report?

A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that was previously distributed on an as-needed basis. Which of the following would be the most appropriate frequency for this report?

A human resources analyst needs to build a new visualization to highlight the company’s hierarchy. Which of the following would be the best way to do this?

Which of the following database schemas features normalized dimension tables?

A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

Which of the following differentiates a flat text file from other data types?

Which of the following reports can be used when insight into operational performance is needed each Wednesday?

During data profiling, an analyst decides to recode the status column in the following data set: Which of the following data concerns explains why the analyst wants to take this action?

Which of the following are reasons to conduct data cleansing? (Choose two).

The number of phone calls that a call center receives in a day is an example of:

An analyst needs to join two tables of data together for analysis. All the names and cities in the first table should be joined with the corresponding ages in the second table, if applicable. Table 1 - Table 2 - Which of the following is the correct join the analyst should complete, and how many total rows will be in one table?

Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?

A data analyst needs to collect a similar proportion of data from every state. Which of the following sampling methods would be the most appropriate?

A data analyst needs to perform a full outer join of a customer’s orders using the tables below: Sales_table - Order_table - Which of the following is the mean of the order quantity?