DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ15

Monitor, configure, and optimize database resources

You have an Azure subscription containing a storage account named databasebackups.

You have an Azure SQL Managed Instance named DB1.

You need to back up DB1 to databasebackups.

How should you complete the commands?

Select
CREATE CREDENTIAL
[https://databasebackups.blob.core.windows.net/Backups]
WITH IDENTITY =  ,
SECRET = 'sp=r&st=2023-02-02T19:23:08Z&se=2033-02-
02T19:30:08Z&spr=https&sv=2021-06-
08&sr=b&sig=B%2FxEYQiOC%4BqyYCeqwHSz2QpRI%2FKcg3ZABz78J2kix3JZjk%3D'

BACKUP DATABASE DB1

TO URL =

'https://databasebackups.blob.core.windows.net/Backups/db1.bak'

WITH
Explanation

A SQL credential for an Azure Blob Storage SAS uses SHARED ACCESS SIGNATURE as its identity and stores the SAS token as its secret. Azure SQL Managed Instance supports native backups to Azure Blob Storage only as COPY_ONLY full backups, which do not affect the managed instance’s automated backup chain.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!