DA0-001 practice questions 251–260

1. Question 251 · 365 in bank

   Which of the following types of analysis is used when comparing last week's sales to the previous week's sales?

   • ATrend analysis
   • BExploratory analysis
   • CPrescriptive analysis
   • DLink analysis

   Show answer

   Answer: A

   Next question

2. Question 252 · 365 in bank

   Which of the following is an example of structured data?

   • AA credit card number
   • BAn email
   • CA photo
   • DSocial media correspondence

   Show answer

   Answer: A

   Next question

3. Question 253 · 365 in bank

   Which of the following data protection methods provides confidentiality for data in transit?

   • ADe-identification
   • BEncryption
   • CMasking
   • DAnonymization

   Show answer

   Answer: B

   Next question

4. Question 254 · 365 in bank

   A business intelligence team wants to create a new dashboard in order to solve a problem statement. Which of the following is the correct order of steps the team should take?

   • ADetermine business needs, find data sources, validate the data, create a mock-up, and analyze the information.
   • BFind data sources, determine business needs, validate the data, create a mock-up, and analyze the information.
   • CCreate a mock-up, validate the data, analyze the information, determine business needs, and find data sources.
   • DValidate the data, find data sources, analyze the information, and determine business needs.

   Show answer

   Answer: A

   Next question

5. Question 255 · 365 in bank

   Which of the following formulas correctly illustrates an IF statement?

   • A=IF(A1=2,"no","hat")
   • B=IF(A1=2,"no","hat")END
   • C=IF(A1,"no","hat")
   • D=IF(A1=2,no,hat)

   Show answer

   Answer: A

   Next question

6. Question 256 · 365 in bank

   Select 2

   A database administrator is required to mask certain table columns containing PII in order to comply with the company privacy policy. Which of the following are the most likely types of information the administrator should mask? (Choose two.)

   • AGovernment-issued ID
   • BAddress
   • COrder ID
   • DOrder date
   • ECustomer ID
   • FReferral number

   Show answer

   Answer: AB

   Next question

7. Question 257 · 365 in bank

   A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below:

   

   Which of the following steps should the analyst take to create the table?

   • ATranspose the first name and last name in both tables. Use LOOKUP to pull the address field from Table 2 into Table 1.
   • BUse LOOKUP with the first name or last name to pull the address field from Table 2 into Table 1.
   • CUse the append formula in both tables for the first name and last name. Use LOOKUP to pull the address field from Table 2 into Table 1.
   • DCreate a column that concatenates the first name and last name in each table. Use CONCATENATE and LOOKUP to bring the address field into Table 1.

   Show answer

   Answer: D

   Next question

8. Question 258 · 365 in bank

   A research analyst collects ten data points from 1,000 specimens. The analyst will not need any additional data to complete the analysis and will not need to retrieve information by specifier. Which of the following is the best data structure for the analyst to use?

   • ANoSQL
   • BFlat file
   • CJSON
   • DRelational database

   Show answer

   Answer: B

   Next question

9. Question 259 · 365 in bank

   Which of the following data manipulation techniques should an analyst use to hide unnecessary data during analysis?

   • AFiltering
   • BParametrization
   • CSorting
   • DIndexing

   Show answer

   Answer: A

   Next question

10. Question 260 · 365 in bank

    A data set for sales per month includes the following data:

    

    Which of the following cleaning and profiling methods should be applied to the data set?

    • AData outliers
    • BInvalid data
    • CDuplicate data
    • DData type validation

    Show answer

    Answer: D

    Next question

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

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