DA0-001 practice questions 191–200

1. Question 191 · 365 in bank

   The current date is July 14, 2020. A data analyst has been asked to create a report that shows the company’s year-over-year Q2 2020 sales. Which of the following reports should the analyst compare?

   • AQ2 2020 and Q4 2019
   • BYTD 2020 and YTD 2019
   • CQ2 2020 and Q2 2019
   • DQ2 2020 and Q2 2021

   Show answer

   Answer: C

   Explanation

   To create a report that shows the company's year-over-year Q2 2020 sales, the analyst should compare the sales data from Q2 2020 and Q2 2019. Year-over-year (YoY) analysis is a method of comparing the performance of a business or a financial instrument over the same period in different years. It helps to identify trends, growth patterns, and seasonal fluctuations. Q2 refers to the second quarter of a year, which is usually from April to June. Therefore, the correct answer is C.

   Source: Adapted from community discussion — Swift_and_Quick

   Next question

2. Question 192 · 365 in bank

   Which of the following will always result in a null value when aggregate operations are applied?

   • ASum collection
   • BData collection
   • CAverage collection
   • DEmpty collection

   Show answer

   Answer: D

   Next question

3. Question 193 · 365 in bank

   A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

   

   Which of the following types of charts should be considered?

   • AInclude a line chart using the site and average sales per customer.
   • BInclude a pie chart using the site and sales to average sales per customer.
   • CInclude a scatter chart using sales volume and average sales per customer.
   • DInclude a column chart using the site and sales to average sales per customer.

   Show answer

   Answer: D

   Next question

4. Question 194 · 365 in bank

   An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?

   • AConduct an exploratory analysis and use descriptive statistics.
   • BConduct a trend analysis and use a scatter chart.
   • CConduct a link analysis and illustrate the connection points.
   • DConduct an initial analysis and use a Pareto chart.

   Show answer

   Answer: A

   Next question

5. Question 195 · 365 in bank

   A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the following months shouts the report cover?

   • AOctober 1, 2019 to October 31, 2020
   • BOctober 31, 2020 to November 1, 2021
   • CNovember 1, 2019 to October 31, 2020
   • DOctober 31, 2019 to October 31, 2020

   Show answer

   Answer: C

   Next question

6. Question 196 · 365 in bank

   A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN: Customer Table -

   

   In-store Transactions -

   

   Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

   • AINNER: 6 rows; LEFT: 9 rows
   • BINNER: 9 rows; LEFT: 6 rows
   • CINNER: 9 rows; LEFT: 15 rows
   • DINNER: 15 rows; LEFT: 9 rows

   Show answer

   Answer: A

   Explanation

   A. INNER: 6 rows; LEFT: 9 rows Explanation: INNER JOIN: An INNER JOIN returns only the rows that match in both tables. The common column used for joining is "Customer ID". In this case, there are 6 customers with matching Customer IDs in both the Customer Table and In-store Transactions table, so the number of rows after performing an INNER JOIN would be 6. LEFT JOIN: A LEFT JOIN returns all the rows from the left table (Customer Table), and the matching rows from the right table (In-store Transactions). If there is no match, NULL values will be displayed in the right table columns. In this case, there are 9 customers in the Customer Table, but only 6 have matching Customer IDs in the In-store Transactions table, so there would be 9 rows after performing a LEFT JOIN.

   Source: Adapted from community discussion — ronniehaang

   Next question

7. Question 197 · 365 in bank

   A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

   • AUse scheduled report delivery.
   • BImplement subscription access delivery.
   • CPrint out a copy.
   • DUpload the report to the server.

   Show answer

   Answer: A

   Next question

8. Question 198 · 365 in bank

   Which of the following is an example of a discrete variable?

   • AThe temperature of a hot tub
   • BThe height of a horse
   • CThe time to complete a task
   • DThe number of people in an office

   Show answer

   Answer: D

   Next question

9. Question 199 · 365 in bank

   Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

   • ANumeric
   • BDate
   • CFloat
   • DText

   Show answer

   Answer: D

   Explanation

   A telephone number formatted as XXX-XXX-XXXX would be considered a text data type, as it is composed of alphanumeric characters and symbols. A numeric data type is composed of only numbers, such as integers or decimals. A date data type is composed of values that represent dates or times, such as YYYY-MM-DD or HH:MM:SS. A float data type is composed of numbers with fractional parts, such as 3.14 or 0.5.

   Source: Adapted from community discussion — 3489

   Next question

10. Question 200 · 365 in bank

    An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

    • AOptimize the dashboard.
    • BCreate subscriptions.
    • CGet stakeholder approval.
    • DDeploy to production.

    Show answer

    Answer: C

    Explanation

    C. Get stakeholder approval is the NEXT step the analyst should take in the dashboard creation process after creating the wireframe. After confirming the data sources and creating a wireframe of the internal user dashboard, it is important to get approval from stakeholders who will be using the dashboard. This includes both internal and external stakeholders, as well as end users who will be accessing the dashboard. Stakeholder approval is necessary to ensure that the dashboard meets the requirements of the stakeholders, and that it is aligned with the overall goals of the organization. During the approval process, stakeholders may provide feedback or make changes to the wireframe, and the analyst can use this feedback to make any necessary updates to the dashboard design.

    Source: Adapted from community discussion — ronniehaang

    Next question

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

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