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 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.

Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?

A. R

B. Python

C. SQL

D. SAS

A data analyst is developing a data dictionary that aligns with a company’s data management processes and policies. Which of the following best describes what should be included in the data dictionary?

A. Information containing the links to business data

B. Information explaining the business methodologies

C. Information containing definitions of the business data

D. Information describing the data analysis phases

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?

A. Aggregate

B. Logical

C. Date

D. Sort

A survey asks participants to rate a company on a scale of one to ten. Which of the following BEST describes the rating variable?

A. Continuous

B. Ordinal

C. Categorical

D. Nominal

Which of the following BEST defines a data outlier?

A. A datapoint that is significantly close to the trend line

B. A datapoint that has the highest significant number of observations

C. A datapoint that differs significantly from other observations

D. A datapoint that is above the trend line

Given the following graph:
 
Which of the following summary statements upholds integrity in data reporting?

A. Sales are approximately equal for Product A and Product B across all strategies.

B. Strategy 4 provides the best sales in comparison to other strategies.

C. While Strategy 2 does not result in the highest sales of Product D, over all products it appears to be the most effective.

D. Product D should be promoted more than the other products in all strategies.

An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?

A. A gap analysis

B. A link analysis

C. A trend analysis

D. A statistical analysis

A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?

A. A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.

B. A systematic survey that is sent to 100 single-family homes in the county

C. Surveys sent to ten randomly selected homes within 5mi (8km) of the county’s office

D. Surveys sent to 100 randomly selected homes that are reflective of the population

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.

A human resources analyst needs to build a new visualization to highlight the company’s hierarchy. Which of the following would be the best way to do this?

A. A stacked chart

B. An infographic

C. A word cloud

D. A tree map

A data analyst has just finished cleansing a database table and is now ready to update the master. However, the analyst must first check to ensure all the work is accurate. Which of the following data quality checkpoints is the analyst using?

A. Data source

B. Data product

C. Data retrieval

D. Data transformation

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

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 marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought product, at what frequency, and at what value. Which of the following types of analysis would this practice be considered?

A. Prescriptive

B. Trend

C. Gap

D. Custer

A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

A. Create multiple reports, one for each needed date range.

B. Build calculations into the report so they are done automatically.

C. Add macros to the report to speed up the filtering and calculations process.

D. Create a dashboard with a date range picker and calculations built in.

A business analyst reviews the following text:
txt = “I have registered for a certification exam and will take it within a couple of months. I need to work hard to pass the exam with flying colors.”
The analyst then splits the string into two parts:
txt1 = “I have registered for a certification exam and will take it within a couple of months.”
txt2 = “I need to work hard to pass the exam with flying colors.”
Which of the following BEST describes the process the business analyst is following?

A. Data blending

B. Data appending

C. Imputation

D. String manipulation

Which of the following is a process that is used during data integration to collect, blend, and load data?

A. MDM

B. ETL

C. OLTP

D. BI

Different people manually type a series of handwritten surveys into an online database. Which of the following issues will MOST likely arise with this data? (Choose two.)

A. Data accuracy

B. Data constraints

C. Data attribute limitations

D. Data bias

E. Data consistency

F. Data manipulation

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 BEST describes an ad hoc report?

A. A one-time report

B. A recurring report

C. A tactical report

D. A monthly report

A company derives proprietary leads from monthly sales calls and sends them to dealers through a connection that matches the correct leads to the correct dealers Which of the following BEST describes this method?

A. Application programming interface

B. Public databases

C. Survey

D. Web scraping

Which of the following best describes a business analytics tool with interactive visualization and business capabilities and an interface that is simple enough for end users to create their own reports and dashboards?

A. Python

B. R

C. Microsoft Power BI

D. SAS

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

Which of the following is a non-parametric test?

A. One-sample t-test

B. Two-way ANOVA

C. Correlation coefficient

D. Spearman’s rank correlation

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

An analyst is working on a project for a director. During this process, the analyst pulled the data, created summarized tables and graphs with descriptions, created a report summary, and inserted all items into a report. After writing the report, which of the following would be the most appropriate next step?

A. Complete an audit on the data pulled for the report.

B. Complete a check for quality in the report.

C. Complete a review of the data and a check for consistency.

D. Complete a trend analysis to be included in the report.

Which of the following data acquisition concepts is the most appropriate for determining the quality of a company’s product?

A. Web scraping

B. Observation

C. Survey

D. Sampling

A data analyst received the information in the table below from a recently completed marketing campaign:
 
Which of the following is the total order conversion rate?

A. 13.2%

B. 14.8%

C. 22.3%

D. 85.2%

An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

A. Optimize the dashboard.

B. Create subscriptions.

C. Get stakeholder approval.

D. Deploy to production.

Which of the following is the correct data type for text?

A. Boolean

B. String

C. Integer

D. Float

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

During data profiling, an analyst decides to recode the status column in the following data set:
 
Which of the following data concerns explains why the analyst wants to take this action?

A. Redundancy

B. Duplication

C. Invalidity

D. Inconsistency

Given the data below:
 
In which of the following file formats is the data presented?

A. XLS

B. CSV

C. RTF

D. XML

Data was previously stored in the following relational tables:
 
 
A database architect changes the relational database structure to include an additional lookup table, which includes the following:
 
Which of the following MDM issues does this change in structure solve?

A. Multiple redundant data fields

B. Non-compliance with regulations

C. Unstandardized field names

D. Difficulties with personnel continuity

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.

A market research firm has data sets based on surveys. A data analyst wants to know if any outliers are present in a data set. Which of the following would be the BEST method to examine the numerical variables in the data set visually and find any outliers?

A. Plot the linear correlations between each pair of variables and look for unusual relationships

B. Create a bar chart for each variable and look for any distributions that are unusual.

C. Build a scatter plot of each variable and look for observations that are out of place.

D. Order each variable in a spreadsheet from lowest to highest and look for unusual numbers at the beginning or at the end of the list.

Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)

A. Data identification

B. Data processing

C. Data reporting

D. Data encryption

E. Data masking

F. Fata removal

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.

Given the following data:
 
Which of the following BEST describes the data set?

A. There is data bias.

B. The data is incomplete.

C. The data is inconsistent.

D. The data is outliers.

Given the following numbers:
7, 2, 3, 3, 5
Which of the following is the mean?

A. 2

B. 3

C. 4

D. 7

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

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 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

An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798. Which of the following should be the total number of datapoints on the next day?

A. 7,038

B. 9,600

C. 10,600

D. 10,800

An analyst must obtain the average daily sales for the following week:
 
Which of the following must the analyst perform to obtain this value?

A. Data normalization

B. Data append

C. Data aggregation

D. Data blending

The duration of a phone call in milliseconds is an example of:

A. ordinal data.

B. nominal data.

C. boolean data.

D. continuous data.

A company wants to determine how its products have been selling over time. The company would like to know about the number of items sold, the category of the product, and the revenue that is generated from that product.
Which of the following tables includes all the information a business analyst would need to fulfill the request?

A.

B.

C.

D.

A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

A. Display the version number next to each submission on the dashboard.

B. Present a data refresh date at the top of the dashboard.

C. Confirm the dashboard is adhering to the corporate style guide.

D. Use permissions to ensure users only see certain versions of the submissions.