DA0-001 시험 - CompTIA실제시험문제와 답 - 180문항

Question No : 1

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.

정답:
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

Question No : 2

Which one the following is not considered an aggregate function?

A.SUM
B.MIN
C.SELECT
D.MAX

정답:
Explanation:
The option that is not considered an aggregate function is SELECT. An aggregate function is a function that performs a calculation on a set of values and returns a single value. Examples of aggregate functions are SUM, MIN, MAX, AVG, COUNT, etc. SELECT is not an aggregate function, but a SQL command that is used to select data from a table or a query.
Reference: SQL Aggregate Functions - W3Schools

Question No : 3

Which one of the following values will appear first if they are sorted in descending order?

A.Aaron.
B.Molly.
C.Xavier.
D.Adam.

정답:
Explanation:
The value that will appear first if they are sorted in descending order is Xavier. Descending order means arranging values from the largest to the smallest, or from the last to the first in alphabetical order. In this case, Xavier is the last name in alphabetical order, so it will appear first when sorted in descending order. The other names will appear in the following order: Molly, Adam, Aaron.
Reference: Sorting Data - W3Schools

Question No : 4

You have two databases tables that you would like to join together using a foreign key relationship.
What term best describes this action?

A.Blending.
B.Appending.
C.Mixing.
D.Merging.

정답:
Explanation:
Data merging is the process of combining two or more data sets into a single data set. Most often, this process is necessary when you have raw data stored in multiple files, worksheets, or data tables, that you want to analyze all in one go.

Question No : 5

What R package makes it easy to work with dates?

A.Lubridate.
B.Datemath.
C.Stringr.
D.ggplot.

정답:
Explanation:
Lubridate is an R package that makes it easier to work with dates and times.

Question No : 6

You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

A.True.
B.False.

정답:
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 beforemaking a decision.
Reference: CompTIA Data+ (DA0-001) Practice Certification Exams | Udemy

Question No : 7

What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?

A.Qlik.
B.Power B
C.Domo.
D.Dataroma.

정답:
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 No : 8

Which one of the following would not normally be considered a summary statistic?

A.z-score.
B.Mean.
C.Variance.
D.Standard deviation.

정답:
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 No : 9

You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?

A.Performance analysis.
B.Outlier analysis.
C.Predictive analysis.
D.Trend analysis.

정답:
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 No : 10

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?

A.Extract.
B.Load.
C.Transform.
D.Purge.

정답:

Question No : 11

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?

A.Sample.
B.Observation.
C.Variable.
D.Population.

정답:
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 No : 12

Which of the following roles is responsible for ensuring an organization's data quality, security, privacy, and regulatory compliance?

A.Data owner.
B.Data steward.
C.Data custodian.
D.Data processor.

정답:
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 No : 13

What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

A.DD
B.DS
C.DQ
D.DM

정답:
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 No : 14

Encryption is a mechanism for protecting data.
When should encryption be applied to data? Choose the best answer.

A.When data is at rest.
B.When data is at rest or in transit.
C.When data is in transit.
D.When data is at rest, unless you are using local storage.

정답:
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 No : 15

Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table.
What type of design pattern is the data warehouse using?

A.Star.
B.Sun.
C.Snowflake.
D.Comet.

정답:
Explanation:
Correct answer C. Snowflake.
Since the dimension links to a dimension that isn't connected to the fact table, it must be a Snowflake, with a Star, all dimensions link directly to the fact table, Sun and Comet are not data warehouse design patterns.

CompTIA DA0-001 시험