Question 1mediummultiple choice
Full question →Question 222 of 324
mediummultiple choiceObjective-mapped
AZ-204 Practice Question: Deployment slot sticky settings prevent database…
This AZ-204 practice question tests your understanding of deployment slot sticky settings prevent database…. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. A key principle to apply: deployment slots. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
An App Service application uses a staging deployment slot connected to a staging database and a production slot connected to a production database. Both use an app setting called 'DbConnectionString'. After a slot swap, the production slot starts using the staging database connection string. What configuration change prevents this?
Answer choices
Why each option matters
Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.
A
Best answer
Mark the 'DbConnectionString' app setting as a deployment slot setting (sticky) so it remains bound to its slot across all swaps
Sticky settings are slot-specific. When slots swap, the code moves but sticky settings stay with the slot they were defined in. The staging slot retains its staging DbConnectionString and the production slot retains its production DbConnectionString permanently, regardless of how many swaps occur.
B
Distractor review
Store the connection string in Azure Key Vault and reference it via a Key Vault reference in both slots
Key Vault references retrieve secrets at runtime, but the secret name or URI in the app setting still swaps with the slot unless the app setting itself is marked as sticky. The Key Vault reference does not inherently prevent the setting from swapping.
C
Distractor review
Use different app setting names for each slot (e.g., 'StagingDbConnectionString' and 'ProductionDbConnectionString') and swap code manually
Using different names requires code changes to reference the correct setting name and breaks the clean staging/production separation. The sticky setting mechanism is the purpose-built solution — it allows the same name with slot-specific values.
D
Distractor review
Disable slot swaps and use a CI/CD pipeline to deploy directly to production instead
Disabling slot swaps removes the warm-up and zero-downtime deployment capability. The sticky setting is a narrow, precise fix for the stated problem without eliminating the benefits of slot-based deployments.
Common exam trap
Common exam trap: answer the scenario, not the keyword
Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.
Technical deep dive
How to think about this question
Treat this as a scenario question. Identify the problem, the constraint, and the best action. Then compare each option against those facts.
KKey Concepts to Remember
- deployment slots
- sticky settings
- slot swap behavior
- deployment slot settings
TExam Day Tips
- Watch for words such as best, first, most likely and least administrative effort.
- Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
deployment slots
Related practice questions
Related AZ-204 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
More questions from this exam
Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.
Question 1
An application stores customer invoices in Azure Blob Storage. Deleted blobs must be recoverable for 14 days. What should be enabled?
Question 2
You are deploying a containerized application to Azure Container Instances. The application requires a custom domain name and SSL/TLS termination. You need to configure these features. Which resource should you create alongside the container group?
Question 3
A developer needs to run a Kusto query against application request data to identify 95th percentile latency by operation. Where should the query be run? The architecture review board prefers a managed AWS-native control.
Question 4
You are developing a web app that authenticates users via Microsoft Entra ID. The app needs to read the user's profile and send emails on their behalf. You want to minimize user consent prompts. Which OAuth 2.0 grant type should you use?
Question 5
You are developing an Azure Function that processes messages from an Azure Service Bus queue. The function uses a Service Bus queue trigger and runs on a Consumption Plan. The queue receives a high volume of messages in bursts. You need to ensure that the function scales out to handle the load but does not exceed 10 concurrent instances. Which configuration should you apply?
Question 6
You are monitoring an Azure App Service using Application Insights. You notice that the server response time is high for certain requests. You need to drill down to see which external dependencies (like databases or APIs) are causing the delay. Which Application Insights feature should you use?
Practice this exam
Start a free AZ-204 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this AZ-204 question test?
deployment slots
What is the correct answer to this question?
The correct answer is: Mark the 'DbConnectionString' app setting as a deployment slot setting (sticky) so it remains bound to its slot across all swaps — By default, app settings and connection strings swap along with the application code during a slot swap. To keep a setting bound to a specific slot regardless of swaps, mark it as a 'deployment slot setting' (also called a 'sticky' setting). Sticky settings do not move when slots are swapped — each slot keeps its own value. After marking DbConnectionString as sticky, the staging slot always uses the staging value and the production slot always uses the production value, even after a swap.
What should I do if I get this AZ-204 question wrong?
Review deployment slots, then practise related AZ-204 questions on the same topic to reinforce the concept.
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 →
Discussion
Loading comments…
Sign in to join the discussion.
This AZ-204 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 AZ-204 exam.