A data engineer needs to add a process that will run after an employee table is loaded. The engineer does not know the name of the process that loads employee data. Which of the following is the best document for the engineer to review to find this information?
A. Data flow diagram
B. Data dictionary
C. Data explainability report
D. Data lineage report
Show Answer
Correct Answer: D
Explanation: A data lineage report traces the employee table’s origin and the processes that create or transform it, helping identify the process that loads it. A data dictionary describes the table’s fields, while a data flow diagram is generally a broader view of data movement.
Question 62
Which of the following AI types is the best option for time-series forecasting?
A. Generative AI
B. Foundational models
C. Natural language processing
D. Robotic process automation
Show Answer
Correct Answer: B
Explanation: Foundational models can be adapted to recognize patterns in historical time-series data and predict future values. NLP and robotic process automation are not primarily designed for forecasting.
Question 63
Which of the following best describes the storage type that provides a unique identifier and metadata information?
A. Block storage
B. Object storage
C. File storage
D. Shared storage
Show Answer
Correct Answer: B
Explanation: Object storage stores data as objects, each with a unique identifier and associated metadata.
Question 64
A data analyst needs to modify a dashboard that was created by another employee. Upon opening the dashboard, the analyst notices that the information is not loading properly. Which of the following should the analyst do to troubleshoot this error?
A. Review the data layer and data source
B. Validate that the database is up to date
C. Check that the program is updated to the latest version.
D. Ensure the correct filters are displaying on the dashboard
Show Answer
Correct Answer: A
Explanation: If dashboard information is not loading, first review the data layer and data source to confirm that the dashboard is connected to the correct data and that the connection is configured properly.
Question 65
A data analyst is compiling a report called "Product Category Sales Performance Summary Report" based on the following table:
Which of the following charts is the most appropriate?
A. Gantt
B. Waterfall
C. Column
D. Area
Show Answer
Correct Answer: C
Explanation: A column chart is appropriate for comparing sales values across discrete product categories. Gantt charts show schedules, waterfall charts show cumulative changes, and area charts emphasize trends over time.
Question 66
An analyst needs to make a collection of sales dashboards for С-suite members, managers, and salespeople. Which of the following should the analyst consider when designing these dashboards?
A. Branding
B. Accessibility
C. User persona type
D. Sensitive information
Show Answer
Correct Answer: C
Explanation: The dashboards serve audiences with different responsibilities and information needs. Considering each user persona helps tailor the metrics, level of detail, and views for executives, managers, and salespeople.
Question 67
An analyst needs to combine the following two tables. The analyst needs to keep all the records in the Medals table and only the records that match from the Country table.
Which of the following methods should the analyst use for this task?
A. Join
B. Insert
C. Union
D. Append
Show Answer
Correct Answer: A
Explanation: Use a join—specifically a left join—with Medals as the left table. It keeps every record in Medals and includes only matching records from Country.
Question 68
An analyst needs to create a collection of dashboards for multiple teams within the organization. Which of the following should the analyst do first before starting the project?
A. Evaluate the user persona type for the dashboards.
B. Determine the number of team members who need to access the dashboards.
C. Determine the delivery method of the dashboards.
D. Evaluate the KPIs for the dashboards.
Show Answer
Correct Answer: A
Explanation: Evaluate the user personas first to understand each team’s roles, goals, and information needs. That audience context guides the choice of KPIs, dashboard design, and delivery method.
Question 69
A data analyst is creating a forecast for a product line introduced early last year. Which of the following should the analyst use to create projected sales and customer satisfaction for next year?
A. Standard deviation and constraints
B. Mean and median
C. Boolean data and an array
D. Numerical and ordinal attributes
Show Answer
Correct Answer: D
Explanation: Sales are quantitative values, so they are represented by numerical attributes. Customer satisfaction levels are typically ordered categories (such as poor, fair, and excellent), so they are represented by ordinal attributes.
Question 70
A data analyst wants to understand several data sets at the variable level. Which of the following should the analyst consult to find this information?
A. Data lineage
B. Data dictionary
C. Data flow diagram
D. Data versioning
Show Answer
Correct Answer: B
Explanation: A data dictionary documents dataset variables, including their names, definitions, data types, and permitted values, so it is the right resource for understanding data at the variable level.
$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.