DA0-001 Free Practice Test

A client has requested an analysis of all pet care items purchased by current customers and their social media connections in the past 12 months. Which of the following data analysis techniques would be the best choice given these requirements?

1. A. Trend analysis
2. B. Performance analysis
3. C. Link analysis
4. D. Exploratory data analysis

Correct Answer: C

A data analyst needs to apply quality control concepts to a data set for accuracy. Which of the following is the best way to do this?

1. A. Standardization
2. B. Parameterization
3. C. Encryption
4. D. Cross-validation

Correct Answer: D

A data analyst has been asked to derive a new variable labeled ??Promotion_flag?? based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag ??Yes?? for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

1. A. Date
2. B. Mathematical
3. C. Logical
4. D. Aggregate

Correct Answer: C
A logical function is a type of function that returns a value based on a condition or a set of conditions. For example, the IF function in Excel can be used to check if a certain condition is met, and then return one value if true, and another value if false. In this case, the data analyst can use a logical function to check if the Quantity_sold column is greater than 1,000,000, and then return ??Yes?? if true, and ??No?? if false. This would create a new variable called Promotion_flag that indicates whether the salesperson has sold more than 1,000,000 units or not. References: CompTIA Data+ Certification Exam Objectives, Logical functions (reference)

A company's human resources department has asked a data analyst to categorize the income of all employees into five salary bands:

Which of the following types of functions would be the most appropriate to use?

1. A. Statistical
2. B. Aggregate
3. C. Logical
4. D. Mathematical

Correct Answer: C
Short Explanation: Logical functions are the most appropriate to use for categorizing data
into bands, because they allow the data analyst to apply conditional statements and criteria to the data values. For example, the IF function can be used to assign a band name based on whether a value meets a certain condition or not. Other logical functions that can be useful for categorizing data are AND, OR, NOT, and IFERROR12

Which of the following query statements would be used when filtering data in a relational database management system? (Select two).

1. A. ORDER BY
2. B. HAVING
3. C. WHERE
4. D. SELECT
5. E. INSERT
6. F. GROUP BY

Correct Answer: BC