The latest CompTIA Data+ DA0-001 certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the CompTIA Data+ DA0-001 exam and earn CompTIA Data+ DA0-001 certification.
Table of Contents
- DA0-001 Question 121
- Exam Question
- Correct Answer
- DA0-001 Question 122
- Exam Question
- Correct Answer
- DA0-001 Question 123
- Exam Question
- Correct Answer
- Explanation
- DA0-001 Question 124
- Exam Question
- Correct Answer
- DA0-001 Question 125
- Exam Question
- Correct Answer
- Explanation
- DA0-001 Question 126
- Exam Question
- Correct Answer
- Explanation
- DA0-001 Question 127
- Exam Question
- Correct Answer
- Explanation
- DA0-001 Question 128
- Exam Question
- Correct Answer
- Explanation
- DA0-001 Question 129
- Exam Question
- Correct Answer
- Explanation
- DA0-001 Question 130
- Exam Question
- Correct Answer
- Explanation
DA0-001 Question 121
Exam Question
Which action is mandated by the Gramm-Leach-Bliley Act (GLBA) Safeguards Rule?
A. The distinguishing between consumers and customers.
B. The development of written information security policy.
C. The disclosure of information sharing practices.
D. The provision of a privacy notice to consumers.
Correct Answer
B. The development of written information security policy.
DA0-001 Question 122
Exam Question
What technique can you use to predict one value from another using a linear relationship?
A. Hypothesis testing.
B. Correlation.
C. Regression.
D. Chi-square.
Correct Answer
C. Regression.
DA0-001 Question 123
Exam Question
Which one of the following tools would not be considered a fully featured analytics suite?
A. Minitab.
B. MicroStrategy.
C. Domo.
D. Power BI.
Correct Answer
A. Minitab.
Explanation
Power BI, Domo, and MicroStrategy are all analytics suites offering features that fill many different needs within the analytics process.
Minitab is a statictical analysis package that lacks many of these capabilities.
DA0-001 Question 124
Exam Question
Analytics reports should follow corporate style guidelines/
A. True.
B. False.
Correct Answer
A. True.
DA0-001 Question 125
Exam Question
A SQL database administrator wants to display the total number of employees. Which of the following SQL commands should the administrator use to display the total number?
A. SELECT COUNT(*) FROM HumanResources.Employee; GO
B. SELECT COUNT(NUM) FROM HumanResources.Employee; GO
C. SELECT COUNT(NUM *) FROM HumanResources.Employee; GO
D. SELECT COUNT(+) FROM HumanResources.Employee; GO
Correct Answer
A. SELECT COUNT(*) FROM HumanResources.Employee; GO
Explanation
An aggregate function performs a calculation on a set of values and returns a single value.
Transact-SQL provides the following aggregate functions:
- APPROX_COUNT_DISTINCT
- AVG CHECKSUM_AGG
- COUNT COUNT_BIG
- GROUPING
- GROUPING_ID
- MAX
- MIN
The rest commands are incorrect as they have invalid syntax.
DA0-001 Question 126
Exam Question
A web developer which develops an e-commerce marketplace designs its database to capture, store and process data from transactions in real-time. The e-commerce platform will deal with many standard and straightforward queries such ss insert, delete, and update and the data will be stored in 3NF (third normal form). In which of the following databases would the developer store the data?
A. Online analytical processing
B. Online query processing
C. Online transactional processing
D. Online standard processing
Correct Answer
C. Online transactional processing
Explanation
The correct answer is: Online transactional processing Online transaction processing (OLTP) captures, stores, and processes data from transactions in real-time. An OLTP database stores and manages data related to everyday operations within a system or a company. However, OLTP is focused on transaction-oriented tasks. OLTP typically deals with query processing (inserting, updating, deleting data in a database), and maintaining data integrity and effectiveness when dealing with numerous transactions simultaneously. Each transaction involves individual database records made up of multiple fields or columns. Examples include banking and credit card activity or retail checkout scanning. Online analytical processing is incorrect. Online analytical processing (OLAP) uses complex queries to analyze aggregated historical data from OLTP systems. OLTP and OLAP are two systems that complement each other. While OLTP deals with processing day-to-day transactions, OLAP helps analyze the processed data. Online query processing and Online standard processing are incorrect as these are imaginary terms.
DA0-001 Question 127
Exam Question
Which of the following recurring reports help General Data Protection Regulation (GDPR) to maintain and prove compliance?
A. Compliance reports
B. GDPR reports
C. Operational reports
D. Risk and regulatory reports
Correct Answer
A. Compliance reports
Explanation
Compliance reporting is the process of presenting information to auditors that show that your company is adhering to all the requirements set by the government and regulatory agency under a particular standard. It is often the IT department’s responsibility to generate these reports. Compliance reports typically include information on how customer/company data is dealt with – how it is controlled or protected, obtained and stored, and how it is secured and distributed internally and externally.
Some regulations and the industries to which they apply are as follows:
| Standards and Regulations | Industry | Brief Description of the Regulation |
|---|---|---|
| Health Insurance Portability and Accountability Act (HIPAA) | Healthcare | The HIPAA Privacy Rule establishes national standards to protect individuals’ medical records and other personal health information. It applies to health plans, healthcare clearinghouses, and those health care providers that conduct certain healthcare transactions electronically. The HIPAA Security Rule requires appropriate administrative, physical and technical safeguards to ensure the confidentiality, integrity and security of electronically protected health information. |
| Payment Card Industry Data Security Standard (PCI DSS) | Retail, financial institutions, any business or organization that processes, stores or transmits credit card information | The PCI Data Security Standards set the operational and technical requirements for organizations accepting or processing payment transactions, and for software developers and manufacturers of applications and devices used in those transactions. |
| General Data Protection Regulation (GDPR) | Any business that has customers in the European Union (EU) | Europe’s data privacy and security law imposes regulations on organizations regardless of where they are based, as long as they target or collect data related to people in the EU. |
DA0-001 Question 128
Exam Question
Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average.
What should Andy’s null hypothesis be?
A. People who receive electronic coupons spend more on average.
B. People who receive electronic coupons spend less on average.
C. People who receive electronic coupons do not spend more on average.
D. People who do not receive electronic coupons spend more on average.
Correct Answer
C. People who receive electronic coupons do not spend more on average.
Explanation
The null hypothesis presumes the status quo. Andy is testing whether or not people who receive an electronic coupon spend more on average, so, the null hypothesis states that people who receive the coupon do spend more on average.
DA0-001 Question 129
Exam Question
You have been tasked to create the login form for the website of your client. You design the database for the login form but you forgot to add the column that keeps a boolean type (0/1) which shows if a user has an account or not. If a user has an account, then the database should be stored the value 1, alternatively the value 0.
Which of the following data types should you use to complete the database?
A. Numeric
B. Currency
C. Date
D. Alphanumeric
Correct Answer
A. Numeric
Explanation
Numeric is any intrinsic data type (Byte, Boolean, Integer, Long, Currency, Single, Double). Numeric data types are numbers stored in database columns. These data types are typically grouped by: Exact numeric types, values where the precision and scale need to be preserved. Date is incorrect. The Date is used for storing a date or a date/time value in the database. Alphanumeric is incorrect.
Alphanumeric is a description of data that is both letters and numbers. For example, “la2b3c” is a short string of alphanumeric characters. Alphanumeric is commonly used to help explain the availability of text that can be entered or used in a field, such as an alphanumeric password field. Currency is incorrect. Currency is a data type with a range of -922,337,203,685,477.5808 to 922,337,203,685,477.5807. Currency is used for calculations involving money and for fixed-point calculations where accuracy is particularly important.
DA0-001 Question 130
Exam Question
When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1. What term describes this action?
A. Filtering.
B. Normalization.
C. Transposition.
D. Aggregation.
Correct Answer
B. Normalization.
Explanation
Normalization is the process of reorganizing data in a database so that it meets two basic requirements: There is no redundancy of data, all data is stored in only one place. Data dependencies are logical, all related data items are stored together. Put simply, data normalization ensures that your data looks, reads, and can be utilized the same way across all of the records in your customer database. This is done by standardizing the formats of specific fields and records within your customer database.