ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-301 All Questions

View all questions & answers for the AZ-301 exam
Go to Exam

Exam AZ-301 topic 6 question 3 discussion

Actual exam question from Microsoft's AZ-301
Question #: 3
Topic #: 6
[All AZ-301 Questions]

You need to recommend a data storage solution that meets the following requirements:
✑ Ensures that application 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?

  • A. an Azure SQL Database elastic database pool that uses active geo-replication
  • B. tables in an Azure Storage account that uses geo-redundant storage (GRS)
  • C. tables in an Azure Storage account that use read-access geo-redundant storage (RA-GR)
  • D. an Azure SQL database that uses active geo-replication
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by gabriion at Sept. 2, 2019, 8:45 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
gabriion
Highly Voted 5 years, 10 months ago
Why not GRS, which is B? They don't need to read from the secondary endpoint and RA-GRS is more expensive.
upvoted 59 times
Ekramy_Elnaggar
5 years, 5 months ago
Agreee
upvoted 6 times
satgo
5 years, 1 month ago
Disagree with you. Whenever a 2nd replica means always read only access
upvoted 2 times
FloJoe
5 years ago
You are so wrong mate. 2nd replica can be - your data replicated in the same data center - your data replicated in another data center in the same region - your data replicated in another data center in another region These are then the different levels which you need for your disaster strategy. If a region fails, the first two options are not helpful. GRS and RA-GRS both mean the third option. However, in GRS you would only be able to read from the fall back location once the disaster occured and first data source becomes unavailble. The RA-GRS however, gives you a way to read from the 2nd location already which is useful in same cases but more expensive than simply GRS. Here, we do not have a requirement to read data from the 2nd location while the first is still actively working. Hence B is the cheaper option.
upvoted 24 times
tartar
4 years, 9 months ago
B is ok
upvoted 5 times
...
...
...
...
Daren
5 years, 2 months ago
True. B is correct
upvoted 3 times
...
gops84
5 years, 1 month ago
true, RA-GRS is more expensive and there is no specific reason to choose it here.
upvoted 4 times
...
...
Ekramy_Elnaggar
Highly Voted 5 years, 5 months ago
- Ensures that application can access the data by using a REST connection >> this eliminates the SQL option . - Minimize costs >> this eliminates the RA-GRS so the correct answer is : B
upvoted 41 times
Pierrick
5 years, 1 month ago
Why does it eliminates SQL option ? https://docs.microsoft.com/en-us/rest/api/sql/
upvoted 1 times
FloJoe
5 years ago
To my understanding, with that REST API you manage the databases (like remove a db or pause a db, etc.) But you cannot access the data of the DB instances. Hence the apps cannot access data by using REST.
upvoted 2 times
...
Abhiatms02
4 years, 10 months ago
he built-in REST API is supported for server and database management. This means you can only perform CRUD at server or database level (e.g. creating a new database, updating some settings). You can use OData as it is supported in Azure SQL Database query.
upvoted 1 times
...
...
...
AKumar
Most Recent 4 years, 3 months ago
Found no such requirement which will justify the given answer. Instead question considered to minimize the cost, thus correct and best option to choose is - B- tables in an Azure Storage account that uses geo-redundant storage (GRS)
upvoted 1 times
...
glam
4 years, 4 months ago
B. tables in an Azure Storage account that uses geo-redundant storage (GRS)
upvoted 1 times
...
sanketshah
4 years, 5 months ago
B is correct answer
upvoted 1 times
...
solgae
4 years, 9 months ago
B is NOT the correct answer. GRS does NOT provide automatic failover capability - it needs to be MANUALLY triggered when region failure occurs! (There’s a reason why GRS is cheaper than RA-GRS) Because one of the requirements listed on the question asks to “ensure” application can be accessed by REST, it CANNOT have a period where the data is not accessible. Only RA-GRS can guarantee availability in that level. (If you argue the question is worded vaguely, then you would be right, but take “ensure” as “always available as much as possible”) There are too many comments that gets hung up about “no requirement for secondary read-only copy” and the “minimize cost requirement”. Do not get tunnel visioned to a single requirement and consider ALL requirements. If the solution only meets partial requirements, it is NOT a valid solution. Consider ALL requirements, and not just a single one. The given answer C is correct.
upvoted 3 times
milind8451
4 years, 5 months ago
There is no requirement for automatic failover, you should notice the cost factor as well. B is correct.
upvoted 1 times
...
...
Rooh
4 years, 9 months ago
The correct answer is B
upvoted 1 times
...
manu202020
4 years, 10 months ago
I believe the answer is correct. Sometimes questions add çost minimization clause to confuse and distract from the main requirement. We need to maintain that first priority is always to meet the requirement and the cheapest option given may not be correct.
upvoted 2 times
...
mackc13
4 years, 10 months ago
given answer is correct as there is requirement for the application to access the data.
upvoted 1 times
...
tanito83
4 years, 11 months ago
The correct answer is B. Please, modify it.
upvoted 2 times
...
AZViewer
5 years ago
We cannot read data from secondary GRS unless it fails over, so i believe RA-GRS is the correct answer https://www.skylinesacademy.com/blog/2019/7/31/azure-storage-replication
upvoted 3 times
Yannor
4 years, 11 months ago
The specification doesn't ask for that. GRS is cheaper.
upvoted 1 times
...
...
RBa001
5 years, 1 month ago
The question says "Ensure Application is able to access" thus Option C is the correct option
upvoted 1 times
yemma
5 years, 1 month ago
The application is able to access the data using the primary replica. The data is replicated to the secondary and can be accessed using failover. GRS is cheaper then RA-GRS so the answer is GRS.
upvoted 4 times
...
...
ara321
5 years, 2 months ago
ANswer is C https://docs.microsoft.com/bs-latn-ba/azure/sql-database/sql-database-automated-backups?tabs=single-database
upvoted 2 times
...
Rajuuu
5 years, 2 months ago
C is the correct answer. RA-GRS is the cheapest option.
upvoted 1 times
mon_k
5 years, 1 month ago
Where did you see RA-GRS is cheaper than GRS??
upvoted 1 times
...
TYT
5 years ago
GRS is cheaper than RA-GRS.
upvoted 2 times
...
...
CipherK
5 years, 2 months ago
Both B and C fulfill the requirement of replicate data. But also require the minimum cost. Since GRS is cheaper than RA-GRS. Should choose B.
upvoted 6 times
[Removed]
5 years, 2 months ago
It doesn't say it needs data from the second region only during failure. so the answer is right i'd assume
upvoted 1 times
...
...
Prabby
5 years, 2 months ago
Tried the pricing calculator for Un-manged Page Blobs, RA-GRS is expensive than GRS. So I think correct answer is B.
upvoted 4 times
...
Daren
5 years, 2 months ago
Super obvious that the answer is B.
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel