Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
A. SELECT
B. WHERE
C. JOIN
Show Answer
Correct Answer: A
Explanation: Among the provided options, only SELECT is a T-SQL statement. In SQL Server, forcing index usage is done via an index hint (for example, WITH (INDEX(index_name))) as part of a SELECT query. WHERE is a clause that may enable the optimizer to choose an index, but it does not itself instruct the DBMS to use one. JOIN is unrelated to forcing index usage.
Sources:
https://learn.microsoft.com/en-us/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-performance-issues?view=sql-server-ver17
Question 112
DRAG DROP -
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match its worth one point.
Select and Place:
Show Answer
Correct Answer: A serverless configuration → Azure SQL Database single database
A database that has the highest compatibility with on-premises Microsoft SQL Server → Azure SQL Managed Instance
A low-cost, low-maintenance database → Azure SQL Database elastic pool
Explanation: Serverless compute is available for Azure SQL Database single databases. Azure SQL Managed Instance provides the closest SQL Server compatibility. Elastic pools are designed to reduce cost by sharing resources across multiple databases with varying demand.
Question 113
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT
Show Answer
Correct Answer: C
Explanation: INSERT is a Data Manipulation Language (DML) statement used to add new rows to a database table. GRANT and REVOKE are Data Control Language (DCL) commands for managing privileges, while DISABLE is an administrative command rather than a DML statement.
Question 114
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: the same set of columns
Explanation: In a relational table, all rows follow the same schema: each row has values for the same defined columns, although the values may differ.
Question 115
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. atomicity
B. isolation
C. durability
D. consistency
Show Answer
Correct Answer: A
Explanation: Atomicity is the ACID property that guarantees a transaction is an indivisible unit of work: either all of its operations are committed successfully or, if any part fails, the entire transaction is rolled back. Isolation concerns concurrent execution, consistency ensures valid state transitions, and durability ensures committed changes persist.
Question 116
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: simple lookups
Explanation: Key/value data stores are optimized for fast retrieval by key, not relational joins or enforcing complex constraints.
Question 117
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Show Answer
Correct Answer: latency in delivering data processing results is acceptable.
Explanation: Batch processing handles data in scheduled groups rather than immediately, so some processing latency is expected and acceptable.
Question 118
What is required to provision Azure Data Lake Storage in an Azure Storage account?
A. Versioning must be disabled.
B. Hierarchical namespace must be disabled.
C. Versioning must be enabled.
D. Hierarchical namespace must be enabled.
Show Answer
Correct Answer: D
Explanation: Azure Data Lake Storage Gen2 is enabled on an Azure Storage account by turning on the hierarchical namespace feature. This is the required setting for Data Lake Storage capabilities. Blob versioning is not a prerequisite for provisioning Azure Data Lake Storage.
Question 119
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: relational data.
Explanation: Microsoft SQL Server database tables are relational structures that store data in rows and columns. Semi-structured data can be stored in SQL Server (e.g., JSON/XML), but standard database tables are relational.
Question 120
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: An instance of SQL Server on Azure Virtual Machines
Explanation: A lift-and-shift migration with minimal or no application changes is best supported by SQL Server running on Azure Virtual Machines because it preserves the SQL Server environment and provides full instance and OS control.
$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.
