DRAG DROP -
Match the processes to the appropriate scenarios.
To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Show Answer
Correct Answer: ETL processing
ELT processing
Data ingestion
Explanation: ETL transforms data before loading. ELT loads data first, then transforms it. Data ingestion is the movement of data from a source to a target without implying transformation.
Question 122
What is used to define a query in a stream processing jobs in Azure Stream Analytics?
A. YAML
B. KQL
C. SQL
D. XML
Show Answer
Correct Answer: C
Explanation: Azure Stream Analytics defines stream processing jobs using a SQL-based query language that is extended with temporal functions and streaming constructs. KQL is used for Azure Data Explorer and related services, not Azure Stream Analytics jobs.
Question 123
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: An elastic pool
Explanation: Azure SQL Database elastic pools allow multiple Azure SQL databases on the same logical server to share a pool of compute and storage resources, making them suitable for varying workloads.
Question 124
What is a primary characteristic of a relational database?
A. a flexible data structure
B. data is queried and manipulated by using a variant of the SQL language
C. a lack of dependencies between tables
D. a large amount of duplicate data
Show Answer
Correct Answer: B
Explanation: A relational database stores data in related tables and is typically queried and manipulated using SQL or a SQL dialect. The other options are incorrect: relational databases have a defined schema rather than a flexible structure, relationships create dependencies via keys rather than a lack of them, and normalization aims to minimize duplicate data.
Question 125
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: WHERE
Explanation: The WHERE clause in DML statements (such as SELECT, UPDATE, and DELETE) specifies the criteria that rows must match.
Question 126
What is a characteristic of a non-relational database?
A. full support for Transact-SQL
B. a fixed schema
C. self-describing entities
Show Answer
Correct Answer: C
Explanation: Non-relational (NoSQL) databases commonly store self-describing entities or documents, allowing flexible, schema-less data models. They do not require a fixed schema, and full support for Transact-SQL is a characteristic of relational SQL databases, not non-relational databases.
Question 127
What should you use to automatically delete blobs from Azure Blob Storage?
A. archive storage
B. the change feed
C. soft delete
D. a lifecycle management policy
Show Answer
Correct Answer: D
Explanation: Azure Blob Storage lifecycle management policies provide rule-based automation to transition blobs between access tiers and automatically delete blobs after specified conditions or retention periods. Archive storage is an access tier, change feed records changes, and soft delete protects against accidental deletion rather than automatically deleting data.
Question 128
In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. a partition key
B. a range
C. a row key
D. a timestamp
Show Answer
Correct Answer: A, C
Explanation: In Azure Table Storage, each entity is uniquely identified by the combination of PartitionKey and RowKey. The PartitionKey groups entities for scalability and querying, while the RowKey uniquely identifies an entity within a partition. Timestamp is a system-maintained property but is not part of the unique identifier, and 'range' is not an Azure Table Storage key component.
Question 129
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: semi-structured data.
Explanation: XML uses tags and a hierarchical structure, so it has organization but is more flexible than relational tables, making it semi-structured rather than fully structured or unstructured.
Question 130
You have a data store that has the structure shown in the following exhibit.
Which type of data store is this?
A. key/value
B. object data
C. graph
D. time series
Show Answer
Correct Answer: C
Explanation: A data store structure that represents entities (nodes) and their relationships (edges) is a graph data store. This distinguishes it from key/value, object, or time-series data stores.
$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.
