070-765 무료 덤프문제 온라인 액세스

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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are tuning the performance of a virtual machines that hosts a Microsoft SQL Server instance.
The virtual machine originally had four CPU cores and now has 32 CPU cores.
The SQL Server instance uses the default settings and has an OLTP database named db1. The largest table in db1 is a key value store table named table1.
Several reports use the PIVOT statement and access more than 100 million rows in table1.
You discover that when the reports run, there are PAGELATCH_IO waits on PFS pages 2:1:1, 2:2:1, 2:3:1, and 2:4:1 within the tempdb database.
You need to prevent the PAGELATCH_IO waits from occurring.
Solution: You add more tempdb databases.
Does this meet the goal?

• A.Yes
• B.No

You plan to create a database in Microsoft Azure to manage sales data for an organization.
You need to create an Azure SQL Database that meets standard naming requirements.
Which names should you use? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.

정답:

You are using dynamic management views to monitor an SQL Server server named SQL1.
A database administrator named Dba1 must monitor the health of SQL1.
You need to ensure that Dba1 can access dynamic management views for SQL1.
The solution must use the principle of least privilege.
Which permissions should you assign to Dba1?

• A.VIEW SERVER STATE
• B.VIEW ANY DEFINITION
• C.CONTROL SERVER
• D.VIEW DEFINITION

You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target virtual machine has four CPUs.
You need to ensure that reports do not use all available system resources.
What should you do?

• A.Set MAXDOP to half the number of CPUs available.
• B.Increase the value for the Minimum System Memory setting.
• C.Increase the value for the Minimum Memory per query setting.
• D.Enable Auto Close.

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.