Examen Azure

QUESTION 21 You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica. You need to initiate a full backup of DB1 on SQL2. Which statement should you run?. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1. You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2. Solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1. Does this meet the goal?. Yes. No.

You have 10 you suspect are related to the connection nes that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?. Automated Backup in the SQL virtual machine settings. Azure Backup. Azure Site Recovery. SQL Server Agent jobs.

You have a Microsoft Azure virtual machine named SQL1 that has Microsoft SQL Server 2016 installed. SQL1 has a critical database that contains online transaction data. The database is 700 GB. You regularly perform full database backups. On a separate Azure virtual machine, you run a test restore procedure of the database and discover that restoring the database takes longer than expected. You need to reduce the amount of time required to restore the database. What should you do?. Modify the backup solution to use differential database backups. Partition the tables in the database, and then modify the backup solution to use incremental backups. Create multiple filegroups in the database, and then modify the backup solution to use filegroup backups. Modify the backup solution to use transaction log backups.

Hotspot Question You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. How should you configure the backup of DB1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Full and log backups only y WITH CHECKSUM. Full backup only y WITH UNLOAD. Full and log backups only y WITH NOINIT. Log backup only y WITH CHECKSUM.

Drag and Drop Question You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Encrypt the Salary column by using the randomized encryption type. Create a column encryption key. Enable Transparent Data Encryption (TDE). Encrypt the Salary column by using the deterministic encryption type. Apply a dynamic data mask to the Salary column. Create a column master key.

Drag and Drop Question You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS. You need to configure storage for the virtual machine to support the database. Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order. a virtual disk that uses the stripe layout. a virtual disk that uses the mirror layout. a volume. a virtual disk that uses the simple layout. a storage pool.

Drag and Drop Question You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change. You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly full backup on Sunday, daily differential backups at 01:00 in the morning, and transaction log backups every five minutes. The database fails on Wednesday at 10:00 in the morning. Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order. Monday, Tuesday, and then Wednesday differential backups. Wednesday, Tuesday, and then Monday log backups. full backup. Monday, Tuesday, and then Wednesday log backups. Monday, Tuesday, and then Monday differential backups. Wednesday log backups. Wednesday differential backup.

Hotspot Question You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1. You need to protect the contents of Column1 at rest, in transit, and in use. How should you protect the contents of Column1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Column encryption key y Deterministic. Column encryption key y Randomized. Database encryption key y Deterministic. Service master key y Transparent Data Encryption (TDE).

You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?. row-level security. data masking. Always Encrypted. column-level security.

You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest. What should you enable?. Transparent Data Encryption (TDE). Advanced Data Security for this database. Always Encrypted for all columns. Secure transfer required.

Your company has an on-premises instance of Microsoft SQL Server. This instance contains a database that has a 5 TiB data file. The database requires 10,000 IOPS. You have to port the database onto Azure. You create a virtual machine. You then allocate two 1 TiB, P30 Premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You have to ensure the storage is configured to support the migrated database. Which of the following would you implement for this requirement? (Choose 3 answers). Create a virtual disk that uses the stripe layout. Create a virtual disk that uses mirror layout. Create a volume. Create a storage pool.

You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1. You run the following query. BACKUP LOG DB1 TO DISK - '\\File1\SQLBackups\DB1.trn' WITH NORECOVERY, COPY_ONLY, CONTINUE_AFTER_ERROR; GO For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. No, No, Yes. No, Yes, No. Yes, Yes, Yes. Yes, No, Yes.

Your on-premises network contains a server that hosts a 60-TB database named DB1. The network has a 10-Mbps internet connection. You need to migrate DB1 to Azure. The solution must minimize how long it takes to migrate the database. What should you use?. Azure Migrate. Azure Data Box. Azure Database Migration Service. Data Migration Assistant (DMA).

You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements: • Encrypt data in motion. • Support comparison operators. • Provide randomized encryption. What should you include in the solution?. Always Encrypted with secure enclaves. Always Encrypted. column-level encryption. Transparent Data Encryption (TDE).

You have an instance of SQL Server on Azure Virtual Machines. You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must use the principle of least privilege. Which role should you assign to User1?. sysadmin. SQLAgentUserRole. SQLAgentReaderRole. SQLAgentOperatorRole.

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and an Azure Active Directory Domain Services (Azure AD DS) domain that contains two users named User1 and User 2. On the default instance of SQL Server on VM1, you create a credential named Credential1 for User1. You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege. Which role should you assign to User2?. SQLAgentUserRole. SQLAgentReaderRole. SQLAgentOperatorRole. sysadmin.

Hotspot Question You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1. You need to ensure that User1 can perform the following tasks on DB1: • Create jobs. • View all jobs. • Modify, delete, and disable the jobs the user created. The solution must use the principle of least privilege. Which built-in database role should you assign to User1, and where is the role defined? To answer, select the appropriate options in the answer area. msbd y SQLAgentUserRole. msbd y SQLAgentOperatorRole. master y SQLAgentUserRole. DB1 y SQLAgentReaderRole.

You plan to deploy an Azure SQL managed instance. You need to restore database backups across regions. Which type of storage account should you use?. locally-redundant storage (LRS). zone-redundant storage (ZRS). geo-zone-redundant storage (GZRS). geo-redundant storage (GRS).