Free AZ-500 Exam Braindumps (page: 32)

Page 32 of 128

You have an Azure SQL database.
You implement Always Encrypted.
You need to ensure that application developers can retrieve and decrypt data in the database.
Which two pieces of information should you provide to the developers? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. a stored access policy
  2. a shared access signature (SAS)
  3. the column encryption key
  4. user credentials
  5. the column master key

Answer(s): C,E

Explanation:

Always Encrypted uses two types of keys: column encryption keys and column master keys. A column encryption key is used to encrypt data in an encrypted column. A column master key is a key-protecting key that encrypts one or more column encryption keys.


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine



You have a hybrid configuration of Azure Active Directory (Azure AD).
All users have computers that run Windows 10 and are hybrid Azure AD joined.
You have an Azure SQL database that is configured to support Azure AD authentication.
Database developers must connect to the SQL database by using Microsoft SQL Server Management Studio (SSMS) and authenticate by using their on-premises
Active Directory account.
You need to tell the developers which authentication method to use to connect to the SQL database from SSMS. The solution must minimize authentication prompts.
Which authentication method should you instruct the developers to use?

  1. SQL Login
  2. Active Directory ג€" Universal with MFA support
  3. Active Directory ג€" Integrated
  4. Active Directory ג€" Password

Answer(s): C

Explanation:

Azure AD can be the initial Azure AD managed domain. Azure AD can also be an on-premises Active Directory Domain Services that is federated with the Azure
AD.
Using an Azure AD identity to connect using SSMS or SSDT
The following procedures show you how to connect to a SQL database with an Azure AD identity using SQL Server Management Studio or SQL Server Database
Tools.
Active Directory integrated authentication
Use this method if you are logged in to Windows using your Azure Active Directory credentials from a federated domain.
1. Start Management Studio or Data Tools and in the Connect to Server (or Connect to Database Engine) dialog box, in the Authentication box, select Active
Directory - Integrated. No password is needed or can be entered because your existing credentials will be presented for the connection.

2. Select the Options button, and on the Connection Properties page, in the Connect to database box, type the name of the user database you want to connect to.
(The AD domain name or tenant IDג€ option is only supported for Universal with MFA connection options, otherwise it is greyed out.)


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell



DRAG DROP (Drag and Drop is not supported) (Drag and Drop is not supported)
You have an Azure subscription named Sub1 that contains an Azure Storage account named contosostorage1 and an Azure key vault named Contosokeyvault1.
You plan to create an Azure Automation runbook that will rotate the keys of contosostorage1 and store them in Contosokeyvault1.
You need to implement prerequisites to ensure that you can implement the runbook.
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.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Step 1: Create an Azure Automation account
Runbooks live within the Azure Automation account and can execute PowerShell scripts.
Step 2: Import PowerShell modules to the Azure Automation account
Under 'Assets' from the Azure Automation account Resources section select 'to add in Modules to the runbook. To execute key vault cmdlets in the runbook, we need to add AzureRM.profile and AzureRM.key vault.
Step 3: Create a connection resource in the Azure Automation account
You can use the sample code below, taken from the AzureAutomationTutorialScript example runbook, to authenticate using the Run As account to manage
Resource Manager resources with your runbooks. The AzureRunAsConnection is a connection asset automatically created when we created 'run as accounts' above. This can be found under Assets -> Connections. After the authentication code, run the same code above to get all the keys from the vault.
$connectionName = "AzureRunAsConnection"
try
{
# Get the connection "AzureRunAsConnection "
$servicePrincipalConnection=Get-AutomationConnection -Name $connectionName
"Logging in to Azure..."
Add-AzureRmAccount `
-ServicePrincipal `
-TenantId $servicePrincipalConnection.TenantId `
-ApplicationId $servicePrincipalConnection.ApplicationId `
-CertificateThumbprint $servicePrincipalConnection.CertificateThumbprint
}


Reference:

https://www.rahulpnath.com/blog/accessing-azure-key-vault-from-azure-runbook/



HOTSPOT (Drag and Drop is not supported) (Drag and Drop is not supported)
You have an Azure Storage account that contains a blob container named container1 and a client application named App1.
You need to enable App1 access to container1 by using Azure Active Directory (Azure AD) authentication.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://azure.microsoft.com/en-in/blog/announcing-the-preview-of-aad-authentication-for-storage/ https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/storage/common/storage-auth-aad-app.md



Page 32 of 128



Post your Comments and Discuss Microsoft AZ-500 exam with other Community members:

priya commented on December 20, 2024
good to prepare for the exam
Anonymous
upvote

Mohammed commented on November 05, 2024
I got a 87.4% in my exam with these questions. Just keep in mind that the full version they sell in PDF format has way way more questions that covers most of the topics in this exam.
UNITED ARAB EMIRATES
upvote

Kambocha commented on August 16, 2024
The updated version is very well formatted and covers all topics that are in this certification exam.
Netherlands
upvote

Oliver commented on May 15, 2024
Pass this exam with the help of this exam dump. It is very similar to actual exam.
UNITED STATES
upvote

