DP-300: Administering Microsoft Azure SQL Solutions

You have an Azure subscription containing an Azure SQL database. The database includes a table named tablet that uses partitioned columnstores.

You need to configure table1 to meet these requirements:

• Every partition must be compressed.
• The compression ratio must be maximized.
• You must be able to index the compressed data.

What should you use?

You have an Azure subscription.

You need to deploy an Azure SQL resource that supports cross-database queries by using an Azure Resource Manager (ARM) template. How should you complete the ARM template?

"resources": [
  ...
  "type": "Select…",
  "name": "[parameters('targetName')]",
  "location": "[parameters('location')]",
  "sku": {
    "name": "[parameters('skuName')]"
  },
  ...
  "dependsOn": [
    "Select…"
  ],
  "properties": {
    "administratorLogin": "[parameters('administratorLogin')]",
    "administratorLoginPassword": "[parameters('administratorLoginPassword')]",
    "subnetId": "[resourceId('Microsoft.Network/virtualNetworks/subnets', parameters('virtualNetworkName'),
      parameters('virtualNetworkName'), parameters('subnetName'))]",
    "storageSizeInGB": "[parameters('storageSizeInGB')]", "vCores": "[parameters('vCores')]",
    "licenseType": "[parameters('licenseType')]"
  }
  ...
]

You have an Azure subscription that includes an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1.

You need to collect performance metrics for SQLMI1 and stream those metrics to Workspace.

What should you do first?

You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. DF1 includes a linked service.

You have an Azure Key Vault named vault1 that contains an encryption key named key1.

You need to encrypt df1 by using key1.

What should you do first?

You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed using an Azure Marketplace SQL Server 2019 Enterprise image.

You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must maintain licensing compliance.

What should you do first?