2023年最新のDA0-001問題集にはCompTIA Data+認証済み試験問題と解答
実際に出ると確認されたDA0-001試験問題集と解答でDA0-001無料更新
質問 # 61
A data analyst needs to create a dashboard using the company's yearly revenue data sets. Which of the following would be the best way to plot the information to show the top-performing region?
- A. A waterfall chart
- B. A stacked bar chart
- C. A line chart
- D. A heat map
正解：B
質問 # 62
A data analyst needs to calculate the mean for Q1 sales using the data set below:
Which of the following is the mean?
- A. $2,667.60
- B. $2,466.18
- C. $12,330.88
- D. $3,082.72
正解：B
質問 # 63
Which of the following is a process that is used during data integration to collect, blend, and load data?
- A. MDM
- B. ETL
- C. OLTP
- D. BI
正解：B
解説：
Explanation
ETL is a process that is used during data integration to collect, blend, and load data. ETL stands for extract, transform, and load, which are the three main steps involved in moving data from different sources to a common destination, such as a data warehouse or a data lake. ETL helps to consolidate and standardize data for analysis and reporting purposes. References: CompTIA Data+ Certification Exam Objectives, page 12
質問 # 64
A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?
- A. Surveys sent to ten randomly selected homes within 5mi (8km) of the county's office
- B. Surveys sent to 100 randomly selected homes that are reflective of the population
- C. A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.
- D. A systematic survey that is sent to 100 single-family homes in the county
正解：B
質問 # 65
A user imports a data file into the accounts payable system each day. On a regular basis. the field input is not what the system is expecting. so it results in an error for the row and a broken import process. To resolve the issue, the user opens the file, finds the error in the row, and manually corrects it before attempting the import again. The import sometimes breaks on subsequent attempts. though. Which of the following changes should be made to this process to reduce the number of errors?
- A. Delete all incorrect inputs and upload the corrected file.
- B. Create a data field to data type validator to run the file through prior to import.
- C. Spot-check the file prior to import to catch and correct field errors.
- D. Have the user manually review the file for data completeness before loading it
正解：B
解説：
Explanation
A data field to data type validator is a tool or a process that checks if the data in each field of a file matches the expected data type, such as text, number, date, etc. A data field to data type validator can help to identify and correct any errors or inconsistencies in the data before importing it into the accounts payable system. This would reduce the number of errors and broken imports, as well as save time and effort for the user.
質問 # 66
Which of the following best describes how discrete data differs from continuous data?
- A. Discrete data cannot create a sloped line.
- B. Discrete data can only be a finite number of values.
- C. Discrete data can have decimal points.
- D. Discrete data applies only to numbers.
正解：B
解説：
Explanation
Discrete data are data that can only assume specific values that are countable and distinct. For example, the number of books, the number of heads in a coin toss, or the number of patients in a hospital are discrete data. Discrete data cannot have fractional or decimal values, and there are clear spaces between the possible values12.
Continuous data are data that can assume any value within a range and can be meaningfully divided into smaller parts. For example, the weight, height, length, time, or temperature are continuous data. Continuous data can have fractional or decimal values, and there are infinite numbers of possible values between any two points12.
質問 # 67
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. Normalization.
- B. Filtering.
- C. Aggregation.
- D. Transposition.
正解：A
解説：
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.
質問 # 68
Which one the following is not considered an aggregate function?
- A. MIN
- B. SELECT
- C. SUM
- D. MAX
正解：B
解説：
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
質問 # 69
Which of the following is an example of a discrete data type?
- A. 8in (20cm)
- B. 10.7lbs (4.9kg)
- C. 2.5mi (4km)
- D. 5 kids
正解：D
解説：
Explanation
A discrete data type is a data type that can only take on a finite number of values, such as integers or categories. An example of a discrete data type is the number of kids, as it can only be a whole number. The other options are examples of continuous data types, as they can take on any value within a range. The length in inches or centimeters, the distance in miles or kilometers, and the weight in pounds or kilograms are all continuous data types. Reference: CompTIA Data+ (DA0-001) Practice Certification Exams | Udemy
質問 # 70
Given the diagram below:
Which of the following types of sampling is depicted in the image?
- A. Cluster
- B. Systematic
- C. Stratified
- D. Random
正解：B
解説：
Explanation
Systematic sampling is a type of sampling where the sample is selected by following a fixed interval. For example, every 10th person in a list is chosen for the sample. In the image, the sample is selected by choosing every 3rd person in the line, starting from person number 1. This is an example of systematic sampling.
References: Types of Sampling Techniques in Data Analytics You Should Know, Sampling Methods | Types, Techniques & Examples - Scribbr
質問 # 71
An analyst is building a new dashboard for a user. After an initial conversation with the user. the analyst created a mock-up of the dashboard. Which of the following best explains why the analyst created the mock-up?
- A. To confirm important details before dashboard development begins
- B. To send to the client after deploying the dashboard to production
- C. To receive client approval for the final dashboard design
- D. To identify the dimensions and measures
正解：A
解説：
Explanation
answer: C. To confirm important details before dashboard development begins.
A dashboard mockup is a prototype of a finished dashboard directly in the product. It is a way to visualize the layout, design, and functionality of the dashboard before it is built with real data and code. A dashboard mockup can help the analyst to confirm important details with the user, such as the business objectives, the key performance indicators, the data sources, the filters, the charts, and the interactivity. By creating a dashboard mockup, the analyst can get immediate feedback and validation from the user, and avoid wasting time and resources on developing a dashboard that does not meet the user's expectations or needs1.
質問 # 72
A data analyst has been asked to create a daily manufacturing report for the floor manager Which of the following metrics should be included in the report?
- A. Tons of steel produced per hour
- B. Annual sales budget
- C. Daily corporate employee count
- D. End-of-day stock price
正解：A
質問 # 73
Given the following report:
Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)
- A. The date on which the report was run
- B. Filter buttons for the status
- C. A control group for the phrases
- D. The time period the report covers
- E. The date when the report was last accessed
- F. A summary of the KPIs
正解：D
解説：
Explanation
The date on which the report was run. This is because the time period the report covers and the date on which the report was run are two components that need to be added to ensure the report is point-in-time and static, which means that the report shows the data as it was at a specific moment or interval in time, and does not change or update with new data. By adding the time period the report covers and the date on which the report was run, the analyst can indicate when and for how long the data was collected and analyzed, as well as avoid any confusion or ambiguity about the currency or validity of the data. The other components do not need to be added to ensure the report is point-in-time and static. Here is why:
A control group for the phrases is a type of group that serves as a baseline or a reference for comparison with another group that is exposed to some treatment or intervention, such as a target phrase in this case. A control group for the phrases does not need to be added to ensure the report is point-in-time and static, because it does not affect the time frame or the stability of the data. However, a control group for the phrases could be useful for evaluating the effectiveness or impact of the target phrases on customer satisfaction or retention.
A summary of the KPIs is a type of document that provides an overview or a highlight of the key performance indicators (KPIs), which are measurable values that indicate how well an organization or a process is achieving its goals or objectives. A summary of the KPIs does not need to be added to ensure the report is point-in-time and static, because it does not affect the time frame or the stability of the data. However, a summary of the KPIs could be useful for communicating or presenting the main findings or insights from the report.
Filter buttons for the status are a type of feature or function that allows users to select or deselect certain values or categories in a column or a table, such as ticket statuses in this case. Filter buttons for the status do not need to be added to ensure the report is point-in-time and static, because they do not affect the time frame or the stability of the data. However, filter buttons for the status could be useful for exploring or analyzing different aspects or segments of the data.
質問 # 74
While reviewing survey data, an analyst notices respondents entered "Jan," "January," and "01" as responses for the month of January. Which of the following steps should be taken to ensure data consistency?
- A. Filter on any of the responses that do not say "January" and update them to "January".
- B. Sort any of the responses that say "Jan" and update them to "01".
- C. Replace any of the responses that have "01".
- D. Delete any of the responses that do not have "January" written out.
正解：A
質問 # 75
An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:
Which of the following functions did the analyst use to generate the data in the Sales_indicator column?
- A. Sort
- B. Date
- C. Aggregate
- D. Logical
正解：C
質問 # 76
Daniel is using the structured Query language to work with data stored in relational database.
He would like to add several new rows to a database table.
What command should he use?
- A. INSERT.
- B. ALTER.
- C. SELECT.
- D. UPDATE.
正解：A
解説：
Explanation
INSERT
The INSERT command is used to add new records to a database table.
The SELECT command is used to retrieve information from a database. It's the most commonly used command in SQL because it is used to pose queries to the database and retrieve the data that you're interested in working with.
The UPDATE command is used to modify rows in the database.
The CREATE command is used to create a new table within your database or a new database on your server.
質問 # 77
......
実際問題を使ってDA0-001問題集で100%無料DA0-001試験問題集：https://www.jpntest.com/shiken/DA0-001-mondaishu