CompTIA DA0-001 Online Practice Questions and Exam Preparation

CompTIA DA0-001 Online Questions & Answers

• Question 101:

  A data engineer is creating a database field to capture whether a customer likes vanilla ice cream. Which of the following data types is the best to capture this information?

  A. Integer
  B. Boolean
  C. Categorical
  D. Numeric
  B. Boolean

  ---

  Explanation

• Question 102:

  Analytics reports should follow corporate style guidelines.

  A. True.
  B. False.
  A. True.

  ---

  Explanation

• Question 103:

  A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?

  A. Frequency
  B. Percent change
  C. Variance
  D. Mean
  B. Percent change

  ---

  Explanation

  This is because percent change is a type of descriptive statistic that measures the relative change or difference of a variable over time, such as the sugar content of cereal over years in this case. Percent change can be used to determine whether the sugar content of cereal has increased over years by comparing the initial and final values of the sugar content, as well as calculating the ratio or proportion of the change. For example, percent change can be used to determine whether the sugar content of cereal has increased over years by finding out how much more (or less) sugar there is in cereal now than before, as well as expressing it as a fraction or a percentage of the original sugar content. The other descriptive statistics are not appropriate to use to determine whether the sugar content of cereal has increased over years. Here is why:

  Frequency is a type of descriptive statistic that measures how often or how likely a value or an event occurs in a data set, such as how many times a certain sugar content appears in cereal in this case. Frequency does not measure the relative change or difference of a variable over time, but rather measures the occurrence or chance of a variable at a given time. Variance is a type of descriptive statistic that measures how much the values in a data set vary or deviate from the mean or average of the data set, such as how much variation there is in sugar content among different cereals in this case. Variance does not measure the relative change or difference of a variable over time, but rather measures the dispersion or spread of a variable at a given time. Mean is a type of descriptive statistic that measures the average value or central tendency of a data set, such as what is the typical sugar content of cereal in this case. Mean does not measure the relative change or difference of a variable over time, but rather measures the summary or representation of a variable at a given time.

• Question 104:

  A data analyst needs to create a data visualization that aids in un the cumulative impact of sequentially introduced values that are positive or negative.

  Which of the following data visualization methods should the analyst use?

  A. A bubble chart
  B. A waterfall chart
  C. A scatter plot
  D. A line chart
  B. A waterfall chart

  ---

  Explanation

  A waterfall chart is a type of data visualization that shows the cumulative impact of sequentially introduced values that are positive or negative. A waterfall chart typically has an initial value and a final value, with intermediate values shown as floating columns that either add to or subtract from the initial value. A waterfall chart can help visualize how different factors contribute to a net change in a value over time. Therefore, the correct answer is

  B.

  References:

  [Waterfall Chart | Definition and Examples - Investopedia], [Waterfall Charts in Excel | How to Create Waterfall Chart in Excel?] 4 of 30

• Question 105:

  

  Which of the following summary statements upholds integrity in data reporting?

  A. Sales are approximately equal for Product A and Product B across all strategies.
  B. Strategy 4 provides the best sales in comparison to other strategies.
  C. While Strategy 2 does not result in the highest sales of Product
  D. Product D should be promoted more than the other products in all strategies.
  C. While Strategy 2 does not result in the highest sales of Product

  ---

  Explanation

  Answer:

  C. While Strategy 2 does not result in the highest sales of Product

  D. over all products it appears to be the most effective. A summary statement that upholds integrity in data reporting should be accurate, unbiased, and supported by

  evidence. Option C is the only statement that meets these criteria, as it reflects the data shown in the bar graph without exaggerating or distorting it. Option C also acknowledges the limitation of the statement by using the word "appears",

  which indicates that there may be other factors or variables that affect the sales performance. Option A is inaccurate, as sales are not approximately equal for Product A and Product B across all strategies. Product A has higher sales than

  Product B in strategies 1, 3, and 5, while Product B has higher sales than Product A in strategies 2 and 4. Option B is biased, as it does not consider the sales of different products in each strategy. Strategy 4 provides the best sales for Product B, but not for the other products. Strategy 5 has the highest total sales across all products, as shown by

  the black line graph.

  Option D is unsupported by evidence, as it does not explain why Product D should be promoted more than the other products in all strategies. Product D has the lowest sales among all products in strategies 1, 3, and 4, and only slightly

  higher sales than Product C in strategies 2 and 5.

• Question 106:

  Which of the following is most likely to be used as a data-mining ETL tool?

  A. SSIS
  B. Stata
  C. SPSS
  D. Cognos
  A. SSIS

  ---

  Explanation

• Question 107:

  A research analyst collects ten data points from 1.000 specimens. The analyst will not need any additional data to complete the analysis and will not need to retrieve information by specifier.

  Which of the following is the best data structure for the analyst to use?

  A. NoSQL
  B. Flat file
  C. JSON
  D. Relational database
  B. Flat file

  ---

  Explanation

  A flat file is a type of data structure that stores data in a plain text format, such as CSV, TSV, or TXT. A flat file consists of one or more records, each containing one or more fields, separated by a delimiter, such as a comma, tab, or space. A

  flat file does not have any hierarchical or relational structure, and does not support any complex queries or operations.

  A flat file may be the best data structure for the analyst to use in this scenario, because:

  The analyst collects ten data points from 1,000 specimens, which means the data is relatively small and simple, and can be easily stored and processed in a flat file. The analyst will not need any additional data to complete the analysis, which

  means the data is static and does not require any updates or modifications. The analyst will not need to retrieve information by specifier, which means the data does not require any indexing or searching by key or value.

• Question 108:

  Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?

  A. Data encryption.
  B. Data transmission.
  C. Data protection.
  D. Data masking.
  A. Data encryption.

  ---

  Explanation

  Data encryption can be used to translate data into another form so it can only be read by a user who has a key or a password. Data encryption is a process of transforming data using an algorithm or a cipher to make it unreadable to anyone

  except those who have the key or the password to decrypt it. Data encryption is a common method of protecting data from unauthorized access, modification, or theft.

  Guide to CompTIA Data+ and Practice Questions - Pass Your Cert

• Question 109:

  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.
  A. Display the version number next to each submission on the dashboard.

  ---

  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 110:

  What role in a data governance is typically responsible for day-to-day oversight of data use?

  A. Data processors.
  B. Data custodians
  C. Data owners.
  D. Data stewards.
  D. Data stewards.

  ---

  Explanation