Exam Questions Answers Braindumps DA0-001 Exam Dumps PDF Questions [Q38-Q57]

21Jan 2023 by admin No Comments

4/5 - (2 votes)

Exam Questions Answers Braindumps DA0-001 Exam Dumps PDF Questions

Download Free CompTIA DA0-001 Real Exam Questions

CompTIA Data+ Exam Certification Details:

Duration	90 mins
Number of Questions	90
Books / Training	CompTIA Data+ Certification Training
Exam Price	$239 (USD)
Passing Score	675 / 900
Exam Name	CompTIA Data+
Sample Questions	CompTIA Data+ Sample Questions

NEW QUESTION 38
Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.
Which of the following systems is the most appropriate?
Choose the best answer.

Data mart.

OLAP.

Data Warehouse.

OLTP.

Correct answer: C. Data Warehouse.
Data warehouse bring together data from multiple systems used by an organization.
A data mart is too narrow, as Alex needs data from across multiple divisions.
OLAP is a broad term of analytical processing, and OLTP systems are transactional and not ideal for this task.

NEW QUESTION 39
What type of metric is commonly shown on dashboards to assist senior leaders in assessing the organization’s progress toward significant goal?

KMI

KPI

KRI

KCI

NEW QUESTION 40
When taking the test at home, how much extra time is allowed compared to the in-person test?

10 minutes

30 minutes

None.

15 minutes

NEW QUESTION 41
A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?

Trend analysis

Performance analysis

Link analysis

Exploratory analysis

NEW QUESTION 42
A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:

Customer Table –
In-store Transactions –

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

INNER: 6 rows; LEFT: 9 rows

INNER: 9 rows; LEFT: 6 rows

INNER: 9 rows; LEFT: 15 rows

INNER: 15 rows; LEFT: 9 rows

NEW QUESTION 43
Which one of the following R values shows strongest positive correlation between two variables?

1.6

0.9

-0.4

NEW QUESTION 44
A data analyst wants to create “Income Categories” that would be calculated based on the existing variable “Income”. The “Income Categories” would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create “Income Categories”?

Data merge

Derived variables

Data blending

Data append

The correct answer is B: Derived variables Derived variables are variables that you create by calculating or categorizing variables that already exist in your data set.
Data merge is incorrect. Data merging is the process of combining two or more data sets into a single data set. Data blending is incorrect.
Data blending involves pulling data from different sources and creating a single, unique, dataset for visualization and analysis.
Data append is incorrect. A data append is a process that involves adding new data elements to an existing database.

NEW QUESTION 45
How many US. states currently have data breach notification laws?

NEW QUESTION 46
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?

Delete any of the responses that do not have “January” written out.

Replace any of the responses that have “01”.

Filter on any of the responses that do not say “January” and update them to “January”.

Sort any of the responses that say “Jan” and update them to “01”.

NEW QUESTION 47
A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

Use scheduled report delivery.

Implement subscription access delivery.

Print out a copy.

Upload the report to the server.

NEW QUESTION 48
Which of the following statistical methods requires two or more categorical variables?

Simple linear regression

Chi-squared test

Z-test

Two-sample t-test

NEW QUESTION 49
A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO).
Which of the following should be included in the report?

The sales representatives’ home addresses.

Line-item SKU numbers.

YTD total sales.

The customers’ first and last names.

NEW QUESTION 50
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?

Aggregate

Logical

Date

Sort

NEW QUESTION 51
A junior web developer is developing a new application where users can upload short videos. The first task is to create a homepage that shows the headline “Upload Your Short Videos” and a clickable button that says “upload now”.
Which of the following HTML commands would help the developer to complete the task successfully?

< span >Upload Your Short Videos< /span >< button >upload now< /button >

< p >Upload Your Short Videos< /p >< p >upload now< /p >

< hl >Upload Your Short Videos< /h1 >< button >upload now< /button >

< hl >Upload Your Short Videos< /h1 >< hl >upload now< /h1 >

The correct answer is: Upload Your Short Videos
upload now
The two tags are used to define HTML headings. defines the most important heading. defines the least important heading.
Note: Only use one per page – this should represent the main heading/subject for the whole page. The tag defines a clickable button.

NEW QUESTION 52
What internal document explains privacy responsibilities to employees who will handle personally identifiable information?

Security policy

Integrity policy

Acceptable use policy

NEW QUESTION 53
Which of the following data manipulation techniques is an example of a logical function?

WHERE

AGGREGATE

BOOLEAN

NEW QUESTION 54
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?

SELECT.

ALTER.

INSERT.

UPDATE.

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.

NEW QUESTION 55
You only have one opportunity to answer each question on the Data+ exam.

True.

False.

NEW QUESTION 56
Which of the following value is the measure of dispersion “range” between the scores of ten students in a test.
The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

The correct answer is: 60
Range is the interval between the highest and the lowest score.
Range is a measure of variability or scatteredness of the varieties or observations among themselves and does not give an idea about the spread of the observations around some central value.
Symbolically R = Hs – Ls.
Where R = Range; Hs is the ‘Highest score’ and Ls is the Lowest Score.
The scores of ten students in a test are: 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.
The highest score is 77 and the lowest score is 17.
So the range is the difference between these two scores Range = 77 – 17 = 60

NEW QUESTION 57
Which one the following is not considered an aggregate function?

SUM

MIN

SELECT

MAX

Loading …