Azure Storage & Data Solutions Flashcards

Which Azure service provides a fully managed relational database with built-in high availability for SQL Server workloads?

Answer: Azure SQL Database

Azure SQL Database is a fully managed PaaS relational database built on SQL Server with built-in high availability, backups, and patching.

What connection string format is required to connect to Azure Cosmos DB using the SQL (Core) API from a .NET application?

Answer: AccountEndpoint=https://accountName.documents.azure.com:443/;AccountKey=key;

The Cosmos DB SDK for .NET requires an `AccountEndpoint` URI and `AccountKey` (or token) to initialize the CosmosClient.

Which Azure Blob Storage redundancy option replicates data synchronously across three availability zones in the primary region?

Answer: ZRS (Zone-Redundant Storage)

ZRS replicates data synchronously across three Azure availability zones within the same region, protecting against zone-level failures.

In Azure Cosmos DB, what is the unit used to measure provisioned throughput?

Answer: Request Units (RUs)

Cosmos DB uses Request Units per second (RU/s) to represent the throughput provisioned for a database or container.

Which Azure Storage feature allows you to grant time-limited, scoped access to a blob without exposing the account key?

Answer: Shared Access Signature (SAS)

A Shared Access Signature (SAS) generates a URI with embedded credentials and permissions valid for a specific duration without exposing the account key.

What Azure SQL Database feature automatically tunes query performance by applying and reverting index recommendations?

Answer: Automatic Tuning

Azure SQL Database Automatic Tuning monitors query performance and automatically creates, validates, and drops indexes to improve performance.