Which dynamic management object should you use?

Correct Answer for the Question – Which dynamic management object should you use? is given below You have a database named Saleshistory that records sales transactions for your organization. You create indexes in the database.The database has grown over time and now contains hundreds of indexes.You need to identify the indexes that are not being used.Which … Read more

What is the maximum CPU and memory value you can assign to this resource pool?

Correct Answer for the Question – What is the maximum CPU and memory value you can assign to this resource pool? is given below You have configured Resource Governor with three resource pools.You have assigned the first resource pool a minimum CPU and memory value of 20%.You have assigned the second resource pool a minimum CPU … Read more

Which storage option should you use?

Correct Answer for the Question – Which storage option should you use? is given below You plan to implement a fault tolerance solution for a Microsoft SQL Server database.The solution must provide failover storage on the local network.You need to ensure the solution can route traffic to failover storage by using SMB 3.0.Which storage option should … Read more

What should you specify when you run the recovery command?

Correct Answer for the Question – What should you specify when you run the recovery command? is given below A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a backup strategy that creates backups for the filegroups.DB1 experiences a failure. You must restore FG1 and then FG2.You need to … Read more