DA0-001 practice questions 101–110

1. Question 101 · 365 in bank

   A home builder is offering a 30% discount on condominium units. Given the table below:

   

   Which of the following is the range of savings for the units listed in the table?

   • A$103,500 to $157,500
   • B$241,500 to $367,500
   • C$320,000 to $386,000
   • D$345,000 to $525,000

   Show answer

   Answer: A

   Explanation

   Option A is correct. Highest price: 525000, lowest price: 345000. 525000 * 30% = 157500. 345000 * 30% = 103500. Range of savings is 103500 to 157500. Option B is the range of the price after saving is applied, it’s not the range of savings.

   Source: Adapted from community discussion — Swift_and_Quick

   Next question

2. Question 102 · 365 in bank

   A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

   • Anon-relational schema.
   • Bgalaxy schema.
   • Csnowflake schema.
   • Dstar schema.

   Show answer

   Answer: D

   Next question

3. Question 103 · 365 in bank

   A company derives proprietary leads from monthly sales calls and sends them to dealers through a connection that matches the correct leads to the correct dealers Which of the following BEST describes this method?

   • AApplication programming interface
   • BPublic databases
   • CSurvey
   • DWeb scraping

   Show answer

   Answer: A

   Next question

4. Question 104 · 365 in bank

   Which of the following technologies would be BEST suited for creating a multiple linear regression model?

   • AMicrosoft Power BI
   • BR
   • CSQL
   • DTableau

   Show answer

   Answer: B

   Next question

5. Question 105 · 365 in bank

   Which of the following would be the BEST way to identify multicollinear attributes in a data set?

   • ACorrelation coefficient
   • BChi-squared test
   • CTwo-sample t-test
   • DTwo-way ANOVA

   Show answer

   Answer: A

   Next question

6. Question 106 · 365 in bank

   An analyst is updating a customer contacts database with information obtained from a survey of new customers. Which of the following data manipulation techniques should the analyst use?

   • AJoin
   • BAppend
   • CTransform
   • DBlend

   Show answer

   Answer: B

   Next question

7. Question 107 · 365 in bank

   A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way to deliver this report?

   • AA workbook with multiple tabs for each region
   • BA daily email with snapshots of regional summaries
   • CA static report with a different page for every filtered view
   • DA dashboard with filters at the top that the user can toggle

   Show answer

   Answer: D

   Explanation

   D. A dashboard with filters at the top that the user can toggle would be the MOST efficient way to deliver this report. A dashboard allows for a clear and concise presentation of information with the ability to filter and view data in different ways. This allows the user to quickly access the information they need without having to navigate through multiple tabs or pages. Additionally, dashboards can be interactive and allow for real-time updates, providing the most up-to-date information. With the ability to filter by region, product, and time period, the dashboard provides the user with a comprehensive and customizable view of the data, making it the most efficient way to deliver this report.

   Source: Adapted from community discussion — ronniehaang

   Next question

8. Question 108 · 365 in bank

   A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

   

   Which of the following must be done to the Genre column before this task can be completed?

   • AAppend
   • BMerge
   • CConcatenate
   • DDelimit

   Show answer

   Answer: D

   Explanation

   D. In order to determine the most popular movie genre, the data analyst must first delimit the Genre column. Delimiting means separating or breaking up the data in a column into separate values or categories. In this case, the Genre column contains multiple movie genres for each movie, which are separated by commas. In order to determine the most popular movie genre, the data analyst must first split the Genre column into separate rows or categories for each movie genre. This will allow the data analyst to count the number of movies in each genre and determine the most popular genre. The other options (append, merge, and concatenate) do not involve separating or breaking up data in a column.

   Source: Adapted from community discussion — CineFeX

   Next question

9. Question 109 · 365 in bank

   Which of the following is the best description of discrete data types?

   • ANon-numeric data used to describe attributes of a population sample
   • BThe frequency of the number of times each value occurs by using whole numbers
   • CNumeric values that can be measured on a continuous scale
   • DNon-numeric data used to describe attributes of a population sample ranked in a specific order

   Show answer

   Answer: B

   Next question

10. Question 110 · 365 in bank

    Which of the following data governance concepts fits into the security requirements category?

    • AData transmission
    • BData deletion
    • CData use agreements
    • DPersonally identifiable information

    Show answer

    Answer: D

    Next question

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

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