SELECT, INSERT, and UPDATE are examples of which type of SQL statement?
A. Data Definition Language (DDL)
B. Data Control Language (DCL)
C. Data Manipulation Language (DML)
Show Answer
Correct Answer: C
Explanation: SELECT, INSERT, and UPDATE are generally categorized as Data Manipulation Language (DML) statements. While some sources distinguish SELECT as Data Retrieval Language (DRL), standard SQL references (including Oracle) classify SELECT as a limited form of DML alongside INSERT and UPDATE.
Sources:
https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/Types-of-SQL-Statements.html
Question 32
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: A data analyst
Explanation: A data analyst analyzes data to identify patterns and creates reports and visualizations. Data engineers build data pipelines, and database administrators manage databases.
Question 33
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: semi-structured
Explanation: JSON documents have a defined hierarchical format but can contain varying fields and properties across records, which makes them semi-structured rather than fixed-schema relational/structured or completely unstructured.
Question 34
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 database security and user access. Data analysts analyze and visualize data for insights. Data engineers build and maintain data pipelines for moving and transforming data.
Question 35
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: Data engineer
Database administrator
Data analyst
Explanation: Data engineers build data pipelines, database administrators provision and manage transactional databases, and data analysts create reports and charts from data.
Question 36
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 performs high-volume, real-time transactional operations that require ACID properties and immediate consistency. This is the defining use case for Online Transaction Processing (OLTP). OLAP is for analytical queries, ETL is for moving and transforming data, and a data warehouse is for reporting and analytics rather than operational transactions.
Question 37
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 backup and recovery — Database administrator
Enabling advanced analytic capabilities through reports — Data analyst
Monitoring data pipelines — Data engineer
Explanation: DBAs manage backup/recovery, data analysts create reports and insights, and data engineers build and monitor data pipelines.
Question 38
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 designed to capture and process many small, discrete transactions as they occur, emphasizing real-time recording, consistency, and fast response times. Aggregation, complex reporting, and self-service exploration are characteristic of analytical (OLAP) workloads.
Question 39
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: Atomicity ensures a transaction is treated as an indivisible unit of work: either all operations (the debit and the credit) complete successfully, or none do. This prevents partial updates where one account is debited without the corresponding credit.
Question 40
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 the process of moving a blob from the offline Archive access tier back to an online tier (Hot or Cool) so it can be accessed. Among the options given, only Archive to Cool represents a rehydration operation.
$19
Get all 284 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.
