70-764 関連資格知識、070-764 日本語版参考書
NO.1 You have a server named Server1 that has 16 processors.
You plan to deploy multiple instances of SQL Server 2016 to Server1.
You need to recommend a method to allocate processors to each instance.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Windows System Resource Manager (WSRM)
B. Resource Governor
C. Processor affinity
D. Max Degree of Parallelism
Answer: C
Explanation:
CPU affinity management through Windows System Resource Manager is not
recommended for SQL Server multi-instance management. Instead, use the processor affinity settings
in SQL Server.
Reference: Server Properties (Processors Page)
NO.2 You have two databases named DB1 and DB2 that are located on the same server.
You plan to create a stored procedure named SProc1 in DB1.
SProc1 will query a table named Table2 in DB2.
You need to recommend a solution to ensure that SProc1 can access Table2 without granting users
direct access to Table2.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Contained databases
B. Digital certificates
C. Cross-database ownership chaining
D. Application roles
Answer: D
070-764 オンライン
Explanation:
An application role is a database principal that enables an application to run with its own, user-like
permissions. You can use application roles to enable access to specific data to only those users who
connect through a particular application. Unlike database roles, application roles contain no
members and are inactive by default.
Reference: Application Roles
NO.3 You are creating a database that will store usernames and passwords for an application.
You need to recommend a solution to store the passwords in the database.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Reversible encryption
B. One-way encryption
C. Encrypting File System (EFS)
D. Transparent Data Encryption (TDE)
Answer: D
070-764 試験番号
Explanation:
* Transparent Data Encryption (TDE) is a special case of encryption using a symmetric key. TDE
encrypts an entire database using that symmetric key called the database encryption key. The
database encryption key is protected by other keys or certificates which are protected either by the
database master key or by an asymmetric key stored in an EKM module.
* SQL Server provides the following mechanisms for encryption:
Transact-SQL functions
Asymmetric keys
Symmetric keys
Certificates
Transparent Data Encryption
Reference: Transparent Data Encryption (TDE)
NO.4 Note: This question is part of a series of questions that use the same or similar answer choices.
An answer choice may be correct for more than one question in the series.
Each question is independent of the other questions in this series.
Information and details provided in a question apply only to that question.
You are the database administrator for a company that hosts Microsoft SQL Server.
You manage both on-premises and Microsoft Azure SQL Database environments.
One instance hosts a user database named HRDB. The database contains sensitive human resources
data.
You need to grant an auditor permission to view the SQL Server audit logs while following the
principle of least privilege.
Which permission should you grant?
A. dbo
B. dbcreator
C. DDLAdmin
D. View Server State
E. db_datawriter
F. View Database State
G. sysadmin
H. View Definition
Answer: D
070-764 体験談
Explanation:
Unless otherwise specified, viewing catalog views requires a principal to have one of the following:
References: https://technet.microsoft.com/en-us/library/cc280386(v=sql.110).aspx
Microsoftの70-764 関連資格知識試験に参加するのは大ブレークになる一方が、70-764 関連資格知識試験情報は雑多などの問題が注目している。たくさんの品質高く問題集を取り除き、我々Pass4Testの70-764 関連資格知識問題集を選らんでくださいませんか。我々の70-764 関連資格知識問題集はあなたに質高いかつ完備の情報を提供し、成功へ近道のショットカットになります。
弊社は一年の更新サービスを提供します。お客様は我々のサイトで070-764 日本語版参考書問題集をご購入になってから、そのあとの一年間、我々は無料の更新サービスを提供します。もしその一年の中で、070-764 日本語版参考書問題集が更新されたら、我々はお客様に最新版をお送りいたします。すなわち、その一年間、お客様の持っている070-764 日本語版参考書問題集はずっと最新のです。
君はまずネットで無料なMicrosoftの70-764 関連資格知識試験問題をダウンロードしてから 弊社の品質を確信してから、購入してください。Pass4Testは提供した商品は君の成功を全力で助けさしたげます。
試験番号：70-764試験科目：「Administering a SQL Database Infrastructure」
一年間無料で問題集をアップデートするサービスを提供いたします
最近更新時間：2017-07-30
問題と解答：全120問 70-764 関連資格知識
試験番号：070-764試験科目：「Administering a SQL Database Infrastructure」
一年間無料で問題集をアップデートするサービスを提供いたします
最近更新時間：2017-07-30
問題と解答：全120問 070-764 日本語版参考書
購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.pass4test.jp/070-764.html
IT業界の中でたくさんの野心的な専門家がいって、IT業界の中でより一層頂上まで一歩更に近く立ちたくてMicrosoftの070-764 日本語版参考書試験に参加して認可を得たくて、Microsoft の070-764 日本語版参考書試験が難度の高いので合格率も比較的低いです。Microsoftの070-764 日本語版参考書試験を申し込むのは賢明な選択で今のは競争の激しいIT業界では、絶えず自分を高めるべきです。しかし多くの選択肢があるので君はきっと悩んでいましょう。
