A data analyst has a set with more than 40.000 rows in the sample schema below:

The analyst would like to create one column that contains the customers’ birth dates. Which of the following data quality dimensions would BEST explain the reason for compilation?

A. Data accuracy

B. Data completeness

C. Data duplication

D. Data integrity

A data analyst received a large amount of third-party data that needs to be joined with inhouse data files. After the data is joined, the analyst notices three columns all contain dates. Which of the following should the analyst do to maintain data consistency?

A. Append all date columns and parse the strings.

B. Impute all three date columns and then merge.

C. Merge all date columns and unify the format.

D. Separate the columns into a table and merge.

Which of the following is the BEST reason to use database views instead of tables?

A. Views reduce the need for repetitive, complex data joins.

B. Views allow for the storage of temporary data. whereas tables do not.

C. Views allow for the joining of multiple data sources, whereas tables do not.

D. Views can be used to restrict sensitive information.

Which of the following best describes an exploratory analysis?

A. Involves the use of descriptive statistics to understand observations

B. Involves analysis of exploring data sets for performance tracking

C. Involves the testing of specific hypotheses

D. Involves the use of arithmetic algebra to determine the distribution

Given the following table:

Date of visit
Age
Gender
6/1/22
30
Male
6/15/22
65F
Fem.
6/19/2022
24
M

Which of the following describes the data quality issues with the age data?

A. Completeness

B. Consistency

C. Accuracy

D. Manipulation

Which of the following is an example of discrete data?

A. The number of employees at a company

B. The amount of rain that falls in a storm

C. The temperature at a weather station

D. The power consumption in a building

Kelly wants to get feedback on the final draft of a strategic report that has taken her six months to develop.

What can she do to get prevent confusion as see seeks feedback before publishing the report?

Choose the best answer.

A. Distribute the report to the appropriate stakeholders via email.

B. Use a watermark to identify the report as a draft.

C. Show the report to her immediate supervisor.

D. Publish the report on an internally facing website.

An analyst is training a new coworker on the importance of data governance and is focusing on security requirements. Which of the following should the analyst include in the training?
(Select two).

A. Data masking

B. Data encryption

C. Data parallelism

D. Data inclusiveness

E. Data exclusiveness

F. Data openness

A research analyst collects ten data points from 1.000 specimens. The analyst will not need any additional data to complete the analysis and will not need to retrieve information by specifier.

Which of the following is the best data structure for the analyst to use?

A. NoSQL

B. Flat file

C. JSON

D. Relational database

Which one of the following in NOT a common data integration tool?

A. XSS

B. ELT

C. ETL

D. APIs

Which of the following technologies would be best suited for creating a multiple linear regression model?

A. Microsoft Power Bl

B. R

C. SQL

D. Tableau

Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

A. Numeric

B. Date

C. Float

D. Text