HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: A data analyst
Explanation: A data analyst explores and analyzes data to identify patterns and trends, and presents insights through visualizations and reports. Data engineers focus on data pipelines, and database administrators manage and maintain databases.
Question 50
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: semi-structured
Explanation: JSON has a defined format but allows flexible, variable properties per entity, which characterizes semi-structured data.
Question 51
DRAG DROP
-
Match the job roles to the appropriate tasks.
To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: Database administrator → Assign permissions to users.
Data analyst → Derive meaning from data by creating visualizations and charts.
Data engineer → Implement pipelines to transfer and transform data between systems.
Explanation: Database administrators manage access and security. Data analysts focus on insights and visualization. Data engineers design and maintain data pipelines.
Question 52
DRAG DROP
-
Match the job roles to the appropriate tasks.
To answer, drag the appropriate job role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: Create a pipeline to transfer data from a database to a data warehouse.
Data engineer
Create a transactional database.
Data architect
Create a chart that shows sales transactions by week.
Data analyst
Explanation: Data engineers build data pipelines and integrations. Data architects design and define core data systems, including transactional databases. Data analysts focus on analyzing data and creating reports and visualizations.
Question 53
You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?
A. online transaction processing (OLTP)
B. online analytical processing (OLAP)
C. extract, transform and load (ETL)
D. a data warehouse
Show Answer
Correct Answer: A
Explanation: A banking application that transfers money into and out of accounts handles many short, atomic, real-time transactions and must ensure consistency, isolation, and durability. These characteristics define an online transaction processing (OLTP) system, not analytical, ETL, or data warehousing solutions.
Question 54
DRAG DROP
-
Match the job roles to the appropriate tasks.
To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Show Answer
Correct Answer: Database administrator → Database backup and recovery
Data analyst → Enabling advanced analytic capabilities through reports
Data engineer → Monitoring data pipelines
Explanation: Database administrators handle backup and recovery. Data analysts focus on reporting and analytics. Data engineers build and monitor data pipelines and infrastructure.
Question 55
Which activity is most common for transactional workloads?
A. recording small units of work events in real time
B. aggregating massive amounts of data
C. producing complex reports
D. performing self-service data exploration
Show Answer
Correct Answer: A
Explanation: Transactional workloads (OLTP) are characterized by high volumes of small, simple operations that record or update individual events in real time, such as inserts and updates. Aggregation, complex reporting, and self-service exploration are typical of analytical (OLAP) workloads.
Question 56
A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail.
Of which ACID semantic is this an example?
A. consistency
B. durability
C. atomicity
D. isolation
Show Answer
Correct Answer: C
Explanation: The requirement that debiting and crediting must either both occur or both fail describes atomicity. Atomicity treats a transaction as an all-or-nothing unit: if any part fails, the entire transaction is rolled back so no partial effects remain.
Question 57
Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?
A. Hot to Cool
B. Hot to Archive
C. Cool to Archive
D. Archive to Cool
Show Answer
Correct Answer: D
Explanation: Blob rehydration is required when moving a blob out of the Archive tier because archived blobs are offline. To read or modify the data, the blob must be rehydrated to an online tier (Hot or Cool). Therefore, rehydration occurs when moving from Archive to Cool (or Hot).
Question 58
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Database administrators
Explanation: Database administrators (DBAs) manage database availability, performance, security, and optimization, ensuring databases run reliably and efficiently.
$19
Get all 282 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.
