Correct Answer: D

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure

Correct Answer: C

There are resource types related to application code, compute infrastructure, networking, storage + databases.

You can deploy up to 800 instances of a resource type in each resource group.

Some resources can exist outside of a resource group. These resources are deployed to the subscription, management group, or tenant. Only specific resource types are supported at these scopes.

Reference:

https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/resource-providers-and- types

Correct Answer: B

This table lists the key features for PolyBase and the products in which they're available.

Incorrect Answers:

C: Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications. It applies to both Azure SQL Database and SQL Server.

D: Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak performance and stable workloads through continuous performance tuning based on AI and machine learning.

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary

Correct Answer: C

Active geo-replication is a feature that lets you to create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary databases are also known as geo-secondaries, or geo-replicas.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

Correct Answer: ABC

Reference: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits

Correct Answer: A

Explanation:

By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different

availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). The routing to a specific gateway ring is controlled by Azure Traffic Manager

(ATM). Because the zone redundant configuration in the Premium or Business Critical service tiers does not create additional database redundancy, you can enable it at no extra cost. By selecting a zone redundant configuration, you can

make your Premium or Business Critical databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic. You can also convert any existing Premium or Business

Critical databases or pools to the zone redundant configuration.

Incorrect Answers:

Note:

There are several versions of this question with different incorrect answer options. Other incorrect answers you may see on the exam include:

Azure SQL Database Hyperscale

Azure SQL Database Basic

Azure SQL Database managed instance General Purpose

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

Correct Answer:

Box 1: CSV files that have file named beginning with "tripdata_2020"

Box 2: a header

FIRSTROW = 'first_row'

Specifies the number of the first row to load. The default is 1 and indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.

Reference:

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset

Correct Answer:

Box 1: -AssignIdentity

The New-AzSqlServer cmdlet creates an Azure SQL Database server.

Parameter -AssignIdentity

Generate and assign an Azure Active Directory Identity for this server for use with key management services like Azure KeyVault.

Box 2: KeyId

Parameter -KeyId

The Azure Key Vault URI that is used for encryption.

Example: Create a new Azure SQL Database server with TDE CMK

New-AzSqlServer -ResourceGroupName "ResourceGroup01" -Location "East US" -ServerName "server01" -ServerVersion "12.0" -SqlAdministratorCredentials (Get-Credential) -AssignIdentity -IdentityType "UserAssigned" -

PrimaryUserAssignedIdentityId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.ManagedIdentity/userAssignedIdentities/identity01" -UserAssignedIdentityId "/subscriptions/

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.ManagedIdentity/userAssignedIdentities/identity01" -KeyId https://contoso.vault.azure.net/keys/contosokey/01234567890123456789012345678901

Reference:

https://learn.microsoft.com/en-us/powershell/module/az.sql/New-AzSqlServe

Correct Answer:

Box 1: Yes

DBAGroup1 is member of the Contributor role.

The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.

Box 2: No

Box 3: Yes

DBAGroup2 is member of the SQL DB Contributor role.

The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers. As a member of this role you can create and manage SQL databases.

Reference:

https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles

Correct Answer: