A data analyst wants to analyze sales data for possible customer patterns. Which of the following should the analyst use to complete this task?
A. Standardizing
B. Clustering
C. Merging
D. Scaling
Show Answer
Correct Answer: B
Explanation: Clustering groups customers or sales records with similar characteristics, allowing the analyst to identify patterns and customer segments in the data.
Question 32
A data analyst wants to isolate a serial number from a string of code. Which of the following data transformation techniques should the analyst use?
A. Exploding
B. Appending
C. Merging
D. Parsing
Show Answer
Correct Answer: D
Explanation: Parsing extracts a specific piece of information, such as a serial number, from a larger string of code.
Question 33
A data analyst needs to summarize the number of customers who contacted the business in the last year by contact type. The Contact_Type table is in a file and has one million rows. Based on the following sample:
Which of the following is the most efficient for the analyst to use?
A. Math function
B. Query
C. Filter
D. Pivot table
Show Answer
Correct Answer: D
Explanation: A pivot table can group the million-row dataset by contact type and count the customers in each group, making it an efficient way to summarize the data.
Question 34
A company experiences a data breach that exposes some customers’ information. A data analyst must categorize the customer data into fully affected, partially affected, and not affected. Which of the following is the best technique to use to quantify the extent of the breach?
A. Standardizing
B. Appending
C. Binning
D. Parsing
Show Answer
Correct Answer: C
Explanation: Binning groups records into predefined categories. The analyst can place customers into fully affected, partially affected, or not affected groups to quantify the breach’s extent.
Question 35
A data analyst needs to create a report that anticipates the number of calls received daily. Which of the following is the best statistical method to use?
A. Predictive
B. Diagnostic
C. Inferential
D. Descriptive
Show Answer
Correct Answer: A
Explanation: Predictive analysis uses historical data and statistical methods to forecast future outcomes, such as the number of calls expected each day.
Question 36
An engineer needs to build an ETL process to calculate the average sales of individual stores. Each store sends their sales data as .csv files. Which of the following would the engineer most likely do to the data?
A. Parse the files to create individual data sets
B. Convert the values to different data types
C. Impute any missing date values
D. Merge the files with an open-source data set
Show Answer
Correct Answer: A
Explanation: The engineer would parse each store’s CSV file into structured data so the sales records can be processed and used to calculate that store’s average sales. The question does not indicate a need to change data types, impute dates, or add external data.
Question 37
A data analyst pulls a table similar to the following one:
Which of the following best explains the data issue with TypeID?
A. Redundancy
B. Outlier
C. Missing data
D. Duplication
Show Answer
Correct Answer: D
Explanation: The same TypeID appears more than once, which indicates duplication.
Question 38
A data analyst receives an email from the IT department about updating their company password, and the analyst follows the password reset link as required Later in the week, the analyst receives the following notification when running a reoccurring analysis that connects to the database
Log-in failed for user '[username]'
Which of the following is most likely the reason for this issue?
A. The company changed its database authentication method
B. The password expiration process locked the account
C. The analyst did not change the password used to launch the report
D. The company is experiencing issues with password replication.
Show Answer
Correct Answer: C
Explanation: The recurring analysis likely uses saved database credentials. After the analyst changed their password, the report continued trying to connect with the old password, causing the database login to fail.
Question 39
Given the following cloud service provider data:
Which of the following is the best way to represent the information?
A. Donut chart
B. Scatter plot
C. Area chart
D. Gantt chart
Show Answer
Correct Answer: A
Explanation: A donut chart is suitable for showing how each cloud service provider contributes to a whole, such as total market share or users.
Question 40
The following SQL code returns an error in the program console:
SELECT firstName, lastName, SUM (income)
FROM companyRoster
SORT BY lastName, income
Which of the following changes allows this SQL code to run?
A. SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income)> 10000000
B. SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName
C. SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income
D. SELECT firstName, lastName, SUM(income) FROM companyRoster
Show Answer
Correct Answer: B
Explanation: `SUM(income)` is an aggregate, while `firstName` and `lastName` are non-aggregated columns. They must be included in a `GROUP BY` clause, as in option B.
$19
Get all 146 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.