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 sales manager wants quarterly sales reports broken down by unit and week. Which of the following data output lists includes the most necessary information?

A. Order number, salesperson, date shipped, recipient address, and price

B. Item name, salesperson, recipient address, shipping cost, and date shipped

C. Item number, item name, salesperson, date sold, and price

D. Item name, salesperson, price, shipping cost, and date shipped

The accounting team has requested a series of self-serve, dynamic reports. Aside from the reporting time frame, the report criteria are identical. Which of the following should the analyst create?

A. A single report with the option to select the date range

B. One consolidated report with all available data

C. Automated reports to be distributed based on the time frames in the requirements

D. The reports as requested in the requirements document

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 data cleansing issues will be fixed when a DISTINCT function is applied?

A. Missing data

B. Duplicate data

C. Redundant data

D. Invalid data

Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

A. Duplicate data

B. Missing data

C. Data outliers

D. Invalid data type

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

A. Numeric

B. Date

C. Alphanumeric

D. Text

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

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

Which of the following BEST describes the difference between discrete and continuous values?

A. Discrete values change.

B. Discrete values are not distinct.

C. Continuous values are restricted by separation.

D. Discrete values are obtained by counting.

A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

A. Use scheduled report delivery.

B. Implement subscription access delivery.

C. Print out a copy.

D. Upload the report to the server.

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.

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 data sampling methods involves dividing a population into subgroups by similar characteristics?

A. Systematic

B. Simple random

C. Convenience

D. Stratified

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 is preparing a report that contains weather data. The temperatures are shown in Fahrenheit, but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

A. Normalize the data.

B. Standardize the data.

C. Rescale the data.

D. Aggregate the data.

Which of the following is an example of a discrete variable?

A. The temperature of a hot tub

B. The height of a horse

C. The time to complete a task

D. The number of people in an office

An analyst needs to create a dashboard with three tiers of information: management, general public (internal users), and external stakeholders. The management team should be able to see all data, while the internal and external groups should see only subsets of that data.
Which of the following is the BEST delivery consideration for the dashboard?

A. Create access permissions so users only see data that is applicable to their user group.

B. Make the dashboard interactive so users can find the data that applies to them.

C. Create an option to save an individual user’s searches and filters by user ID.

D. Create three separate dashboards, one for each user group.

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

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

Which of the following inferential statistical methods would be used to determine if there is a significant difference between the means of two groups?

A. p-value

B. Z-score

C. Chi-squared test

D. t-test

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 has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?

A. Determine the data needs and review the observations.

B. Determine the data needs and sources for analysis.

C. Determine the data needs and schedule interviews.

D. Determine the data needs and begin the analysis.

Which of the following statistical methods requires two or more categorical variables?

A. Simple linear regression

B. Chi-squared test

C. Z-test

D. Two-sample t-test

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.

A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day’s performance. Which of the following reports should the analyst provide?

A. Tactical

B. Ad hoc

C. Dynamic

D. Recurring

A data analyst needs to survey customers about their preferences for various types of soda. Which of the following sampling methods should the analyst use to collect the survey data?

A. Simple random sampling

B. Parameterization sampling

C. Index sampling

D. Single-stage sampling

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

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

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 statements would be used to append two tables that have the same number of columns?

A. UNION ALL

B. MERGE

C. GROUP BY

D. JOIN

After completing web scraping, which of the following file formats needs to be parsed?

A. .html

B. .txt

C. .csv

D. .tsv

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 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 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 image below:
 
Which of the following data schemas is portrayed?

A. Non-relational

B. Galaxy

C. Snowflake

D. Star

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.

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.

SIMULATION -
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.
 
 
 
 
 

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

An analyst reviews the following table:
 
Which of the following data types is represented in the values in the RefNo column?

A. Numeric

B. Text

C. Currency

D. Alphanumeric

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 data analytics tools would be BEST to retrieve data from a relational database management system?

A. R

B. Python

C. SQL

D. SAS

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

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

A data analyst has been asked to create a daily manufacturing report for the floor manager. Which of the following metrics should be included in the report?

A. Tons of steel produced per hour

B. Annual sales budget

C. End-of-day stock price

D. Daily corporate employee count

A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

A. January 1, 2020 to April 1, 2020

B. January 1, 2020 to April 7, 2020

C. January 1, 2020 to April 8, 2020

D. January 1, 2020 to April 9, 2020

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

A. Boolean

B. String

C. Integer

D. Float

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