Microsoft Exam AZ-305 Topic 3 Question 52 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 52
Topic #: 3

[All AZ-305 Questions]

You need to recommend a data storage solution that meets the following requirements:

* Ensures that applications can access the data by using a REST connection

* Hosts 20 independent tables of varying sizes and usage patterns

* Automatically replicates the data to a second Azure region

* Minimizes costs

What should you recommend?

Aan Azure SQL Database elastic pool that uses active geo-replication

Btables in an Azure Storage account that use read-access geo-redundant storage (RA-GRS)

Can Azure SQL database that uses active geo-replication

Dtables in an Azure Storage account that use geo-redundant storage (GRS)

Show Suggested Answer

Suggested Answer: D

by Lashandra at Mar 20, 2024, 09:17 PM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Laura

6 months ago

That's a good point, Timothy. The requirement for applications to access data using a REST connection is a key factor in this decision

upvoted 0 times

...

Timothy

6 months ago

I think option C, an Azure SQL database with active geo-replication, is the way to go. It provides both data replication and access via REST connection

upvoted 0 times

...

Dean

6 months ago

That could be a valid point, Olive. Depending on the budget constraints, cost might be a deciding factor in this recommendation

upvoted 0 times

...

Olive

6 months ago

But wouldn't option B, using tables in an Azure Storage account with read-access geo-redundant storage, be more cost-effective?

upvoted 0 times

...

Laura

7 months ago

I agree with you, Dean. Active geo-replication ensures data is replicated to a second Azure region for disaster recovery

upvoted 0 times

...

Dean

7 months ago

I think option A, an Azure SQL Database elastic pool with active geo-replication, would be the best choice

upvoted 0 times

...

You know, if we're really trying to minimize costs, I wonder if we could get away with a single Azure SQL Database instance and use active geo-replication to meet the replication requirement. That might be the most cost-effective solution, even if it's not as flexible as the other options.

upvoted 0 times

...

Bette

8 months ago

I don't know, the REST access requirement makes me hesitant about going with just a storage account. Azure SQL Database might be a better fit there, even if it's a bit more expensive.

upvoted 0 times

...

Halina

8 months ago

I'm leaning towards option B. Azure Storage accounts with RA-GRS seem like they could meet the requirements, especially the automatic replication to a second region. Plus, it's probably cheaper than a full-blown Azure SQL Database solution.

upvoted 0 times

...

Dorathy

8 months ago

Hmm, this seems like a tricky one. We need a solution that can handle a variety of table sizes and usage patterns, provide REST access, and automatically replicate the data, all while being cost-effective. That's a tall order!

upvoted 0 times

Pilar

8 months ago

Yeah, option A seems to be the best choice. It meets all the specified requirements and is cost-effective too.

upvoted 0 times

...

Dortha

8 months ago

A) an Azure SQL Database elastic pool that uses active geo-replication

upvoted 0 times

...

Polly

8 months ago

I'm not sure if that would meet all the requirements. It might be better to go with option A.

upvoted 0 times

...

Ruth

8 months ago

B) tables in an Azure Storage account that use read-access geo-redundant storage (RA-GRS)

upvoted 0 times

...

Elliot

8 months ago

That sounds like a good option. It can handle different table sizes and usage patterns.

upvoted 0 times

...

Wenona

8 months ago

A) an Azure SQL Database elastic pool that uses active geo-replication

upvoted 0 times

...

Microsoft Exam AZ-305 Topic 3 Question 52 Discussion

Contribute your Thoughts:

Laura

Timothy

Dean

Olive

Laura

Dean

Olene

Bette

Halina

Dorathy

Pilar

Dortha

Polly

Ruth

Elliot

Wenona