A data analyst is creating a user sentiment analysis for a new product. Which of the following is the best method to acquire the data?
A. Surveying customers
B. Sampling sources
C. Querying databases
D. Downloading open data
Show Answer
Correct Answer: A
Explanation: Surveying customers directly gathers their opinions and feelings about the new product, making it the best method for user sentiment analysis.
Question 12
A data analyst creates a report, and some of the fields are empty. Which of the following conditions should the analyst add to a query to provide a list of all the records with empty fields?
A. WHERE [ColumnName] = NULL
B. WHERE [ColumnName] IS NULL
C. WHERE [ColumnName] IS NOT NULL
D. WHERE [ColumnName] = 'NULL'
Show Answer
Correct Answer: B
Explanation: Use `IS NULL` to match records where the column has a SQL NULL value. `= NULL` does not work for NULL comparisons, while `IS NOT NULL` finds non-NULL values and `'NULL'` is a text string.
Question 13
A data analyst is working on a three-year project to deliver sales reports on a monthly basis. The client wants a thorough analysis into customer profiles for a specific region and month. Which of the following delivery methods best fulfills this request?
A. Dynamic
B. Self-service
C. Ad hoc
D. Dashboard
Show Answer
Correct Answer: C
Explanation: An ad hoc report is tailored to a specific, detailed request—here, analyzing customer profiles for one region and month—rather than the project’s recurring monthly sales reports.
Question 14
A project manager requests an unscheduled report that provides a list of clients. Which of the following frequencies is best for this report?
A. Annual
B. Daily
C. Weekly
D. Ad hoc
Show Answer
Correct Answer: D
Explanation: An unscheduled report created in response to a specific request is an ad hoc report.
Question 15
A company's entire server environment is located at the company’s headquarters. Which of the following describes this type of environment?
A. Cloud
B. On premises
C. Public
D. Hybrid
Show Answer
Correct Answer: B
Explanation: An on-premises environment has servers and IT infrastructure physically located at the company’s own facilities, such as its headquarters.
Question 16
A data analyst is designing a report for a grocery chain and needs to include stores, product placement, and SKUs. Which of the following best describes the data management concept that the analyst is considering?
A. Versioning
B. Hierarchy
C. Monitoring
D. Lineage
Show Answer
Correct Answer: B
Explanation: Hierarchy organizes related data into levels. Stores, product placements, and SKUs can be represented as connected levels in a grocery report.
Question 17
A data analyst needs to combine the results of two separate queries that have similar data and the same number of columns. The output must also have distinct rows. Which of the following should the data analyst use?
A. Outer join
B. Aggregate
C. Union
D. Concatenate
Show Answer
Correct Answer: C
Explanation: Use a UNION to combine query results with compatible columns. UNION returns distinct rows by default, removing duplicates.
Question 18
Which of the following data repositories should a company use when structured data about the whole company needs to be stored in a predefined data structure?
A. Data mart
B. Data warehouse
C. Data silo
D. Data lake
Show Answer
Correct Answer: B
Explanation: A data warehouse stores structured data from across the company in a predefined schema, supporting enterprise-wide reporting and analysis.
Question 19
Which of the following best explains the purpose of data lineage?
A. To see the steps and path of data flow through different systems
B. To better understand the granularity of data variable relationships
C. To track data transformations from acquisition through reporting
D. To look up data definitions, ensuring consistent use across business units
Show Answer
Correct Answer: C
Explanation: Data lineage tracks data’s movement and transformations from its source or acquisition through processing to its final use in reports. Option C best captures that end-to-end purpose.
Question 20
A data analyst needs to identify outliers from a given data set. Which of the following visualizations is the best way to identify outliers?
A. Box plot
B. Scatter plot
C. Gantt chart
D. Waterfall chart
Show Answer
Correct Answer: A
Explanation: A box plot summarizes a variable’s distribution and highlights potential outliers as points beyond the whiskers. Scatter plots can reveal outliers in relationships between two variables, while Gantt and waterfall charts are intended for other purposes.
$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.