DA0-001 practice questions 161–170

1. Question 161 · 365 in bank

   Given the following customer and order tables:

   

   

   Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

   • AFive rows, eight columns
   • BSeven rows, eight columns
   • CEight rows, seven columns
   • DNine rows, five columns

   Show answer

   Answer: A

   Explanation

   A. Five rows, eight columns. Inner join returns only the rows where there is a match between the two tables in the specified join condition. In this case, the join condition would be based on the "Customer ID" column, which is present in both tables. So, the inner join of the two tables would result in 5 rows where there is a match in the "Customer ID" column, and each row would have 8 columns (all columns from both tables).

   Source: Adapted from community discussion — ronniehaang

   Next question

2. Question 162 · 365 in bank

   A development company is constructing a new unit in its apartment complex. The complex has the following floor plans:

   

   Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

   • A$640,900
   • B$690,000
   • C$705,200
   • D$702,500

   Show answer

   Answer: D

   Explanation

   Answer is D. Average Cost per Square Foot = (345 + 386 + 354 + 320) = 1405 / 4 = 351.25 Now that we have the average cost per square foot as $351.25, we can calculate the price of the "Rose" unit: Price of Rose Unit = Square Footage of Rose Unit (2,000 sq. ft) * Average Cost per Square Foot ($351.25/sq. ft) Price of Rose Unit = 2,000 sq. ft * $351.25/sq. ft Price of Rose Unit = $702,500

   Source: Adapted from community discussion — Crimsonpug94

   Next question

3. Question 163 · 365 in bank

   Which of the following is a control measure for preventing a data breach?

   • AData transmission
   • BData attribution
   • CData retention
   • DData encryption

   Show answer

   Answer: D

   Next question

4. Question 164 · 365 in bank

   A data analyst has been asked to organize the table below in the following ways: By sales from high to low - By state in alphabetic order -

   

   Which of the following functions will allow the data analyst to organize the table in this manner?

   • AConditional formatting
   • BGrouping
   • CFiltering
   • DSorting

   Show answer

   Answer: D

   Explanation

   D. Sorting is the function that will allow the data analyst to organize the table in the desired manner. Sorting allows the data analyst to arrange the data in a specific order, either in ascending or descending order, based on one or multiple columns. In this case, the analyst can sort the table by Age from high to low by clicking on the Age column and selecting "Sort Descending". They can then sort the table by Income in alphabetic order by clicking on the Income column and selecting "Sort A to Z". Sorting is a simple and efficient way to organize large data sets, making it easier for the analyst to analyze and present the data.

   Source: Adapted from community discussion — ronniehaang

   Next question

5. Question 165 · 365 in bank

   A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

   • ACreate multiple reports, one for each needed date range.
   • BBuild calculations into the report so they are done automatically.
   • CAdd macros to the report to speed up the filtering and calculations process.
   • DCreate a dashboard with a date range picker and calculations built in.

   Show answer

   Answer: D

   Explanation

   D. A dashboard with a date range picker would allow the user to dynamically select the desired date range, and have the calculations done automatically without any manual effort. This would provide a seamless and dynamic experience for the user.

   Source: Adapted from community discussion — AmyD

   Next question

6. Question 166 · 365 in bank

   A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

   • Adependent data.
   • Bduplicate data.
   • Cinvalid data
   • Dredundant data

   Show answer

   Answer: D

   Next question

7. Question 167 · 365 in bank

   While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

   • AReplace missing data.
   • BRemove duplicate data.
   • CReplace redundant data.
   • DRemove invalid data.

   Show answer

   Answer: D

   Next question

8. Question 168 · 365 in bank

   Which of the following BEST describes standard deviation?

   • AA measure that is used to establish a relationship between two variables
   • BA measure of how data is distributed
   • CA measure of the amount of dispersion of a set of values
   • DA measure that is used to find the significant difference between variables

   Show answer

   Answer: C

   Next question

9. Question 169 · 365 in bank

   A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:

   

   Which of the following charts would BEST represent the relationship between the variables?

   • AA histogram
   • BA scatter plot
   • CA heat map
   • DA bar chart

   Show answer

   Answer: B

   Explanation

   B. A scatter plot would BEST represent the relationship between the variables of study hours and exam scores for each student. A scatter plot shows the relationship between two variables by plotting their values in a two-dimensional graph. Each data point in the scatter plot represents a student's study hours and exam score. The scatter plot allows the analyst to see if there is a positive or negative relationship between the variables, and if there is a linear or nonlinear relationship. It provides a visual representation of the data, making it easier to understand and interpret.

   Source: Adapted from community discussion — ronniehaang

   Next question

10. Question 170 · 365 in bank

    Given the table below:

    

    Which of the following variable types BEST describes the “Year” column?

    • ANumeric
    • BDate
    • CAlphanumeric
    • DText

    Show answer

    Answer: A

    Explanation

    A. Numeric This is because the values in the "Year" column are all numbers representing the year, and they do not contain any alphabetic characters or special characters that would classify them as alphanumeric or text. Additionally, they are not in a date format that would require them to be classified as a date variable type.

    Source: Adapted from community discussion — Alice00085

    Next question

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

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