A data analyst needs to calculate the mean for Q1 sales using the data set below:
Which of the following is the mean?
Correct Answer:
A
🗳️
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?
Correct Answer:
D
🗳️
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?
Correct Answer:
D
🗳️
Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)
Correct Answer:
DE
🗳️
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?
Correct Answer:
D
🗳️
Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?
Correct Answer:
D
🗳️
Which of the following is a process that is used during data integration to collect, blend, and load data?
Correct Answer:
B
🗳️
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?
Correct Answer:
A
🗳️
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?
Correct Answer:
C
🗳️
Given the diagram below:
Which of the following data schemas shown?
Correct Answer:
D
🗳️