A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

A. dependent data.

B. duplicate data.

C. invalid data

D. redundant data

A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team members should not be identifiable within the report. Which of the following access requirements would support the director’s needs?

A. Create an acceptable use policy for the sales data.

B. Release the report as user-group-based access and include data masking.

C. Get a data use agreement from the individual team members.

D. Provide the report based on role and include data encryption.

Which of the following is a characteristic of a relational database?

A. It utilizes key-value pairs.

B. It has undefined fields.

C. It is structured in nature.

D. It uses minimal memory.

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:
 
Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

A. Fill in the missing cost where it is null.

B. Separate the table into two tables and create a primary key.

C. Replace the extended cost field with a calculated field.

D. Correct the dates so they have the same format.

Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and standard deviation of the scores for each of the courses:
 
Using this information, which of the following students had the BEST score?

A. Randy

B. Katie

C. Ralph

D. Jean

Which of the following is the correct extension for a tab-delimited spreadsheet file?

A. .tap

B. .tar

C. .tsv

D. .taz

A collections manager has a team calling customers who are past due on their accounts in an attempt to collect payments. The manager receives the call list in the form of a printed report that is generated by the accounting department at the beginning of each week. Consequently, the collections team calls some customers who have made payments in the time since the report was last printed. Which of the following reporting enhancements could the accounting department implement to best reduce the number of calls on current accounts?

A. Modify the date range on the report.

B. Include a time stamp on the report.

C. Increase the frequency of report generation.

D. Add a report run date to the report.

Which of the following concepts should be applied if a data set with 40 fields needs to be pared down to 20 fields and contains similar data across multiple fields?

A. Duplication

B. Consolidation

C. Compliance

D. Standardization

Given the diagram below:
 
Which of the following data schemas shown?

A. Key-value pairs

B. Online transactional processing

C. Data lake

D. Relational database

Which of the following is an example of PII?

A. Age

B. Name

C. Ethnicity

D. Gender

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

A. Microsoft Power BI

B. R

C. SQL

D. Tableau

Five dogs have the following heights in millimeters:
300, 430, 170, 470, 600
Which of the following is the mean height for the five dogs?

A. 394mm

B. 405mm

C. 493mm

D. 504mm

A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

A. A real-time monitor that allows the manager to view performance the day the campaign was launched

B. A sell-service dashboard that allows the manager to look at the company’s annual budget performance

C. A spreadsheet of the raw data from all marketing campaigns and channels

D. A summary with statistics, conclusions, and recommendations from the data analyst

The number of phone calls that call center receives in a day is an example of:

A. continuous data.

B. categorical data.

C. ordinal data.

D. discrete data.

Company A recently merged with Company B and will be reporting first quarter numbers soon. Prior to the release, an analyst wants to ensure the data was accurately blended together. Which of the following is the MOST efficient way to ensure the data is reported correctly?

A. Assume the data was blended together and wait for feedback.

B. Filter on every column to look for inconsistencies in the data.

C. Spot check a few numbers to look for inconsistencies.

D. Review the files separately and ensure the blended totals match.

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 is the BEST description of the term “data governance”?

A. Data governance governs the development of a data visualization dashboard in an organization.

B. Data governance is the policy that protects against data breaches by cybercriminals.

C. Data governance is the process of analyzing, manipulating, and reporting data in an organization.

D. Data governance is the availability, usability, integrity and security of data in an enterprise.

A site reliability team wants to monitor the stability of their website, so they can proactively diagnose issues when they occur. Which of the following deliverables would best suit their needs?

A. A self-serve dashboard of website performance that updates in real time

B. A weekly log report of site visits and user actions

C. A portal that is refreshed daily and reports errors classified by type

D. A daily summary email indicating website outages for the previous day

Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

A. Rephrase the business requirement.

B. Determine the data necessary for the analysis.

C. Build a mock dashboard/presentation layout.

D. Perform exploratory data analysis.

Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?

A. Dynamic

B. Recurring

C. Ad hoc

D. Self-service

A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods should the analyst use to find the measure of dispersion?

A. Mean

B. Variance

C. Correlation

D. Confidence interval

A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below:
 
Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

A. Date

B. Mathematical

C. Logical

D. Aggregate

Which of the following BEST describes standard deviation?

A. A measure that is used to establish a relationship between two variables

B. A measure of how data is distributed

C. A measure of the amount of dispersion of a set of values

