Which of the following is a control measure for preventing a data breach?

A. Data transmission
B. Data attribution
C. Data retention
D. Data encryption

A development company is constructing a new unit in its apartment complex. The complex has the following floor plans:

Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

A. $640,900
B. $690,000
C. $705,200
D. $702,500

Given the following customer and order tables:


Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

A. Five rows, eight columns
B. Seven rows, eight columns
C. Eight rows, seven columns
D. Nine rows, five columns

Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

A. Simple random
B. Cluster
C. Systematic
D. Stratified

Which of the following variable name formats would be problematic if used in the majority of data software programs?

A. First_Name_
B. FirstName
C. First_Name
D. First Name

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?

A. Trend analysis
B. Performance analysis
C. Link analysis
D. Exploratory analysis

An analyst has been asked to validate data quality. Which of the following are the BEST reasons to validate data for quality control purposes? (Choose two.)

A. Retention
B. Integrity
C. Transmission
D. Consistency
E. Encryption
F. Deletion

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. A control group for the phrases
B. A summary of the KPIs
C. Filter buttons for the status
D. The date when the report was last accessed
E. The time period the report covers
F. The date on which the report was run

Which of the following is used for calculations and pivot tables?

A. IBM SPSS
B. SAS
C. Microsoft Excel
D. Domo

Given the following data tables:



Which of the following MDM processes needs to take place FIRST?

A. Creation of a data dictionary
B. Compliance with regulations
C. Standardization of data field names
D. Consolidation of multiple data fields