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 queries using a SQL-based query language. It extends standard SQL with temporal and streaming constructs to analyze data in motion. KQL is used with Azure Data Explorer, while YAML and XML are not used to define Stream Analytics queries.
Question 140
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 databases on the same server to share allocated resources such as CPU, memory, and storage, optimizing cost and performance for variable workloads.
Question 141
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 is fundamentally defined by the relational model and is typically accessed using a declarative query language based on SQL. While SQL itself is not the theoretical foundation, in practice all relational database management systems provide SQL or a close variant as the standard way to query and manipulate data. The other options are incorrect: relational databases are not defined by flexible schemas (A), they explicitly model dependencies via relations and keys (C), and they aim to minimize—not encourage—duplicate data through normalization (D).
Question 142
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: WHERE
Explanation: In DML statements (SELECT, UPDATE, DELETE), the WHERE clause defines the criteria that rows must meet.
Question 143
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 typically do not enforce a fixed schema. Instead, data entities are often self-describing, meaning each record can store its own structure and attributes. This flexibility distinguishes them from relational databases, which rely on fixed schemas and SQL-based querying.
Question 144
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 are designed to automatically manage blobs over time. They can delete (expire) blobs based on rules such as age or last modified date. Archive storage only changes access tier, the change feed tracks changes, and soft delete allows recovery after deletion but does not automatically delete blobs.
Question 145
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 (row) is uniquely identified by the combination of the PartitionKey and the RowKey. The PartitionKey groups related entities for scalability and query efficiency, while the RowKey uniquely identifies an entity within that partition. The Timestamp is a system property used for concurrency and tracking changes, not for uniqueness.
Question 146
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: semi-structured data.
Explanation: XML files have a defined, hierarchical structure using tags, but they do not require a fixed relational schema, which classifies them as semi-structured data.
Question 147
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: The exhibit describes entities connected by relationships, which is characteristic of a graph data store. Graph data models focus on nodes and edges rather than simple key/value pairs, objects, or time-ordered measurements.
Question 148
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: No
No
Yes
Explanation: Normalization prioritizes data integrity over write throughput and can add overhead due to foreign keys and multiple table writes. Analytics systems are typically denormalized for read performance, while transactional systems are more normalized. Normalization splits data across tables, which increases the number of joins required in queries.
$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.
