70-765最も有効な質問と解答で勉強

Microsoft Provisioning SQL Databasesは業界で広く認知された資格であり、取得はキャリアの信頼性を高める確かな一歩となります。Tech4Examの70-765問題集は268問を収録し、公式の出題範囲に沿って学習を組み立てられます。

Microsoft 70-765 試験概要:

Microsoft 70-765 試験シラバストピック:

70-765試験のQ&A – 受験前に知っておきたいこと

Microsoft Provisioning SQL Databases 認定 70-765 試験問題：

問題 #1

You administer two Microsoft SQL Server 2014 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services.
You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.
The distribution agent on ProdSrv2 regularly fails, displaying the following error message:
"Cannot access the file. Operating system error code 5 (Access is denied.)." You need to configure the distribution agent by granting only the minimum required access to all accounts.
What should you do?

A. Configure the SQL Server Agent service to run under the Local System account. Configure the Subscriber to use the SQL Server Agent service account.
B. Configure the SQL Server Agent service to run under a Windows domain account. Configure the Subscriber to use the SQL Server Agent service account. Grant FULL CONTROL access for the domain account to the ReplData share on ProdSrv1.
C. Configure the Subscriber to use the Local System account.
D. Configure the Subscriber to use a Windows domain account. Grant READ access for the domain account to the ReplData share on ProdSrv1.

問題 #2

You plan to enable Stretch Database for a table named Table1.
You need to configure Table1 to move the data to Microsoft Azure. The data must be moved at a later time.
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.
NOTE: Each correct selection is worth one point.

問題 #3

You are the administrator for a SQL Server 2016 instance that stores the data for an online transaction processing sales system. The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups.
These backups are stored on a backup server in the company's data center.
Every week, the company places the full backup on a tape and sends it to a third-party backup storage system.
The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders.
You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

A. Set up SQL Server Always On with a SQL Azure database as a replica.
B. Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.
C. Put the differential backup on tape and send it to the third-party backup storage system.
D. Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.

問題 #4

You have an on-premises database that runs several maintenance jobs.
You move the database to a Microsoft Azure SQL database.
You need to ensure that the maintenance jobs on indexes continue to run after the move.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

問題 #5

You have Microsoft SQL Server on a DS-series Microsoft Azure virtual machine. The virtual machine has 28 GB of memory.
You discover the following performance statistics on the server:
The average Page life expectancy is 30.
The server has excessive PAGELATCH_IO waits.
You need to decrease the PAGELATCH_IO waits.
What should you do?

A. Configure buffer pool extensions.
B. Enable large-page support.
C. Enable lock pages in memory.
D. Add more tempdb files.

解説：