本番の時間配分に不安がある場合は、70-764の模擬試験形式で解答ペースを確認する練習が役立ちます。Microsoft Administering a SQL Database Infrastructureに対応したFast2testの452問の問題集なら、知識の定着と時間管理をあわせて鍛えられます。

70-764試験対策に選べる3つの学習形式

• PDF版：印刷して持ち運べる形式で、専門家が作成した内容をすぐにダウンロードして確認できます。学習場所を選ばず、365日間の無料更新と無料PDFサンプルに対応しています。
• Desktop Test Engine：インストールして使用するソフトウェアで、実際の試験環境を再現した2つの練習モードを利用できます。オフライン学習に対応し、Windowsで動作します。
• Online Test Engine：ブラウザーからすぐにアクセスでき、学習履歴と成績を確認できます。Windows、Mac、Android、iOSで利用できます。

Fast2testの安心な購入・利用サポート

• McAfeeのセキュリティサービスにより、お客様の情報を安全に取り扱います。
• ご購入後365日間は無料で更新版をご利用いただけます。更新期間の終了後も、50%割引で継続更新が可能です。
• ご入金確認後はすぐにダウンロードでき、通常1分以内にメールでもお届けします。2時間経っても届かない場合は、カスタマーサポートへご連絡ください。
• インストール可能なパソコン台数に制限はありません。

Microsoft Administering a SQL Database Infrastructureの試験情報

Microsoft 70-764 試験概要:

70-764試験の出題範囲

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

Microsoft Administering a SQL Database Infrastructureに関する受験前Q&A

Microsoft Administering a SQL Database Infrastructure 認定 70-764 試験問題：

問題 #1

You have a SQL Server 2014 instance named SQL1. SQL1 creates error events in the Windows Application event log.
You need to recommend a solution that will run an application when SQL1 logs a specific error in the Application log.
Which SQL elements should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)

A. A maintenance plan
B. An alert
C. A job
D. A policy
E. A trigger

問題 #2

You are a database administrator for Contoso, LTD, You configure a Microsoft SQL Server failover with four nodes by using , Windows Server 2012 R2 Datacenter Edition and SOL Server 2016 Enterprise edition.
A server in the datacenter needs to be replaced. The server is part of the SQL Server Failover Instance (FCI).
You need to remove the FCI node for the server that will be replaced.
What should you do?

A. Evict the node from Failover Cluster Manager.
B. Run the Remove-cluster Windows PowterShell cmdlet.
C. Run the Remove-ClusterResource Windows PowerShell cmdlet.
D. Remove the shared storage from Failover Cluster Manager.

問題 #3

You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements:
* Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure.
* Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify? To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)

問題 #4

You administer two Microsoft SQL Server 2012 servers.
Each server resides in a different, untrusted domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?

A. Use a database certificate.
B. Configure the SQL Server service account to use Network Service.
C. Configure the SQL Server service account to use Local System.
D. Use a server certificate.

問題 #5

You work as a Database Administrator (DBA) for a company named ABC.com.
The company uses a Microsoft SQL Server 2012 infrastructure.
A server named ABC-SQL1 hosts multiple databases that are accessed using OLTP (Online Transaction Processing) applications.
You are concerned about the lack of redundancy provided by this single server solution.
You want to configure a solution that ensures high-availability for the databases while minimizing costs.
You need to ensure that the databases remain online in the event of a hardware failure of ABCSQL1.
You configure a second server named ABC-SQL2 and install SQL Server 2012.
Which of the following solutions would provide the high-availability and enable users to run reports on both copies of the databases?

A. Database mirroring
B. A failover cluster
C. AlwaysOn availability groups
D. Transaction log shipping

解説：