Develop Azure compute solutions →mediumMultiple ChoiceObjective-mapped

AZ-204 Develop Azure compute solutions Practice Question

Exhibit

Refer to the exhibit.

```json
{
  "type": "Microsoft.Web/sites/config",
  "apiVersion": "2022-09-01",
  "name": "myApp/connectionstrings",
  "properties": {
    "DefaultConnection": {
      "value": "Server=tcp:myserver.database.windows.net;Database=mydb;User ID=myuser;Password=mypassword;Encrypt=True;",
      "type": "SQLAzure"
    }
  }
}
```

You deploy the above ARM template resource for a web app. The web app reads the connection string from the 'DefaultConnection' name. However, the web app fails to connect to the database with an error 'Login failed for user 'myuser'. What is the most likely cause?

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

✓

The SQL server is configured to use Microsoft Entra authentication only, not SQL authentication.

The login failure indicates that the SQL server does not accept SQL authentication. If the server is configured for Microsoft Entra authentication only, then SQL login credentials (username/password) will fail. Option A is incorrect because the user ID may exist but authentication method is wrong. Option B is incorrect because 'SQLAzure' is the correct connection string type for Azure SQL Database. Option D is incorrect because 'Trusted_Connection=True' is for Windows authentication, not applicable to Azure SQL.

Answer analysis

Option-by-option breakdown

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

✗
The user ID does not have access to the database.
Why it's wrong here
The error 'Login failed' indicates the login itself failed, not access to a specific database.
✗
The connection string type should be 'SQLServer' instead of 'SQLAzure'.
Why it's wrong here
For Azure SQL Database, 'SQLAzure' is the correct type.
✓
The SQL server is configured to use Microsoft Entra authentication only, not SQL authentication.
Why this is correct
If the server only allows Microsoft Entra authentication, SQL authentication will fail.
✗
The connection string is missing 'Trusted_Connection=True;'.
Why it's wrong here
Trusted_Connection is not used with SQL authentication.

Go deeper

AZ-204 Develop Azure compute solutions Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question