CompTIA CompTIA Data+ DA0-001 Questions & Answers

• Question 41:

  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. SELECT.

  B. ALTER.

  C. INSERT.

  D. UPDATE.

  Correct Answer: C

  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.

• Question 42:

  Which of the following would be considered non-personally identifiable information?

  A. Cell phone device name

  B. Customer's name

  C. Government ID number

  D. Telephone number

  Correct Answer: A

  Explanation: Non-personally identifiable information (non-PII) is any data that cannot be used to identify, contact, or locate a specific individual, either alone or combined with other sources. Non-PII can include aggregated statistics, anonymous data, device identifiers, IP addresses, cookies, and other types of information that do not reveal the identity or location of a person. Cell phone device name is an example of non-PII, as it does not reveal any personal information about the owner or user of the device. Therefore, the correct answer is A. References: What is Non-Personally Identifiable Information (Non-PII)? | Definition and Examples, What is Personally Identifiable Information (PII)? | Definition and Examples

• Question 43:

  Which of the following contains alphanumeric values?

  A. 10.1²

  B. 13.6

  C. 1347

  D. A3J7

  Correct Answer: D

  Explanation: Alphanumeric values are values that contain both letters and numbers, such as A3J7. The other options are numeric values, as they contain only numbers, such as 10.1E2, 13.6, and 1347. Reference: Guide to CompTIA Data+ and Practice Questions - Pass Your Cert

• Question 44:

  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 line chart

  B. A waterfall chart

  C. A heat map

  D. A stacked bar chart

  Correct Answer: D

• Question 45:

  Consider the following dataset which contains information about houses that are for sale:

  

  Which of the following string manipulation commands will combine the address and region name columns to create a full address?

  full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

  A. SELECT CONCAT(address, ' , ' , regionname) AS full_address FROM melb LIMIT 5;

  B. SELECT CONCAT(address, '-' , regionname) AS full_address FROM melb LIMIT 5;

  C. SELECT CONCAT(regionname, ' , ' , address) AS full_address FROM melb LIMIT 5

  D. SELECT CONCAT(regionname, '-' , address) AS full_address FROM melb LIMIT 5;

  Correct Answer: A

  The correct answer is A: SELECT CONCAT(address, ' , ' , regionname) AS full_address FROM melb LIMIT 5; String manipulation (or string handling) is the process of changing, parsing, splicing, pasting, or analyzing strings. SQL is used for managing data in a relational database. The CONCAT () function adds two or more strings together. Syntax CONCAT(stringl, string2,... string_n) Parameter Values Parameter Description stringl, string2, string_n Required. The strings to add together.

• Question 46:

  Which one of the following is a measure of dispersion?

  A. Variance.

  B. Mode.

  C. Median.

  D. Mean.

  Correct Answer: A

• Question 47:

  A data analyst needs to collect a similar proportion of data from every state. Which of the following sampling methods would be the most appropriate?

  A. Systematic sampling

  B. Convenience sampling

  C. Stratified sampling

  D. Random sampling

  Correct Answer: C

  Explanation: The best sampling method for the data analyst's need is C. Stratified sampling. Stratified sampling is a type of probability sampling that involves dividing the population into homogeneous groups or strata based on some characteristic, such as state, and then randomly selecting a proportional number of individuals from each stratum. Stratified sampling ensures that every group is adequately represented in the sample, and reduces the sampling error and variability12 Systematic sampling is not correct, because it involves selecting every nth individual from the population, starting from a random point. Systematic sampling does not guarantee that every state will have a similar proportion of data in the sample, and may introduce bias or error if there is a hidden pattern or order in the population12 Convenience sampling is not correct, because it involves selecting individuals who are easily accessible or available to the researcher. Convenience sampling is a type of non- probability sampling that does not involve random selection, and may result in a biased or unrepresentative sample12 Random sampling is not correct, because it involves selecting individuals from the population at random, without any grouping or stratification. Random sampling may not produce a sample that has a similar proportion of data from every state, especially if the population is large or heterogeneous. Random sampling may also have a higher sampling error and variability than stratified sampling12

• Question 48:

  A data analyst received the information in the table below from a recently completed marketing campaign:

  

  Which of the following is the total order conversion rate?

  A. 13.2%

  B. 14.8%

  C. 22.3%

  D. 85.2%

  Correct Answer: A

  Explanation: The correct answer is A. 13.2%.

  The total order conversion rate is the ratio of the total number of orders to the total number of clicks, expressed as a percentage. To calculate the total order conversion rate, we need to sum up the clicks and orders from all the channels, and

  then divide the orders by the clicks and multiply by 100.

  Using the data from the table, we can do the following:

  Total clicks = 580 + 800 + 1,200 + 300 + 620 = 3,500 Total orders = 55 + 100 + 220 + 60 + 85 = 520

  Total order conversion rate = (520 / 3,500) x 100 = 14.857% Rounding to one decimal place, we get 14.9%

  Therefore, the total order conversion rate is 14.9%.

• Question 49:

  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. Aggregate

  B. Logical

  C. Date

  D. Sort

  Correct Answer: B

  Explanation: This is because a logical function is a type of function that returns a value based on a condition or a set of conditions. A logical function can be used to generate the data in the Sales_indicator column by comparing the values in the Sales column with a threshold of $50,000 and returning either "Exceeded $50,000" or "Not exceeded $50,000" accordingly. For example, a logical function in Excel that can achieve this is:

  

  The other functions are not suitable for generating the data in the Sales_indicator column. Here is why:

  Aggregate is a type of function that performs a calculation on a group of values, such as sum, average, count, etc. An aggregate function cannot generate the data in the Sales_indicator column because it does not compare the values in the Sales column with a threshold or return a text value based on a condition. Date is a type of function that manipulates or extracts information from dates, such as year, month, day, etc. A date function cannot generate the data in the Sales_indicator column because it does not use the values in the Sales column or return a text value based on a condition. Sort is a type of function that arranges the values in a column or a range in ascending or descending order. A sort function cannot generate the data in the Sales_indicator column because it does not create a new column or return a text value based on a condition.

• Question 50:

  Which of the following is an example of a data-mining ETL tool?

  A. SSIS

  B. Stata

  C. SPSS

  D. Cognos

  Correct Answer: A

  Explanation: A data-mining ETL tool is a software application that performs extract, transform, and load (ETL) operations on data for data mining purposes. Data mining is the process of discovering patterns, trends, and insights from large and complex data sets. ETL tools help to prepare the data for analysis by extracting data from various sources, transforming data into a consistent and suitable format, and loading data into a data warehouse or other destination. SSIS (SQL Server Integration Services) is an example of a data-mining ETL tool that is part of Microsoft SQL Server. SSIS provides graphical tools and wizards for building and debugging ETL packages that can work with various data sources and destinations. Therefore, the correct answer is A. References: [Data Mining - SQL Server Integration Services (SSIS) | Microsoft Docs], [What Is Data Mining? | Oracle]