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 questions 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 a 3-TB database. The database server has 64 CPU cores.You plan to migrate the database to Microsoft Azure SQL Database.You need to select the service tier for the Azure SQL database. The solution must meet or exceed the current processing capacity.Solution: You select the Basic service tier.Does this meet the goal?
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 the stated goals.You have a table that has a clustered index and a nonclustered index. The indexes use different columns from the table. You have a query named Query1 that uses the nonclustered index.Users report that Query1 takes a long time to report results. You run Query1 and review the following statistics for an index seek operation:You need to resolve the performance issue.Solution: You drop the nonclustered index.Does the solution meet the goal?
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 the stated goals.You have a table that has a clustered index and a nonclustered index. The indexes use different columns from the table. You have a query named Query1 that uses the nonclustered index.Users report that Query1 takes a long time to report results. You run Query1 and review the following statistics for an index seek operation:You need to resolve the performance issue.Solution: You defragment both indexes.Does the solution meet the goal?
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 the stated goals.You have a table that has a clustered index and a nonclustered index. The indexes use different columns from the table. You have a query named Query1 that uses the nonclustered index.Users report that Query1 takes a long time to report results. You run Query1 and review the following statistics for an index seek operation:You need to resolve the performance issue.Solution: You update statistics for the nonclustered index.Does the solution meet the goal?
You have a reporting application that uses a table named Table1. You deploy a new batch update process to perform updates to Table1.The environment is configured with the following properties:✑ The database is configured with the default isolation setting.✑ The application and process use the default transaction handling.You observe the application cannot access any rows that are in use by the process.You have the following requirements:✑ Ensure the application is not blocked by the process.✑ Ensure the application has a consistent view of the data✑ Ensure the application does not read dirty data.You need to resolve the issue and meet the requirements with the least amount of administrative effort.What should you do?
DRAG DROP -You have two databases with the following settings:You run the following Transact ""SQL statements:You need to select data from DiskTable and insert the data into MemTable. You must complete the insertion operation into MemTable as an explicit transaction without immediate durability.Which four Transact-SQL segments should you use? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.Select and Place:
