QUESTION: 105

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

SELECT
WHERE
JOIN

Answer(s): B

Reveal Solution Next Question

QUESTION: 106

HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Azure Synapse Analytics is an platform as a service (PAAS) that combines data integration, warehousing, and analytics into one solution.
Azure Synapse Analytics offers cloud-based, relational data warehousing services, massively parallel processing (MPP) scale-out technology, and enough computational power to efficiently manage petabytes and petabytes of data.
Incorrect:
* Azure Database for MariaDB is a relational database service based on the open-source MariaDB Server engine. It's a fully managed database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability.
* Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.

Reference:

https://cswsolutions.com/blog/posts/2021/august/what-is-azure-synapse-analytics/ https://www.integrate.io/blog/what-is-azure-synapse-analytics/

Reveal Solution Next Question

QUESTION: 107

HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column.A