Which of the following would a data analyst look for first if 100% participation is needed on survey results?
A. Missing data
B. Invalid data
C. Redundant data
D. Duplicate data
Which of the following techniques is used to quantify data?
A. Decoding
B. Enumeration
C. Coding
D. Structure
A data analyst for a media company needs to determine the most popular movie genre. Given the table below:
Which of the following must be done to the Genre column before this task can be completed?
A. Append
B. Merge
C. Concatenate
D. Delimit
A company's human resources department has asked a data analyst to categorize the income of all employees into five salary bands:
Which of the following types of functions would be the most appropriate to use?
A. Statistical
B. Aggregate
C. Logical
D. Mathematical
Which of the following differentiates a flat text file from other data types?
A. Data is separated by a delimiter.
B. Data is stored in defined rows.
C. Data is defined with key-value pairs.
D. Data is housed in a markup language.
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
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,466.18
B. $2,667.60
C. $3,082.72
D. $12,330.88
What role in a data governance is typically responsible for day-to-day oversight of data use?
A. Data processors.
B. Data custodians
C. Data owners.
D. Data stewards.
Given the image below:
The data should be cleaned because of the presence of:
A. outlier B. non-parametric data.
C. multicollinearity.
D. invalid data.
Which of the following best describes the law of large numbers?
A. As a sample size decreases, its standard deviation gets closer to the average of the whole population.
B. As a sample size grows, its mean gets closer to the average of the whole population
C. As a sample size decreases, its mean gets closer to the average of the whole population.
D. When a sample size doubles. the sample is indicative of the whole population.