Microsoft AZ-305 Practice Test 29
Question 280
A development SQL database is idle overnight but has an acceptable wake-up delay. Which TWO configurations belong in an economical serverless design? (Select TWO.)
- Use a supported Azure SQL Database serverless tier for variable compute demand.
- Pay for a large provisioned instance continuously regardless of the measured workload.
- Enable and size an eligible auto-pause delay after validating plan support.
- Assert Business Critical supports the identical serverless auto-pause design by default.
- Drop database backups because serverless resumes automatically.
Explanation
Correct Answers
A:Serverless scales compute and bills according to its supported model.
C:Compute can pause during inactivity where the feature is available.
Incorrect Answers
B:Always-on capacity may negate savings for a mostly idle database.
D:Serverless and pause capabilities vary across tiers.
E:Compute elasticity does not replace recovery protection.
Question 281
An architecture proposal for azure sql serverless compute economics relies on the following approach: Keep a large provisioned database running continuously despite the idle workload. Which specific failure or mismatch should the design reviewer identify?
- Business Critical does not share the same serverless capability profile.
- Always-on provisioned compute can waste idle capacity in this scenario.
- Geo-replication is asynchronous and cannot guarantee zero RPO.
- Auto-pause introduces resume delay incompatible with no-cold-start expectations.
Explanation
Correct Answer
B:Keep a large provisioned database running continuously despite the idle workload. Always-on provisioned compute can waste idle capacity in this scenario.
Incorrect Answers
A:That assessment refers to the separate proposal 'Assume Business Critical offers general-purpose-style serverless auto-pause by default.' not to the recommendation under review. Here, Always-on provisioned compute can waste idle capacity in this scenario.
C:This concern applies to Promise the secondary contains every committed primary transaction synchronously. in another design data storage solutions for relational data design. The current proposal specifically fails because always-on provisioned compute can waste idle capacity in this scenario.
D:That assessment refers to the separate proposal 'Enable short auto-pause for a database with strict immediate response requirements.' not to the recommendation under review. Here, Always-on provisioned compute can waste idle capacity in this scenario.
Question 282
Acceptance testing must establish the following operational result: Idle-time billing evidence demonstrates the intended savings. Which verification action most directly establishes that outcome?
- Review current tier settings and Microsoft service feature availability.
- Load-test idle-to-request latency after the service has no activity.
- Review pause/resume history and effective compute billing.
- Compare commit timestamps and replication lag during representative load.
Explanation
Correct Answer
C:Idle-time billing evidence demonstrates the intended savings.
Incorrect Answers
A:That verification addresses the different requirement: An architect asserts serverless automatic pause is GA for every Azure SQL Database tier. It does not directly establish idle-time billing evidence demonstrates the intended savings.
B:That verification addresses the different requirement: A customer-facing database requires instant responses and predictable compute at all times. It does not directly establish idle-time billing evidence demonstrates the intended savings.
D:This is a test for A secondary region is intended for reporting but data may be delayed compared with the writer. The requirement here is instead demonstrated by review pause/resume history and effective compute billing.
Question 283
A customer-facing database requires instant responses and predictable compute at all times. Which Azure architecture choice best meets this requirement?
- Enable short auto-pause for a database with strict immediate response requirements.
- Keep a large provisioned database running continuously despite the idle workload.
- Assume Business Critical offers general-purpose-style serverless auto-pause by default.
- Use provisioned Azure SQL Database compute sized for sustained availability.
Explanation
Correct Answer
D:Provisioned compute avoids the cold-resume behavior of paused serverless databases.
Incorrect Answers
A:Auto-pause introduces resume delay incompatible with no-cold-start expectations. This proposal contradicts the stated architecture constraint.
B:Always-on provisioned compute can waste idle capacity in this scenario. In the present requirement, a customer-facing database requires instant responses and predictable compute at all times. The needed design instead works because provisioned compute avoids the cold-resume behavior of paused serverless databases.
C:Business Critical does not share the same serverless capability profile. In the present requirement, a customer-facing database requires instant responses and predictable compute at all times. The needed design instead works because provisioned compute avoids the cold-resume behavior of paused serverless databases.
Question 284
An architecture proposal for azure sql serverless compute economics relies on the following approach: Enable short auto-pause for a database with strict immediate response requirements. Which specific failure or mismatch should the design reviewer identify?
- PaaS does not grant arbitrary guest kernel and instance customization.
- Always-on provisioned compute can waste idle capacity in this scenario.
- Auto-pause introduces resume delay incompatible with no-cold-start expectations.
- Business Critical does not share the same serverless capability profile.
Explanation
Correct Answer
C:Enable short auto-pause for a database with strict immediate response requirements. Auto-pause introduces resume delay incompatible with no-cold-start expectations.
Incorrect Answers
A:This concern applies to Force a PaaS migration without validating extension compatibility. in another design data storage solutions for relational data design. The current proposal specifically fails because auto-pause introduces resume delay incompatible with no-cold-start expectations.
B:That assessment refers to the separate proposal 'Keep a large provisioned database running continuously despite the idle workload.' not to the recommendation under review. Here, Auto-pause introduces resume delay incompatible with no-cold-start expectations.
D:That assessment refers to the separate proposal 'Assume Business Critical offers general-purpose-style serverless auto-pause by default.' not to the recommendation under review. Here, Auto-pause introduces resume delay incompatible with no-cold-start expectations.
Question 285
Acceptance testing must establish the following operational result: The test verifies predictable initial response time. Which verification action most directly establishes that outcome?
- Test the required extension in the proposed VM image.
- Load-test idle-to-request latency after the service has no activity.
- Review current tier settings and Microsoft service feature availability.
- Review pause/resume history and effective compute billing.
Explanation
Correct Answer
B:The test verifies predictable initial response time.
Incorrect Answers
A:This is a test for A legacy app uses kernel-level SQL extensions and unsupported OS customizations. The requirement here is instead demonstrated by load-test idle-to-request latency after the service has no activity.
C:That verification addresses the different requirement: An architect asserts serverless automatic pause is GA for every Azure SQL Database tier. It does not directly establish the test verifies predictable initial response time.
D:That verification addresses the different requirement: A development database receives traffic twice daily and is idle overnight, with tolerance for wake-up latency. It does not directly establish the test verifies predictable initial response time.
Question 286
An architect asserts serverless automatic pause is GA for every Azure SQL Database tier. Which Azure architecture choice best meets this requirement?
- Check the precise serverless tier and auto-pause feature support before using it.
- Assume Business Critical offers general-purpose-style serverless auto-pause by default.
- Enable short auto-pause for a database with strict immediate response requirements.
- Keep a large provisioned database running continuously despite the idle workload.
Explanation
Correct Answer
A:Serverless compute support and automatic pause support are not identical across tiers.
Incorrect Answers
B:Business Critical does not share the same serverless capability profile. This proposal contradicts the stated architecture constraint.
C:Auto-pause introduces resume delay incompatible with no-cold-start expectations. In the present requirement, an architect asserts serverless automatic pause is GA for every Azure SQL Database tier. The needed design instead works because serverless compute support and automatic pause support are not identical across tiers.
D:Always-on provisioned compute can waste idle capacity in this scenario. In the present requirement, an architect asserts serverless automatic pause is GA for every Azure SQL Database tier. The needed design instead works because serverless compute support and automatic pause support are not identical across tiers.
Question 287
An architecture proposal for azure sql serverless compute economics relies on the following approach: Assume Business Critical offers general-purpose-style serverless auto-pause by default. Which specific failure or mismatch should the design reviewer identify?
- Always-on provisioned compute can waste idle capacity in this scenario.
- Auto-pause introduces resume delay incompatible with no-cold-start expectations.
- Business Critical does not share the same serverless capability profile.
- Fixed regional names can break clients after disaster recovery.
Explanation
Correct Answer
C:Assume Business Critical offers general-purpose-style serverless auto-pause by default. Business Critical does not share the same serverless capability profile.
Incorrect Answers
A:That assessment refers to the separate proposal 'Keep a large provisioned database running continuously despite the idle workload.' not to the recommendation under review. Here, Business Critical does not share the same serverless capability profile.
B:That assessment refers to the separate proposal 'Enable short auto-pause for a database with strict immediate response requirements.' not to the recommendation under review. Here, Business Critical does not share the same serverless capability profile.
D:This concern applies to Hardcode the primary database region hostname in every microservice with no failover logic. in another design data storage solutions for relational data design. The current proposal specifically fails because business Critical does not share the same serverless capability profile.
Question 288
Acceptance testing must establish the following operational result: Exact SKU evidence prevents invalid service-tier assumptions. Which verification action most directly establishes that outcome?
- Review pause/resume history and effective compute billing.
- Fail over a nonproduction group and test listener connectivity.
- Review current tier settings and Microsoft service feature availability.
- Load-test idle-to-request latency after the service has no activity.
Explanation
Correct Answer
C:Exact SKU evidence prevents invalid service-tier assumptions.
Incorrect Answers
A:That verification addresses the different requirement: A development database receives traffic twice daily and is idle overnight, with tolerance for wake-up latency. It does not directly establish exact SKU evidence prevents invalid service-tier assumptions.
B:This is a test for A globally deployed application needs cross-region SQL failover with a stable application endpoint. The requirement here is instead demonstrated by review current tier settings and Microsoft service feature availability.
D:That verification addresses the different requirement: A customer-facing database requires instant responses and predictable compute at all times. It does not directly establish exact SKU evidence prevents invalid service-tier assumptions.
Question 289
A software vendor hosts 60 small customer databases with staggered peak usage. Which Azure architecture choice best meets this requirement?
- Treat the whole elastic pool as one database requiring one common restore point.
- Remove all limits and promise guaranteed performance to every database.
- Overprovision every single database for the sum of all hypothetical peaks.
- Place appropriately compatible databases in an Azure SQL elastic pool.
Explanation
Correct Answer
D:Shared pool resources can smooth independent per-database utilization peaks.
Incorrect Answers
A:Tenant databases retain separate data and recovery concerns. In the present requirement, a software vendor hosts 60 small customer databases with staggered peak usage. The needed design instead works because shared pool resources can smooth independent per-database utilization peaks.
B:Shared resources without governance cannot assure independent maxima. In the present requirement, a software vendor hosts 60 small customer databases with staggered peak usage. The needed design instead works because shared pool resources can smooth independent per-database utilization peaks.
C:Dedicated maximum capacity per tenant can waste substantial compute. This proposal contradicts the stated architecture constraint.
Question 290
An architecture proposal for azure sql elastic pools relies on the following approach: Overprovision every single database for the sum of all hypothetical peaks. Which specific failure or mismatch should the design reviewer identify?
- Dedicated maximum capacity per tenant can waste substantial compute.
- Shared resources without governance cannot assure independent maxima.
- Tenant databases retain separate data and recovery concerns.
- Ownership expands privileges and error logs are not a complete audited access stream.
Explanation
Correct Answer
A:Overprovision every single database for the sum of all hypothetical peaks. Dedicated maximum capacity per tenant can waste substantial compute.
Incorrect Answers
B:That assessment refers to the separate proposal 'Remove all limits and promise guaranteed performance to every database.' not to the recommendation under review. Here, Dedicated maximum capacity per tenant can waste substantial compute.
C:That assessment refers to the separate proposal 'Treat the whole elastic pool as one database requiring one common restore point.' not to the recommendation under review. Here, Dedicated maximum capacity per tenant can waste substantial compute.
D:This concern applies to Make auditors database owners and rely only on SQL server errors. in another design data storage solutions for relational data design. The current proposal specifically fails because dedicated maximum capacity per tenant can waste substantial compute.