You have a server named server1-contoso.database.windows.net that has a Microsoft Azure SQL database.
You need to create a group of Azure SQL databases that share the resources on server1-contoso.database.windows.net.
Which cmdlet should you run before you create the database?

• A. New-AzureRmAvailabilitySet
• B. New-AzureRmSqlDatabaseSecondary
• C. New-AzureRmSqlServerCommunicationLink
• D. New-AzureRmSqlServer
• E. New-AzureRmSqlDatabaseCopy
• F. New-AzureRmSqlElasticPool
• G. New-AzureRmLoadBalancer
• H. New-AzureRmVM

You have a database named DB1 that uses simple recovery mode.
Full backups of DB1 are taken daily and DB1 is checked for corruption before each backup.
There was no corruption when the last backup was complete.
You run the sys.columns catalog view and discover corrupt pages.
You need to recover the database. The solution must minimize data loss.
What should you do?

• A. Run DBCC CHECKDB and specify the REPAIT_REBUILD parameter.
• B. Run RESTORE DATABASE WITH RECOVERY.
• C. Run RESTORE DATABASE WITH PAGE.
• D. Run DBCC CHECKDB and specify the REPAIR_ALLOW_DATA_LOSS parameter.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.
You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application runs several financial reports. The reports use a SQL Server-authenticated login named Reporting_User. All queries that write data to the database use Windows authentication.
Users report that the queries used to provide data for the financial reports take a long time to complete. The queries consume the majority of CPU and memory resources on the database server. As a result, read-write queries for the application also take a long time to complete.
You need to improve performance of the application while still allowing the report queries to finish.
Solution: You configure the Resource Governor to limit the amount of memory, CPU, and IOPS used for the pool of all queries that the Reporting_user login can run concurrently.
Does the solution meet the goal?

• A. Yes
• B. No

You have a fact table named FactSales that is 100 GB. FactSales is in a data warehouse that is partitioned by month.
You discover that queries perform index scan operations when the queries should perform index seek operations.
You need to optimize the query plan to reduce the number of scans.
How should you complete the statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

You have an on-premises SQL Server database named DB1 that contains a table named TB1. TB1 is stretched to Microsoft Azure.
A catastrophic hardware failure occurs on the on-premises SQL server.
You deploy a new on-premises server and restore all databases to the new server.
You need to resume Stretch Database operations to Azure.
Which statements should you execute?

• A. Option A
• B. Option D
• C. Option C
• D. Option B