70-764 受験準備 & Administering A SQL Database Infrastructure

NO.1 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 manage a Microsoft SQL Server environment. You implement Transparent Data
Encryption (TDE).
A user will assist in managing TDE.
You need to ensure that the user can view the TDE metadata while following the principle of lease
privilege.
Which permission should you grant?
A. db_datawriter
B. View Definition
C. View Server State
D. dbcreator
E. sysadmin
F. dbo
G. View Database State
H. DDLAdmin
Answer: B
Explanation:
Viewing the metadata involved with TDE requires the VIEW DEFINITION permissionon the certificate.
References: https://docs.microsoft.com/en-us/sql/relational-
databases/security/encryption/transparent-data-encryption-tde

NO.2 Note: This question is part of a series of questions that use the same scenario. For your
convenience, the scenario is repeated in each question. Each question presents a different goal and
answer choices, but the text of the scenario is exactly the same in each question in this series.
You are a database administrator for a company that has an on-premises Microsoft SQL
Server environment and Microsoft Azure SQL Database instances. The environment hosts several
customer databases, and each customer uses a dedicated instance. The environments that you
manage are shown in the following table.
You need to monitor WingDB and gather information for troubleshooting issues.
What should you use?
A. sp_lock
B. sys.dm_os_waiting_tasks
C. sp_updatestats
D. sys.dm_tran_active_snapshot_database_transactions
Answer: A

70-764 変更   70-764 過去問   
Explanation:
The sp_lock system stored procedure is packaged with SQL Server and will give you insight into the
locks that are happening on your system. This procedure returns much of its information from the
syslock info in the master database, which is a system table that contains information on all granted,
converting, and waiting lock requests.
Note: sp_lock will be removed in a future version of Microsoft SQL Server. Avoid using this feature in
new development work, and plan to modify applications that currently use this feature. To obtain
information about locks in the SQL Server Database Engine, use the sys.dm_tran_locks dynamic
management view.
sys.dm_tran_locks returns information about currently active lock manager resources in
SQL Server 2008and later. Each row represents a currently active request to the lock manager for a
lock that has been granted or is waiting to be granted.
References:https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-
procedures/sp-lock-transact-sql

NO.3 You have two SQL Server 2016 instances named SQLDev and SQLProd.
You plan to create a new database on SQLProd that will use SQL Server Authentication.
You need to ensure that when the new database is copied from SQLProd to SQLDev, users can
connect to the database on SQLDev even if they do not have a login on the
SQLDev instance.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
A. SQL Server Integration Services (SSIS) scripts
B. Contained database
C. Triggers
D. Extended Events
E. SQL Server Analysis Services (SSAS) scripts
Answer: B

70-764 ミシュレーション   
Explanation:
A fully contained database includes all the settings and metadata required to define the database and
has no configuration dependencies on the instance of the SQL Server
Database Engine where the database is installed.
Reference: Contained Databases

NO.4 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. Digital certificates
B. Application roles
C. Contained databases
D. Cross-database ownership chaining
Answer: B

70-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

ShikenPASSの Microsoft70-764 受験準備試験トレーニング資料を手に入れるなら、あなたは最も新しいMicrosoftの70-764 受験準備学習教材を手に入れられます。ShikenPASSの 学習教材の高い正確性は君がMicrosoft70-764 受験準備認定試験に合格するのを保証します。もしうちの学習教材を購入した後、商品は問題があれば、或いは試験に不合格になる場合は、私たちが全額返金することを保証いたします。

現在の社会の中で優秀なIT人材が揃て、競争も自ずからとても大きくなって、だから多くの方はITに関する試験に参加してIT業界での地位のために奮闘しています。70-764 受験準備Microsoftの一つ重要な認証試験で多くのIT専門スタッフが認証される重要な試験です。

70-764試験番号:70-764
試験科目:「Administering a SQL Database Infrastructure」
一年間無料で問題集をアップデートするサービスを提供いたします
最近更新時間:2017-10-18
問題と解答:全120問 70-764 合格資料

>> 70-764 合格資料

 

IT 職員のそれぞれは昇進または高給のために頑張っています。これも現代社会が圧力に満ちている一つの反映です。そのためにMicrosoftの70-764 受験準備認定試験に受かる必要があります。適当なトレーニング資料を選んだらこの試験はそんなに難しくなくなります。ShikenPASSのMicrosoftの70-764 受験準備「Administering a SQL Database Infrastructure」試験トレーニング資料は最高のトレーニング資料で、あなたの全てのニーズを満たすことができますから、速く行動しましょう。

ShikenPASSは最新のE_HANABW_12試験問題集と高品質の1z0-961認定試験の問題と回答を提供します。ShikenPASSの9A0-389 VCEテストエンジンと200-155試験ガイドはあなたが一回で試験に合格するのを助けることができます。高品質の200-310トレーニング教材は、あなたがより迅速かつ簡単に試験に合格することを100%保証します。試験に合格して認証資格を取るのはそのような簡単なことです。

記事のリンク:http://www.shikenpass.com/70-764-shiken.html