DA0-001 practice questions 151–160

1. Question 151 · 365 in bank

   Which of the following is a characteristic of a relational database?

   • AIt utilizes key-value pairs.
   • BIt has undefined fields.
   • CIt is structured in nature.
   • DIt uses minimal memory.

   Show answer

   Answer: C

   Explanation

   C. It is structured in nature. This is because a relational database is a type of database that organizes data into tables, which consist of rows and columns. A relational database is structured in nature, which means that the data has a predefined schema or format, and follows certain rules and constraints, such as primary keys, foreign keys, or referential integrity. A relational database can be used to store, query, and manipulate data using a structured query language (SQL). The other characteristics are not true for a relational database.

   Source: Adapted from community discussion — Swift_and_Quick

   Next question

2. Question 152 · 365 in bank

   A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

   • AJanuary 1, 2020 to April 1, 2020
   • BJanuary 1, 2020 to April 7, 2020
   • CJanuary 1, 2020 to April 8, 2020
   • DJanuary 1, 2020 to April 9, 2020

   Show answer

   Answer: C

   Next question

3. Question 153 · 365 in bank

   Select 2

   Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)

   • AData identification
   • BData processing
   • CData reporting
   • DData encryption
   • EData masking
   • FFata removal

   Show answer

   Answer: DE

   Explanation

   D. Data encryption E. Data masking Data encryption involves transforming the data into an unreadable format so that it cannot be understood without the appropriate decryption key. This protects the data from being intercepted or viewed by unauthorized parties during transmission. Data masking involves obscuring sensitive data elements by replacing them with non-sensitive values. This allows the data to be used for testing, development, and reporting purposes without compromising its confidentiality. Data masking also helps to mitigate the risk of data leaks, since the sensitive information is not accessible to unauthorized parties. By using both encryption and masking, the chance of a data leak occurring during transmission can be significantly reduced, as the data is protected both in transit and at rest.

   Source: Adapted from community discussion — ronniehaang

   Next question

4. Question 154 · 365 in bank

   Given the following data tables:

   

   

   

   Which of the following MDM processes needs to take place FIRST?

   • ACreation of a data dictionary
   • BCompliance with regulations
   • CStandardization of data field names
   • DConsolidation of multiple data fields

   Show answer

   Answer: C

   Next question

5. Question 155 · 365 in bank

   Which of the following is used for calculations and pivot tables?

   • AIBM SPSS
   • BSAS
   • CMicrosoft Excel
   • DDomo

   Show answer

   Answer: C

   Next question

6. Question 156 · 365 in bank

   Select 2

   Given the following report:

   

   Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

   • AA control group for the phrases
   • BA summary of the KPIs
   • CFilter buttons for the status
   • DThe date when the report was last accessed
   • EThe time period the report covers
   • FThe date on which the report was run

   Show answer

   Answer: EF

   Next question

7. Question 157 · 365 in bank

   Select 2

   An analyst has been asked to validate data quality. Which of the following are the BEST reasons to validate data for quality control purposes? (Choose two.)

   • ARetention
   • BIntegrity
   • CTransmission
   • DConsistency
   • EEncryption
   • FDeletion

   Show answer

   Answer: BD

   Next question

8. Question 158 · 365 in bank

   A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?

   • ATrend analysis
   • BPerformance analysis
   • CLink analysis
   • DExploratory analysis

   Show answer

   Answer: C

   Explanation

   C. Link analysis is the BEST type of analysis to conduct if the research analyst wants to determine whether the data being analyzed is connected to other datapoints. Link analysis is a statistical technique that helps to uncover relationships and connections between different data points. It can be used to identify correlations and dependencies in data, as well as to identify any outliers that might indicate a potential problem or error in the data. In link analysis, data points are visualized as nodes in a network and the connections between them are represented as lines. This visualization makes it easier for the analyst to see the relationships between different data points, and to identify any correlations or dependencies. Link analysis is particularly useful when the data being analyzed is complex and the connections between data points are not immediately obvious. Overall, link analysis is a valuable tool for research analysts who want to better understand the relationships between different data points and uncover connections that might not be immediately apparent.

   Source: Adapted from community discussion — ronniehaang

   Next question

9. Question 159 · 365 in bank

   Which of the following variable name formats would be problematic if used in the majority of data software programs?

   • AFirst_Name_
   • BFirstName
   • CFirst_Name
   • DFirst Name

   Show answer

   Answer: D

   Next question

10. Question 160 · 365 in bank

    Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

    • ASimple random
    • BCluster
    • CSystematic
    • DStratified

    Show answer

    Answer: D

    Explanation

    D. Stratified Stratified Sampling is a method in which the population is divided into smaller subgroups, or strata, based on characteristics such as age, gender, socioeconomic status, etc. and a random sample is taken from each subgroup. This ensures that each subgroup is represented in the sample, so that the sample accurately reflects the diversity within the population. Simple Random Sampling selects elements from the population at random, with no attempt to ensure representation of subgroups. Cluster Sampling involves dividing the population into clusters, and then randomly selecting a number of clusters to be included in the sample. Systematic Sampling involves selecting elements from the population at regular intervals, rather than randomly.

    Source: Adapted from community discussion — AmyD

    Next question

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

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