Exam AZ-203 All Questions

View all questions & answers for the AZ-203 exam

Exam AZ-203 topic 20 question 3 discussion

Actual exam question from Microsoft's AZ-203

Question #: 3
Topic #: 20

HOTSPOT -
You need to ensure that security requirements are met.
What value should be used for the ConnectionString field on line DB03 in the Database class? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer: Explanation
Box 1: Integrated Security=SSPI -
Integrated security: For all data source types, connect using the current user account.
For SqlClient you can use Integrated Security=true; or Integrated Security=SSPI;
Scenario: All access to Azure Storage and Azure SQL database must use the application's Managed Service Identity (MSI)

Box 2: Encrypt = True -
Scenario: All data must be protected in transit.
References:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax

by heero at Feb. 25, 2020, 2:38 p.m.

Comments

Submit Cancel

gssicftohbcrcsgtjg

Highly Voted 5 years, 4 months ago

options https://www.examtopics.com/assets/media/exam-media/02522/0001100001.png

upvoted 15 times

...

heero

Highly Voted 5 years, 4 months ago

https://www.testpassport.com/T/T-COM/images/uploads/exams/AZ-203_12/image044.jpg

upvoted 7 times

...

monniq

Most Recent 4 years, 4 months ago

You cannot use Integrated Security=True/SSPI when connecting to Azure SQL Database.. Take a look at the note. https://www.connectionstrings.com/sqlconnection/integrated-windows-authentication-with-an-azure-ad-identity/ So, I think that the correct answers are - Trusted_Connection=False - Encrypt=True

upvoted 2 times

Juanlu

4 years, 3 months ago

Agree. As others member said, this is the correct answer: - Box 1: Truster_Connection=False, - Box 2: Encrypt=True Thanks a lot everyone

upvoted 1 times

...

Gathix444

4 years, 5 months ago

Answer correct https://www.connectionstrings.com/azure-sql-database/

upvoted 1 times

...

Cornholioz

4 years, 6 months ago

Integrated Security is deprecated but has the right value (SSPI=>True). Trusted_Connection value in the option is 'False'. Only the exam creators can provide the right answer.

upvoted 2 times

...

asdasdfbnnbgdfasf

4 years, 9 months ago

provided answer is correct but deprecated https://docs.microsoft.com/en-us/sql/connect/oledb/features/using-azure-active-directory?view=sql-server-ver15#integrated-windows-authentication-using-security-support-provider-interface-sspi

upvoted 4 times

...

jv10

4 years, 11 months ago

Sql Connection : Server=tcp:myserver.database.windows.net,1433;Database=myDataBase;User ID=mylogin@myserver;Password=myPassword;Trusted_Connection=False;Encrypt=True Ans should be : Trusted_connection =False , Encrypt =True

upvoted 6 times

...

nikos2001

4 years, 11 months ago

Integrated Security (synonym: Trusted_Connection) = FALSE Encrypt = TRUE "All access to Azure Storage and Azure SQL database must use the application's Managed Service Identity (MSI)" https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell#azure-ad-token string ConnectionString =@"Data Source=n9lxnyuzhv.database.windows.net; Initial Catalog=testdb;" SqlConnection conn = new SqlConnection(ConnectionString); conn.AccessToken = "Your JWT token" conn.Open();

upvoted 2 times

...

Jedik

5 years, 1 month ago

https://www.connectionstrings.com/azure-sql-database/ Standard Server=tcp:myserver.database.windows.net,1433;Database=myDataBase;User ID=mylogin@myserver;Password=myPassword;Trusted_Connection=False;Encrypt=True; Azure SQL Database With MARS enabled Server=tcp:myserver.database.windows.net,1433;Database=myDataBase;User ID=mylogin@myserver;Password=myPassword;Trusted_Connection=False;Encrypt=True;MultipleActiveResultSets=True;

upvoted 5 times

LTiwana

4 years, 11 months ago

I think you are correct. Right options should be: - Trusted_Connection=False - Encrypt=True

upvoted 2 times

...

Jedik

5 years, 1 month ago

Integrated authentication (i.e. SSPI in the connection string) is NOT supported in SQL Azure. Only SQL Authentication is supported (i.e. username & password in the connection string)

upvoted 1 times

...