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

Question No : 1

George is conducting a survey. He intends to distribute the survey via email and wants to optionally follow up with respondents based on their answers.
What quality dimension is most vital to the success of George's survey?
Choose the best answer.

A.Completeness.
B.Accuracy.
C.Consistency.
D.Validity.

정답:
Explanation:
A. Completeness
Accuracy is for measuring how well an attribute matches its intended use.
Consistency measures an attribute's value across systems.
Validity ensures an attribute's value falls within an expected range.
While all of these dimensions are important, Completeness is foundational to George's purpose.

Question No : 2

Chris is building a database to store prices for items on a restaurant menu.
What data type is most appropriate for this field?

A.Numeric.
B.Date.
C.Tags.
D.Alphanumeric.

정답:
Explanation:
A. Numeric
Prices are numbers stored in dollars and cents; as such, the data type needs to be capable of storing numbers.

Question No : 3

According to the empirical rule, what percent of thee values in a sample fall within three standard deviations of the mean in a normal distribution?

A.99.70%
B.95%
C.90%
D.68%

정답:
Explanation:
A. 99.70%
According to the empirical rule, 68% of values are within one standard deviation, 95% are within two standard deviations, and 99.7% are within three standard deviations.

Question No : 4

James wants to analyze profit based on sales of five different product categories.
His source data set consists of 5.8 million rows with columns including region, product category, product name, and sales price.
How should he manipulate the data to facilitate his analysis?
Choose the best answer.

A.Transpose by region and summarize.
B.Transpose by product category and summarize.
C.Transpose by product name and summarize.
D.Transpose by sales price and summarize.

정답:
Explanation:
B. Transpose by product category and summarize.
We can transpose this data by product category to perform this analysis broken out by product category.
Transposing by sales price, region, or product name will not further his state analytical goal.

Question No : 5

Oliver is designing an ETL process to copy sales data into a data warehouse on a hourly basis.
What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?

A.Bulk load.
B.Purge and load.
C.Use ELT instead of ET
D.Delta load.

정답:
Explanation:
D. Delta load
Since Oliver needs to migrate changes every hour, a delta load is the best approach.

Question No : 6

What is the median of the following numbers?
13, 2, 65, 3, 5, 4, 7, 3, 4, 7, 8, 2, 4, 4, 60, 23, 43, 2

A.4
B.4.5
C.63
D.18

정답:
Explanation:
B. 4.5
To find the median, sort the numbers in your dataset and find the one located in the middle. In this case, there are an even number of observations, so we take the two middle numbers (4 and 5) and use their average as the median, making the median value 4.5.
The mode is 4, the range is 63, and the number of observations is 18.

Question No : 7

Olivia has 15 people on her data analytics team. Her team's charter requires that all team members have read access to the finance, human resources, sales, and customer service areas of the corporate data warehouse.
What is the best way to provision access to her team?
Choose the best answer.

A.Since there are 15 people on her team, create a role for each person to improve security.
B.Since there are four discrete data subjects, create one role for each subject area.
C.Enable multifactor authentication (MFA) to protect the data.
D.Create a single role that includes finance, human resources, sales, and customer services data.

정답:
Explanation:
D. Create a single role that includes finance, human resources, sales, and customer services data.
While MFA is a good security practice, it doesn't govern access to data.
Creating a single role for her team and assigning that role to the individuals on the team is the best approach.

Question No : 8

Melissa wants to explore central tendency in her dataset.
Which statistic best matches her need?

A.Interquartile range.
B.Range.
C.Median.
D.Standard deviation.

정답:
Explanation:
C. Median.
The Median is the middle observation of variable and is, therefore, a measure of central tendency.
Interquartile range is a measure of position.
Range and Standard deviation are both measures of dispersion.

Question No : 9

Harry is looking at home sales prices in single zip code and notices that one home sold for $940,394 when the average selling price of similar homes is $210,420.
What type of data does the $940,394 sales price represent?
Choose the best answer.

A.Duplicate data.
B.Data outlier.
C.Redundant data.
D.Invalid data.

정답:
Explanation:
B. Data outlier.
Since the value is more than four times the average, the $940,394 value is an outlier.

Question No : 10

Andrew conducts a study and wants to capture eye color.
What kind of data is eye color? Choose the best response.

A.Discrete.
B.Categorical.
C.Continuous.
D.Alphanumeric.

정답:
Explanation:
B. Categorical.
Eye color can only fall into a certain range of values; as such, it is categorical.

Question No : 11

Which one of the following tools would not be considered a fully featured analytics suite?

A.Minitab.
B.MicroStrategy.
C.Domo.
D.Power B

정답:
Explanation:
A. Minitab.
Power BI, Domo, and MicroStrategy are all analytics suites offering features that fill many different needs within the analytics process.
Minitab is a statistical analysis package that lacks many of these capabilities.

Question No : 12

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.

정답:
Explanation:
C. Transform
The R programming language is used to manipulate and model data.
In the ETL process, this activity normally takes place during the Transform phase.
The Extract and Load phases typically use database-centric tools.
Purging data from database is typically done using SQL.

Question No : 13

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

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

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.

CompTIA DA0-001 시험