CompTIA CompTIA Data+ DA0-001 Questions & Answers

• Question 211:

  A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

  A. Display the version number next to each submission on the dashboard.

  B. Present a data refresh date at the top of the dashboard.

  C. Confirm the dashboard is adhering to the corporate style guide.

  D. Use permissions to ensure users only see certain versions of the submissions.

  Correct Answer: A

  Explanation: A static report is a type of report that shows a snapshot of data at a specific point in time. A static report does not change or update automatically, unless the data source is refreshed or the report is regenerated. A static report is suitable for situations where the data does not change frequently or where historical data is needed for comparison or analysis. In this case, the data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. This means that the data analyst does not need to show real-time or dynamic data, but rather a fixed and accurate view of the sales data for the second quarter. Therefore, a static report would be the best way to meet this stakeholder requirement. Therefore, the correct answer is A. References: What are Static Reports? | Sisense, Static vs Dynamic Reports - What's The Difference? | datapine

• Question 212:

  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

  Correct Answer: C

  Explanation: This is because the price of the Rose unit can be estimated using the average cost per square foot of the original floor plans, which are Jasmine, Orchid, Azalea, and Tulip. To find the average cost per square foot of the original floor plans, we can use the following formula:

  

  Plugging in the values from the original floor plans, we get:

  

  To find the price of the Rose unit, we can use the following formula:

  

  Plugging in the values from the Rose unit, we get:

  

  Therefore, the price of the Rose unit should be $705,200, using the average cost per square foot of the original floor plans.

• Question 213:

  An analyst is designing a dashboard to determine which site has the highest percentage of new customers. 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 to BEST display the data?

  A. Include a bar chart using the site and the percentage of new customers data.

  B. Include a line chart using the site and the percentage of new customers data.

  C. Include a pie chat using the site and percentage of new customers data.

  D. Include a scatter chart using the site and the percent of new customers data.

  Correct Answer: A

  Explanation: This is because a bar chart is a type of chart that shows the value or the amount of a single variable for different categories or groups, such as the percentage of new customers for different sites in this case. A bar chart can be used to display and analyze the comparison, ranking, or proportion among the categories or groups, as well as identify any differences, similarities, or outliers in the data. For example, a bar chart can show which site has the highest or lowest percentage of new customers, as well as show how much each site contributes to the total percentage of new customers. The other types of charts are not the best charts to display the data. Here is why:

  A line chart is a type of chart that shows the change or the trend of a single variable over time, such as the percentage of new customers over months or years in this case. A line chart can be used to display and analyze the movement, cycle, or pattern of the variable, as well as identify any peaks, valleys, or fluctuations in the data. For example, a line chart can show how the percentage of new customers increases or decreases over time, as well as show if there are any seasonal or periodic variations in the data. A pie chart is a type of chart that shows the proportion or the percentage of a single variable for different categories or groups, such as the percentage of new customers for different sites in this case. A pie chart can be used to display and analyze the composition, distribution, or share of the variable, as well as identify any segments, slices, or fractions in the data. For example, a pie chart can show how much each site represents of the total percentage of new customers, as well as show if there are any dominant or minor sites in the data. A scatter chart is a type of chart that shows the relationship between two variables for each observation or unit in a data set, such as the percentage of new customers and another variable for each site in this case. A scatter chart can be used to display and analyze the correlation, trend, or pattern among the variables, as well as identify any outliers or clusters in the data. For example, a scatter chart can show if there is a positive, negative, or no correlation between the percentage of new customers and another variable, such as sales revenue or customer satisfaction.

• Question 214:

  You are working with a dataset and need to swap the values in rows with those in columns.

  What action do you need to perform?

  A. Recording

  B. Filtering.

  C. Aggregation.

  D. Transposition.

  Correct Answer: D

  Transpose creates a new data file in which the rows and columns in the original data file are transposed so that cases (rows) become variables and variables (columns) become cases. Transpose automatically creates new variable names

  and displays a list of the new variable names.

  Transposing data is useful for data analysis. At times, we have to pull data from various files with different formats for analysis and preparing reports. In such circumstances, we may have to transpose some data from one file to the other. In

  excel, we can transpose data in multiple ways.

• Question 215:

  You are working with a dataset and want to change the names of categories that you used for different types of books.

  What term best describes this action?

  A. Recording.

  B. Summarizing

  C. Aggregating.

  D. Filtering.

  Correct Answer: A

  Explanation: The term that best describes the action of changing the names of categories that you used for different types of books is recoding. Recoding is a process of transforming or modifying the values of a variable or a category to make them more meaningful, consistent, or accurate. For example, you can recode the names of book genres from "Fiction", "Non-Fiction", "Biography", etc. to "FIC", "NF", "BIO", etc. to make them shorter and easier to use. Reference: Recoding Data - SPSS Tutorials - LibGuides at Kent State University