Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
DA0-001
Free trial
Verified
Question 26
Which of the following database schemas features normalized dimension tables?
- A: Flat
- B: Snowflake
- C: Hierarchical
- D: Star
Question 27
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?
- A: An emailed report
- B: A password-protected dashboard
- C: A daily printout of a report
- D: A cloud-hosted spreadsheet
Question 28
Which of the following differentiates a flat text file from other data types?
- A: Data is separated by a delimiter.
- B: Data is stored in defined rows.
- C: Data is defined with key-value pairs.
- D: Data is housed in a markup language.
Question 29
Which of the following reports can be used when insight into operational performance is needed each Wednesday?
- A: Static report
- B: Tactical report
- C: Recurring report
- D: Ad hoc report
Question 30
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?
- A: Redundancy
- B: Duplication
- C: Invalidity
- D: Inconsistency
Question 31
Which of the following are reasons to conduct data cleansing? (Choose two).
- A: To perform web scraping
- B: To track KPIs
- C: To improve accuracy
- D: To review data sets
- E: To increase the sample size
- F: To calculate trends
Question 32
The number of phone calls that a call center receives in a day is an example of:
- A: continuous data.
- B: categorical data.
- C: ordinal data.
- D: discrete data.
Question 33
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?
- A: INNER JOIN, two rows
- B: LEFT JOIN, four rows
- C: RIGHT JOIN, five rows
- D: OUTER JOIN, seven rows
Question 34
Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?
- A: To return a subset of records
- B: To insert a temporary table
- C: To prevent SQL injections
- D: To increase the query speed
Question 35
The number of phone calls that call center receives in a day is an example of:
- A: continuous data.
- B: categorical data.
- C: ordinal data.
- D: discrete data.
Question 36
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: Systematic sampling
- B: Convenience sampling
- C: Stratified sampling
- D: Random sampling
Question 37
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?
- A: 73.5
- B: 76.5
- C: 78.8
- D: 81.5
Question 38
An analyst must obtain the average daily sales for the following week:
Which of the following must the analyst perform to obtain this value?
- A: Data normalization
- B: Data append
- C: Data aggregation
- D: Data blending
Question 39
Which of the following best describes an exploratory analysis?
- A: Involves the use of descriptive statistics to understand observations
- B: Involves analysis of exploring data sets for performance tracking
- C: Involves the testing of specific hypotheses
- D: Involves the use of arithmetic algebra to determine the distribution
Question 40
A site reliability team wants to monitor the stability of their website, so they can proactively diagnose issues when they occur. Which of the following deliverables would best suit their needs?
- A: A self-serve dashboard of website performance that updates in real time
- B: A weekly log report of site visits and user actions
- C: A portal that is refreshed daily and reports errors classified by type
- D: A daily summary email indicating website outages for the previous day
Question 41
Which of the following query optimization techniques involves examining only the data that is needed for a particular task?
- A: Making a temporary table
- B: Creating a flat file
- C: Indexing documents
- D: Creating an execution plan
Question 42
Which of the following best describes the law of large numbers?
- A: As a sample size decreases, its standard deviation gets closer to the average of the whole population.
- B: As a sample size grows, its mean gets closer to the average of the whole population.
- C: As a sample size decreases, its mean gets closer to the average of the whole population.
- D: When a sample size doubles, the sample is indicative of the whole population.
Question 43
A C-suite executive would like to monitor KPIs for each department on a monthly basis. Which of the following explains why the executive wants to conduct this performance analysis?
- A: To analyze a connection of data points or pathways
- B: To use descriptive statistics to determine observations
- C: To provide a comparison of data over time
- D: To track measurements against defined goals
Question 44
An analyst is working on a project for a director. During this process, the analyst pulled the data, created summarized tables and graphs with descriptions, created a report summary, and inserted all items into a report. After writing the report, which of the following would be the most appropriate next step?
- A: Complete an audit on the data pulled for the report.
- B: Complete a check for quality in the report.
- C: Complete a review of the data and a check for consistency.
- D: Complete a trend analysis to be included in the report.
That’s the end of your free questions
You’ve reached the preview limit for DA0-001Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!