Kevin commented on May 15, 2024
To everyone going to set for this test, I must warn you that you cannot pass this test without the help of this study guide. I failed it before and then I bought this package and passed it right away. I checked the free sample content and it was very relevant to the exam. So I purchased it after. Make sure you do the same.
UNITED STATES
upvote

surya@gmail.com commented on May 15, 2024
Try it,just passed the az-500 exam this last friday. most of the questions in this exam dumps are in the exam.
Anonymous
upvote

Vasu commented on February 17, 2024
Great dumps
DENMARK
upvote

Moreece commented on May 15, 2023
just passed the az-500 exam this last friday. most of the questions in this exam dumps are in the exam. i bought the full version and noticed some of the questions which were answered wrong in the free version are all corrected in the full version. this site is good but i wish the had it in an interactive version like a test engine simulator.
Anonymous
upvote

Qasim commented on June 11, 2022
just clear exam on 10/06/2202 dumps is valid all questions are came same in dumps only 2 new questions total 46 questions 1 case study with 5 question no lab/simulation in my exam please check the answers best of luck
Anonymous
upvote

deally commented on January 19, 2024
knowable questions
UNITED STATES
upvote

labuschanka commented on November 16, 2023
i gave the microsoft azure az-500 tests and prepared from this site as it has latest mock tests available which helped me evaluate my performance and score 919/1000
Anonymous
upvote

Solo commented on January 19, 2024
Good stuff.
UNITED STATES
upvote

deally commented on January 19, 2024
knowable questions
UNITED STATES
upvote

Ramay commented on December 31, 2023
looking to prepare Az-500 Exam practices
UNITED KINGDOM
upvote

labuschanka commented on November 16, 2023
I gave the Microsoft Azure AZ-500 tests and prepared from this site as it has latest mock tests available which helped me evaluate my performance and score 919/1000
Anonymous
upvote

reventhekios commented on October 24, 2023
I cant beleive i just hit it, it was a wonderful opportunity and testing my skills was an awesome experience, just loved it . I AM PASSSSSSSSSED
GERMANY
upvote

kanishka commented on October 11, 2023
good and tough
Anonymous
upvote

Gurpret commented on October 02, 2023
The 50% discount is worth it. I bought 2 exams.
CANADA
upvote

Fernandes commented on June 15, 2023
The PDF is well formatted but I like the Interactive test engine. It shows you your score in the end and keeps a good history of your exam records.
ITALY
upvote

Moreece commented on May 15, 2023
Just passed the AZ-500 exam this last Friday. Most of the questions in this exam dumps are in the exam. I bought the full version and noticed some of the questions which were answered wrong in the free version are all corrected in the full version. This site is good but I wish the had it in an interactive version like a test engine simulator.
Anonymous
upvote

Xavier commented on April 24, 2023
The exam practice questions were on point... helped me pass in no time!
FRANCE
upvote

Abhinay commented on April 14, 2023
I highly recommend these exam dumps questions! They were well-structured, and the answers were explained in a clear and concise manner. As a result, I was able to pass my exam with a 91% score.
INDIA
upvote

LeeBrian commented on April 14, 2023
As someone who struggles with test anxiety, practicing with these practice questions helped me gain confidence and familiarize myself with the exam format. I went into my actual exam feeling prepared and aced it!
AUSTRALIA
upvote

Claudia commented on March 17, 2023
Just passed my exam. I am very very thankful to this exam dump.
CANADA
upvote

knuckles commented on March 14, 2023
The questions in this dump were spot-on and helped me prepare perfectly for my exam.
UNITED STATES
upvote

Louis commented on March 14, 2023
This exam dumps questions are real, it helped me pass my exam.
UNITED STATES
upvote

kwong commented on July 26, 2022
Good enough for me. I just passed.
UNITED STATES
upvote

Radha commented on July 22, 2022
The 100% pass guarantee is honored. All practice questions are in the exam.
UNITED STATES
upvote

Shobena commented on July 11, 2022
Hello team, I passed my exam today with a score of 96%.
INDIA
upvote

Qasim commented on June 11, 2022
Just clear exam on 10/06/2202 Dumps is valid All questions are came same in dumps Only 2 new questions Total 46 questions 1 Case study with 5 Question No lab/Simulation in my exam Please check the answers Best of luck
Anonymous
upvote

Paul commented on June 02, 2022
Just passed. This exam dump is valid in Brazil.
BRAZIL
upvote

Exam-Fakker commented on June 23, 2021
I just fakked one more exam today hahahaha. These braindumps are freaking amazing.
AUSTRALIA
upvote

Hisham commented on June 02, 2020
This morning I wrong my exam online and passed it. Looking forward to my next exam now.
UNITED ARAB EMIRATES
upvote

Jain commented on June 02, 2020
The realities of work-from-home necessitated by the COVID-19 pandemic has given me some spare time to invest on myself. So I purchased this stuy guides to prepare for my certfication.
UNITED STATES
upvote