D. A measure that is used to find the significant difference between variables

A data analyst must separate the column shown below into multiple columns for each component of the name:
 
Which of the following data manipulation techniques should the analyst perform?

A. Imputing

B. Transposing

C. Parsing

D. Concatenating

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

A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

A. non-relational schema.

B. galaxy schema.

C. snowflake schema.

D. star schema.

Given the image below:
 
The data should be cleaned because of the presence of:

A. outliers.

B. non-parametric data.

C. multicollinearity.

D. invalid data.

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

A. WHERE

B. AGGREGATE

C. BOOLEAN

D. IF

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 table below:
 
Which of the following boxes indicates that a Type II error has occurred?

A. 1

B. 2

C. 3

D. 4

A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank.
Considering this data is PHI, which of the following would be the best way for the commander to view the information?

A. An emailed report

B. A password-protected dashboard

C. A daily printout of a report

D. A cloud-hosted spreadsheet

An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?

A. Conduct an exploratory analysis and use descriptive statistics.

B. Conduct a trend analysis and use a scatter chart.

C. Conduct a link analysis and illustrate the connection points.

D. Conduct an initial analysis and use a Pareto chart.

Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5,000,000 rows?

A. Microsoft Excel

B. R

C. Snowflake

D. SQL

A data analyst is using a two-tailed, independent t-test to determine whether the type of stretching, dynamic or static, has any influence on a dancer’s flexibility. Which of the following is the alternative hypothesis?

A. A dancer’s flexibility is improved through static stretching.

B. The change in a dancer’s flexibility is not equal to zero.

C. There is a difference in a dancer’s flexibility between static and dynamic stretching.

D. The means of the static and dynamic stretching groups do not differ from each other.

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

A data analyst works for a condominium development company. The company is undergoing unit number changes. Which of the following would be MOST appropriate to include on the unit inventory sheet that is shown in board meetings?

A. Display a column with historical unit numbers and new unit numbers.

B. Create a new unit inventory with new unit numbers only.

C. Delete historical files with previous unit numbers.

D. Create a hidden column that shows the historical unit numbers.

An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

A. Web scraping

B. Sampling

C. Data wrangling

D. ETL

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

Given the table below:
 
Which of the following variable types BEST describes the “Year” column?

A. Numeric

B. Date

C. Alphanumeric

D. Text

Joe, an analyst, tests the loading time on a dashboard he is preparing to go live and finds it is slower than he would like. Which of the following must occur to decrease the loading time?

A. Deploy the dashboard to production.

B. Change the field definitions.

C. Update the dashboard subscribers.

D. Optimize the dashboard.

Which of the following is an example of a at flat file?

A. CSV file

B. PDF file

C. JSON file

D. JPEG file

A data analyst is reviewing the results of a survey. Respondents used the terms “avg,” “average,” and “avg.” throughout the survey in a response for the word “average.” Because of this, the analyst changed all related answers to say “average.” Which of the following are reasons why the analyst MOST likely made these changes? (Choose two.)

A. Data attribute limitations

B. Data accuracy

C. Data completeness

D. Data manipulation

E. Data blending

F. Data consistency

A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:
 
Which of the following types of charts should be considered?

A. Include a line chart using the site and average sales per customer.

B. Include a pie chart using the site and sales to average sales per customer.

C. Include a scatter chart using sales volume and average sales per customer.

D. Include a column chart using the site and sales to average sales per customer.

Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

A. SAS

B. Microsoft Power BI

C. IBM SPSS

D. Python

Which of the following is a best practice when updating a legacy data source?

A. Placing old data in new fields

B. Keeping only the most recent data

C. Creating a codebook to document field changes

D. Removing the data source from production

A home builder is offering a 30% discount on condominium units. Given the table below:
 
Which of the following is the range of savings for the units listed in the table?

A. $103,500 to $157,500

B. $241,500 to $367,500

C. $320,000 to $386,000

D. $345,000 to $525,000

A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?

A. Frequency

B. Percent change

C. Variance

D. Mean

Which of the following are reasons to create and maintain a data dictionary? (Choose two.)

A. To improve data acquisition

B. To remember specifics about data fields

C. To specify user groups for databases

D. To provide continuity through personnel turnover

E. To confine breaches of PHI data

F. To reduce processing power requirements

An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

A. Scatter plot

B. Heat map

C. Pie chart

D. Infographic