CompTIA DA0-001 Practice Test - Questions Answers, Page 12
List of questions
Question 111

Encryption is a mechanism for protecting data.
When should encryption be applied to data?
Choose the best answer.
Explanation:
Correct answer B. When data is at rest or in transit.
To provide maximum protection, encrypt data both in transit and at rest.
Question 112

What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?
Explanation:
Correct answer D. DML.
The Data Manipulation Language (DML) is used to work with the data stored in a database. DML includes the SELECT, INSERT, UPDATE, and DELETE commands.
The Data Definition Language (DDL) contains the commands used to create and structure a relational database. It includes the CREATE, ALTER, and DROP commands.
DDL and DML are the only two sublanguages of SQL.
Question 113

Which of the following roles is responsible for ensuring an organization's data quality, security, privacy, and regulatory compliance?
Explanation:
Correct answer B. Data steward.
A data steward is responsible for leading an organization's data governance activities, which include data quality, security, privacy, and regulatory compliance.
Question 114

Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?
Explanation:
Correct answer A. Sample.
Jenny does not have data for the entire population of all undergraduate sophomores. While a specific grade point average is an observation of variable, jenny needs sample data.
Question 115

Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.
In what phase are the group's R skills most relevant?
Question 116

You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?
Explanation:
Performance analysis is the technique of studying or comparing the performance of a specific situation in contrast to the aim and yet executed. In Human Resources, performance analysis can help to review an employee's contribution towards a project or assignment, which they allotted him or her.
Question 117

Which one of the following would not normally be considered a summary statistic?
Explanation:
Simply put, a z-score (also called a standard score) gives you an idea of how far from the mean a data point is. But more technically it's a measure of how many standard deviations below or above the population mean a raw score is. A z-score can be placed on a normal distribution curve.
Question 118

What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?
Explanation:
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet or a collection of cloud-based and on-premises hybrid data warehouses.
Question 119

You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.
Explanation:
The statement is false. You should not always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool. Acquiring a new tool can be costly, time-consuming, and risky, as it may not be compatible with your existing data sources, systems, or processes. It may also require additional training, maintenance, and support. Therefore, you should always consider the trade-offs between the benefits and drawbacks of acquiring a new tool versus using an existing one. You should also evaluate the feasibility, availability, and reliability of the new tool before making a decision. Reference: CompTIA Data+ (DA0-001) Practice Certification Exams | Udemy
Question 120

What R package makes it easy to work with dates?
Explanation:
Lubridate is an R package that makes it easier to work with dates and times.
Question