Which Windows PowerShell command or commands should you run?

You plan to integrate an on-premises Microsoft SQL Server environment with Microsoft Azure.

You need to create the authentication object so that you can connect to Azure.

Which Windows PowerShell command or commands should you run?
A . Invoke-Sqlcmd “CREATE EXTERNAL DATA SOURCE MyAzureStorage WITH (LOCATION = ‘wasbs://[email protected]/”, CREDENTIAL = Pa$$w0rd)”
B . New-SqlAzureKeyVaultColumnMasterKeySettings­KeyUrlhttps://myvault.vault.contoso.net:443/keys/CMK/4c05fla41b12488f9cba2ea964b6a700
C . Invoke-Sqlcmd “CREATE CREDENTIAL AzureCred WITH IDENTITY = ‘AzureKey’, SECRET = ‘Pa$$w0rd”
D . Invoke-Sqlcmd “CREATE LOGIN AzureCred WITH CREDENTIAL = ‘AzureKey’, PASSWORD = ‘Pa$$w0rd”

View Answer

Answer: C

Explanation:

Invoke-Sqlcmd runs a script containing statements supported by the SQL Server SQLCMD utility.

The following example creates a SQL Server credential for the Database Engine to use when accessing the Azure Key Vault using the SQL Server Connector for Microsoft Azure Key Vault.

CREATE CREDENTIAL Azure_EKM_TDE_cred

WITH IDENTITY = ‘ContosoKeyVault’,

SECRET = ‘EF5C8E094D2A4A769998D93440D8115DSECRET_DBEngine’

FOR CRYPTOGRAPHIC PROVIDER AzureKeyVault_EKM_Prov ;

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-credential-transact-sql