なぜ70-764問題集を使用しますか
70-764問題集を使用し、試験準備は十分で、試験はよく自信をもっています。
受験準備の一番いい方法は教科書を復習しないで、実際の試験問題を練習します。
出題範囲をすばやく理解し、65％の試験準備時間を節約します。
何度も実際の問題を練習し、自分の弱みところを理解し克服する
いつ始まる70-764問題集を使用しますか?
70-764問題集は資格の認定の完全なプロセスに同行します
学習期間から試験準備まで、いつでもどこでも70-764問題集を使用することができます。
学習期間に70-764問題集を使用し、試験に合格することを目指す学習計画を作成します。
試験準備する時、70-764試験の実際問題と解答を読書し、気楽に試験に合格することができます。
どのように70-764問題集を選択しますか。
他のウェブサイトとは異なり、ITshikenは70-764試験の100%真実の模擬練習を提供し、試験準備のための最初の選択になります。
70-764試験情報
配信開始: 2016年10月18日
言語: 英語
対象者:IT プロフェッショナル
テクノロジ: SQL Server 2016/2017/2019
対応資格: MCP、MCSA
70-764出題範囲と出題比率
データ アクセスと監査の構成 (20 ～ 25%)
データベースのバックアップと復元の管理 (20 ～ 25%)
SQL Server インスタンスの管理と監視 (35 ～ 40%)
High Availability and Disaster Recovery の管理 (20 ～ 25%)
70-764受験対象者
この試験は、インストール タスク、メンテナンス タスク、および構成タスクを実行するデータベース プロフェッショナルを対象としています。その他の業務として、データベース システムのセットアップ、それらのシステムが効率的に動作するかどうかの確認、定期的な保存やバックアップ、許可されていないデータ アクセスからのセキュリティ保護などが挙げられます。
70-764問題集とは
70-764はAdministering a SQL Database Infrastructure試験問題と解答を集合されています。
Question No : 1
You need to recommend a solution to allow application users to perform UPDATE operations on the database tables. The solution must meet the business requirements.
What should you recommend?
A.Create a user-defined database role and add users to the role.
B.Create stored procedures that use EXECUTE AS clauses.
C.Create a Policy-Based Management Policy.
D.Create functions that use EXECUTE AS clauses.
正解: B
Question No :2
You have an SQL Server 2016 server named SQL1.
You are designing a performance monitoring solution.
You need to monitor the following events on SQL1:
・ A deadlock graph
・ Missing column statistics
・ CPU performance statistics
・ A batch of completed Transact-SQL statements
Which two tools should you use? Each correct answer presents a complete solution.
A.dynamic management views
B.Database Engine Tuning Advisor
C.SQL Server Profiler
D.Activity Monitor
E.Data Profile Viewer
正解: ABC
Question No : 3
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 ANY DEFINITION
B.VIEW SERVER STATE
C.VIEW DEFINITION
D.CONTROL SERVER
正解: B
Question No : 4
You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2016 to Server1. Each instance will have multiple databases.
You need to recommend a method to set limits on processor time for each database.
What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
A.processor affinity
B.Max Degree of Parallelism
C.Windows System Resource Manager (WSRM)
D.Resource Governor
正解: D
Question No : 5
You have a customer who has several SQL Server 2012 database servers.
You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes.
The customer identifies that the following must be supported for the column store indexes.
・ Data manipulation language (DML) statements
・ Nonclustered columnstore indexes
・ Clustered columnstore indexes
・ Partitioning
You need to identify which technology requires the customer to implement an SQL Server 2016 database.
What should you identify?
A.clustered columnstore indexes
B.nonclustered columnstore indexes
C.data manipulation language (DML) statements
D.partitioning
正解: A
Question No : 6
You have a SQL Server 2016 environment that contains 20 servers. The corporate security policy states that all SQL Server 2016 instances must meet specific security standards. You need to recommend a management strategy for the SQL Server 2016 servers.
What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
A.Multi server jobs
B.Policy-Based Management
C.Common criteria compliance
D.Maintenance plans
正解: B
Question No : 7
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.Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
C.Put the differential backup on tape and send it to the third-party backup storage system.
D.Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.
正解: D
Question No : 8
You deploy a database by using SQL Server 2016. The database contains a table named Table1.
You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.
What should you recommend?
A.Change data capture
B.Statistics
C.A trigger
D.Master Data Services
正解: A
70-764問題集を使用し、試験準備は十分で、試験はよく自信をもっています。
受験準備の一番いい方法は教科書を復習しないで、実際の試験問題を練習します。
出題範囲をすばやく理解し、65％の試験準備時間を節約します。
何度も実際の問題を練習し、自分の弱みところを理解し克服する
いつ始まる70-764問題集を使用しますか?
70-764問題集は資格の認定の完全なプロセスに同行します
学習期間から試験準備まで、いつでもどこでも70-764問題集を使用することができます。
学習期間に70-764問題集を使用し、試験に合格することを目指す学習計画を作成します。
試験準備する時、70-764試験の実際問題と解答を読書し、気楽に試験に合格することができます。
どのように70-764問題集を選択しますか。
他のウェブサイトとは異なり、ITshikenは70-764試験の100%真実の模擬練習を提供し、試験準備のための最初の選択になります。
70-764試験情報
配信開始: 2016年10月18日
言語: 英語
対象者:IT プロフェッショナル
テクノロジ: SQL Server 2016/2017/2019
対応資格: MCP、MCSA
70-764出題範囲と出題比率
データ アクセスと監査の構成 (20 ～ 25%)
データベースのバックアップと復元の管理 (20 ～ 25%)
SQL Server インスタンスの管理と監視 (35 ～ 40%)
High Availability and Disaster Recovery の管理 (20 ～ 25%)
70-764受験対象者
この試験は、インストール タスク、メンテナンス タスク、および構成タスクを実行するデータベース プロフェッショナルを対象としています。その他の業務として、データベース システムのセットアップ、それらのシステムが効率的に動作するかどうかの確認、定期的な保存やバックアップ、許可されていないデータ アクセスからのセキュリティ保護などが挙げられます。
70-764問題集とは
70-764はAdministering a SQL Database Infrastructure試験問題と解答を集合されています。
Question No : 1
You need to recommend a solution to allow application users to perform UPDATE operations on the database tables. The solution must meet the business requirements.
What should you recommend?
A.Create a user-defined database role and add users to the role.
B.Create stored procedures that use EXECUTE AS clauses.
C.Create a Policy-Based Management Policy.
D.Create functions that use EXECUTE AS clauses.
正解: B
Question No :2
You have an SQL Server 2016 server named SQL1.
You are designing a performance monitoring solution.
You need to monitor the following events on SQL1:
・ A deadlock graph
・ Missing column statistics
・ CPU performance statistics
・ A batch of completed Transact-SQL statements
Which two tools should you use? Each correct answer presents a complete solution.
A.dynamic management views
B.Database Engine Tuning Advisor
C.SQL Server Profiler
D.Activity Monitor
E.Data Profile Viewer
正解: ABC
Question No : 3
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 ANY DEFINITION
B.VIEW SERVER STATE
C.VIEW DEFINITION
D.CONTROL SERVER
正解: B
Question No : 4
You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2016 to Server1. Each instance will have multiple databases.
You need to recommend a method to set limits on processor time for each database.
What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
A.processor affinity
B.Max Degree of Parallelism
C.Windows System Resource Manager (WSRM)
D.Resource Governor
正解: D
Question No : 5
You have a customer who has several SQL Server 2012 database servers.
You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes.
The customer identifies that the following must be supported for the column store indexes.
・ Data manipulation language (DML) statements
・ Nonclustered columnstore indexes
・ Clustered columnstore indexes
・ Partitioning
You need to identify which technology requires the customer to implement an SQL Server 2016 database.
What should you identify?
A.clustered columnstore indexes
B.nonclustered columnstore indexes
C.data manipulation language (DML) statements
D.partitioning
正解: A
Question No : 6
You have a SQL Server 2016 environment that contains 20 servers. The corporate security policy states that all SQL Server 2016 instances must meet specific security standards. You need to recommend a management strategy for the SQL Server 2016 servers.
What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
A.Multi server jobs
B.Policy-Based Management
C.Common criteria compliance
D.Maintenance plans
正解: B
Question No : 7
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.Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
C.Put the differential backup on tape and send it to the third-party backup storage system.
D.Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.
正解: D
Question No : 8
You deploy a database by using SQL Server 2016. The database contains a table named Table1.
You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.
What should you recommend?
A.Change data capture
B.Statistics
C.A trigger
D.Master Data Services
正解: A