Courseiva
Question 764 of 919
Implement a secure environmenthardMultiple SelectObjective-mapped

DP-300 Implement a secure environment Practice Question

Your Azure SQL Database is accessed by multiple applications. You need to ensure that all connections use Transport Layer Security (TLS) 1.2 or higher. Which TWO configurations should you verify or enable?

⚠ Common exam trap

Watch out — candidates often confuse network-level controls (like NSGs) with TLS-level enforcement, or mistakenly apply on-premises SQL Server settings (like 'ForceEncryption') to Azure SQL Database, which has different configuration mechanisms and defaults.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Configure client applications to use TLS 1.2 in their connection strings.

Client applications must explicitly request TLS 1.2 in their connection strings (e.g., by adding 'Encrypt=True;TrustServerCertificate=False;' and specifying the minimum TLS version in the underlying driver configuration). Without this, the client may negotiate a lower TLS version, even if the server supports higher versions. Option D is correct because setting the server's 'minimalTlsVersion' property to '1.2' enforces that the Azure SQL Database server rejects any connection attempt using TLS 1.0 or 1.1, ensuring only TLS 1.2+ connections are accepted at the server level.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Configure client applications to use TLS 1.2 in their connection strings.

    Why this is correct

    Clients must also support TLS 1.2.

  • Create a network security group rule to block non-TLS traffic.

    Why it's wrong here

    NSGs are not applicable to Azure SQL Database.

  • Set 'DenyPublicNetworkAccess' to 'Yes' on the server.

    Why it's wrong here

    This blocks public access, does not enforce TLS version.

  • Set the server's 'minimalTlsVersion' property to '1.2'.

    Why this is correct

    This enforces TLS 1.2 at the server level.

  • Enable 'ForceEncryption' on the SQL Server instance.

    Why it's wrong here

    ForceEncryption is for SQL Server on-premises, not Azure SQL Database.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Last reviewed: Jun 24, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

Sign in to join the discussion.

This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.