294 practice questions with answers and explanations.
A data analyst needs to calculate the mean for Q1 sales using the data set below: Which of the following is the mean?
The correct answer is A. Option A: $2,466.18
A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way to deliver this report?
The correct answer is D. Option D: A dashboard with filters at the top that the user can toggle
A customer list from a financial services company is shown below: A data analyst wants to create a likely-to-buy score on a scale from 0 to 100, based on an average of the three numerical variables: number of credit cards, age, and income. Which of the following should the analyst do to the variables to ensure they all have the same weight in the score calculation?
The correct answer is D. Option D: Normalize the variables. This option scales automatically to match demand.
Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)
The correct answer is D, E. Option D: Data encryption Option E: Data masking
Explanation
Encryption protects confidentiality by making data unreadable without the appropriate key.
A data analyst has been asked to organize the table below in the following ways: By sales from high to low - By state in alphabetic order - Which of the following functions will allow the data analyst to organize the table in this manner?
The correct answer is D. Option D: Sorting
Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?
The correct answer is D. Option D: Invalid data type
Which of the following is a process that is used during data integration to collect, blend, and load data?
The correct answer is B. Option B: ETL
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?
The correct answer is C. Option C: Get stakeholder approval.
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?
The correct answer is C. Option C: Logical
Given the diagram below: Which of the following data schemas shown?
The correct answer is D. Option D: Relational database
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?
The correct answer is D. Option D: Custer
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?
The correct answer is A. Option A: Display the version number next to each submission on the dashboard.
The number of phone calls that call center receives in a day is an example of:
The correct answer is D. Option D: discrete data.
A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business’s performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types should the data analyst create?
The correct answer is A. Option A: Static
Which of the following would be considered non-personally identifiable information?
The correct answer is A. Option A: Cell phone device name
Which of the following is the correct data type for text?
The correct answer is B. Option B: String
Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?
The correct answer is B. Option B: Determine the data necessary for the analysis.
Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?
The correct answer is D. Option D: Python
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?
The correct answer is D. Option D: A summary with statistics, conclusions, and recommendations from the data analyst
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?
The correct answer is D. Option D: Delimit
Showing questions 1–20 of 294 · Page 1 of 15