Valid 70-765 Dumps shared by PassLeader for Helping Passing 70-765 Exam! PassLeader now offer the newest 70-765 VCE dumps and 70-765 PDF dumps, the PassLeader 70-765 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-765 dumps with VCE and PDF here: https://www.passleader.com/70-765.html (155 Q&As Dumps –> 192 Q&As Dumps –> 211 Q&As Dumps –> 282 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader 70-765 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpZHlHSG5KM09xUms
QUESTION 13
Drag and Drop Question
A new Azure Active Directory security principal named [email protected] should have access to select all current and future objects in the Reporting database. You should not grant the principal any other permissions. You should use your Active Directory Domain Services (AD DS) account to authenticate to the Azure SQL database. You need to create the new security principal. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Answer:
Explanation:
Step 1:
To provision an Azure AD-based contained database user (other than the server administrator that owns the database), connect to the database (here the Reporting database) with an Azure AD identity (not with a SQL Server account) that has access to the database.
Step 2:
To create an Azure AD-based contained database user (other than the server administrator that owns the database), connect to the database with an Azure AD identity, as a user with at least the ALTER ANY USER permission.
Step 3:
Grant the proper reading permissions.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication
QUESTION 14
You manage a Microsoft SQL Server environment in a Microsoft Azure virtual machine. You must enable Always Encrypted for columns in a database. You need to configure the key store provider. What should you do?
A. Manually specify the column master key.
B. Modify the connection string for applications.
C. Auto-generate a column master key.
D. Use theWindows certificate store.
Answer: D
Explanation:
Always Encrypted supports multiple key stores for storing Always Encrypted column master keys. A column master key can be a certificate stored in Windows Certificate Store.
https://msdn.microsoft.com/en-us/library/mt723359.aspx
QUESTION 15
You plan to deploy 20 Microsoft Azure SQL Database instances to an elastic pool in Azure to support a batch processing application. Two of the databases in the pool reach their peak workload threshold at the same time every day. This leads to inconsistent performance for batch completion. You need to ensure that all batches perform consistently. What should you do?
A. Create an In-Memory table.
B. Increase the storage limit in the pool.
C. Implement a readable secondary database.
D. Increase the total number of elastic Database Transaction Units (eDTUs) in the pool.
Answer: D
Explanation:
In SQL Database, the relative measure of a database’s ability tohandle resource demands is expressed in Database Transaction Units (DTUs) for single databases and elastic DTUs (eDTUs) for databases in an elastic pool. A pool is given a set number of eDTUs, for a set price. Within the pool, individual databases are given the flexibility to auto-scale within set parameters. Under heavy load, a database can consume more eDTUs to meet demand. Additional eDTUs can be added to an existing pool with no database downtime.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
Get the newest PassLeader 70-765 VCE dumps here: https://www.passleader.com/70-765.html (155 Q&As Dumps –> 192 Q&As Dumps –> 211 Q&As Dumps –> 282 Q&As Dumps)
And, DOWNLOAD the newest PassLeader 70-765 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=0B-ob6L_QjGLpZHlHSG5KM09xUms