2018 Latest 70-764 Exam Dumps, Valid 70-764 Exam Braindumps, Accurate 70-764 Study Guide, 70-764 Exam Q&A, 70-764 Learning Materials, 70-764 Practice Questions

 

Valid 70-764 Dumps shared by freecram for Helping Passing 70-764 Exam! freecram now offer the newest 70-764 exam dumps, the freecram 70-764 exam questions have been updated and answers have been corrected get the newest freecram 70-764 dumps with Test Engine here:  http://www.freecram.com/Home/Search?q=70-764 (120 Q&As Dumps, 30%OFF Special Discount: 30free )

 

NEW QUESTION: 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 functions that use EXECUTE AS clauses.
D. Create a Policy-Based Management Policy.
Answer: B

NEW QUESTION: 2
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. Resource Governor
B. Processor affinity
C. Max Degree of Parallelism
D. Windows System Resource Manager (WSRM)
Answer: B
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)

NEW QUESTION: 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. Contained database
B. Extended Events
C. Triggers
D. SQL Server Analysis Services (SSAS) scripts
E. SQL Server Integration Services (SSIS) scripts
Answer: A
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

NEW QUESTION: 4
You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Azure.
Which method should you recommend? More than one answer choice may achieve the goal. Select
the BEST answer.
A. Generate scripts to create all of the all database objects and all of the data, and then execute the
scripts by using SQL Azure.
B. Back up the database, and then restore the database.
C. Create a SQL Server Integration Services (SSIS) package, and then run the package.
D. Extract a data-tier application, and then import the application.
Answer: C
Explanation:
SQL Server Integration Services
Most flexibility
Data Transfer Efficiency: Good
/ SSIS can be used to perform a broad range of data migration tasks. SSIS provides support for
complex workflow and data transformation between the source and destination.
It is a good choice to transfer of data for databases that require many changes to work on
Microsoft Azure SQL Database. You can use SSIS data transfer packages with another mechanism for
transferring the database schema, such as a Data-tier Application package.
SSIS for Azure and Hybrid Data Movement
Incorrect:
Not D: Generate Scripts Wizard
Has explicit option for Azure SQL Database scripts generation
Data Transfer Efficiency: Poor
Good for smaller database
/ Using the Generate Scripts wizard to migrate a SQL Server database to Azure SQL
Database should be limited to:
Teams who have experience with the wizard.
Migrating simple databases that need few schema changes to run on Azure SQL
Database. The scripts generated from the source database can be modified before being used to
create the new version of the database on Azure SQL Database, but using a database project in the
SQL Server Data Tools has richer support for making schema changes.
Migrating small databases that do not have much data. The wizard generates scripts that use insert
statements instead of bulk copies to transfer the data. The insert statements can be throttled when
the tables contain too much data, and are not as fast as bulk copies.

NEW QUESTION: 5
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. Transparent Data Encryption (TDE)
C. One-way encryption
D. Encrypting File System (EFS)
Answer: B
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)