Monitor, configure, and optimize database resources →mediumMultiple ChoiceObjective-mapped

DP-300 Practice Question: Monitor, configure, and optimize database resources

Exhibit

Refer to the exhibit.

{
    "kind": "System",
    "properties": {
        "majorVersion": "12.0",
        "preferredEnclaveType": "VBS",
        "serverConfiguration": {
            "isLedgerOn": false,
            "isIntelligentInsightsOn": true
        }
    }
}

Refer to the exhibit. You retrieve the configuration of an Azure SQL Database. Based on the JSON output, which feature is enabled?

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

✓

Intelligent Insights

The JSON output shows "isIntelligentInsightsOn": true, indicating that the Intelligent Insights feature is enabled for the Azure SQL Database. Option A is incorrect because "isLedgerOn" is false. Option B is incorrect because there is no mention of availability groups in the JSON. Option D is incorrect because even though "preferredEnclaveType" is set to VBS, Always Encrypted with secure enclaves requires explicit configuration on columns, and the setting alone does not mean the feature is enabled.

Answer analysis

Option-by-option breakdown

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

✗
Ledger tables
Why it's wrong here
isLedgerOn is false.
✗
Always On availability groups
Why it's wrong here
Not shown in config.
✓
Intelligent Insights
Why this is correct
isIntelligentInsightsOn is true.
✗
Always Encrypted with secure enclaves
Why it's wrong here
preferredEnclaveType is VBS but feature is per-column.

Go deeper

DP-300 Practice Question: Monitor, configure, and optimize database resources

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question