DA0-001 practice questions 201–210

1. Question 201 · 365 in bank

   Which of the following describes the use of a representative amount of data from a main repository?

   • AObservation
   • BDelta load
   • CWeb scraping
   • DSampling

   Show answer

   Answer: D

   Next question

2. Question 202 · 365 in bank

   An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?

   • ADetermine the data needs and review the observations.
   • BDetermine the data needs and sources for analysis.
   • CDetermine the data needs and schedule interviews.
   • DDetermine the data needs and begin the analysis.

   Show answer

   Answer: B

   Next question

3. Question 203 · 365 in bank

   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?

   • ATactical
   • BAd hoc
   • CDynamic
   • DRecurring

   Show answer

   Answer: B

   Next question

4. Question 204 · 365 in bank

   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?

   • AMicrosoft Excel
   • BR
   • CSnowflake
   • DSQL

   Show answer

   Answer: B

   Next question

5. Question 205 · 365 in bank

   Which of the following data acquisition concepts is the most appropriate for determining the quality of a company’s product?

   • AWeb scraping
   • BObservation
   • CSurvey
   • DSampling

   Show answer

   Answer: C

   Next question

6. Question 206 · 365 in bank

   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 technical terms?

   • AGlossary
   • BSystem diagram
   • CUser requirements
   • DIndex

   Show answer

   Answer: A

   Next question

7. Question 207 · 365 in bank

   Given the following:

   

   Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

   • AFill in the missing cost where it is null.
   • BSeparate the table into two tables and create a primary key.
   • CReplace the extended cost field with a calculated field.
   • DCorrect the dates so they have the same format.

   Show answer

   Answer: D

   Next question

8. Question 208 · 365 in bank

   The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?

   • AThe data cleansing processes failed to execute.
   • BThe database connectivity failed.
   • CThe report included the previous month's data.
   • DThe data normalization processes failed.

   Show answer

   Answer: C

   Next question

9. Question 209 · 365 in bank

   Which of the following is a difference between a primary key and a unique key?

   • AA unique key cannot take null values, whereas a primary key can take null values.
   • BThere can be only one primary key in a data set, whereas there can be multiple unique keys.
   • CA primary key can take a value more than once, whereas a unique key cannot take a value more than once.
   • DA primary key cannot be a date variable, whereas a unique key can be.

   Show answer

   Answer: B

   Next question

10. Question 210 · 365 in bank

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

    • ADiscrete data cannot create a sloped line.
    • BDiscrete data can only be a finite number of values.
    • CDiscrete data can have decimal points.
    • DDiscrete data applies only to numbers.

    Show answer

    Answer: B

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DA0-001 practice, question 201. 365 questions available.