exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 45 discussion

Actual exam question from Microsoft's AZ-305
Question #: 45
Topic #: 4
[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?

  • A. an Azure SQL Database elastic pool that uses active geo-replication
  • B. tables in an Azure Storage account that use geo-redundant storage (GRS)
  • C. tables in an Azure Storage account that use read-access geo-redundant storage (RA-GRS)
  • D. an Azure SQL database that uses active geo-replication
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
dubuser
Highly Voted 1 year, 10 months ago
Got this question in todays exam (29/01/23) Answered B Scored 903
upvoted 17 times
OPT_001122
1 year, 10 months ago
Thanks for the date
upvoted 2 times
...
...
Davin0406
Highly Voted 2 years, 1 month ago
Selected Answer: B
appeared in exam, 10/14/2022. I passed with 946/1000 and there were only 1~2 new questions but others were all from AZ-305 dump.
upvoted 16 times
Jacky_exam
1 year, 9 months ago
no need for AZ-304 dump ?
upvoted 2 times
...
...
Thanveer
Most Recent 4 days, 20 hours ago
Selected Answer: B
B. tables in an Azure Storage account that use geo-redundant storage (GRS)
upvoted 1 times
...
SeMo0o0o0o
3 weeks ago
Selected Answer: B
B is correct
upvoted 1 times
...
Lazylinux
7 months, 2 weeks ago
Selected Answer: B
I believe given answer B is correct Page blobs, which are optimized for random read/write operations, and which provide the ability to write to a range of bytes in a blob. Azure Table storage is a service that stores non-relational structured data (also known as structured NoSQL data) in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it's easy to adapt your data as the needs of your application evolve. Access to Table storage data is fast and cost-effective for many types of applications, and is typically lower in cost than traditional SQL for similar volumes of Follow on next =>
upvoted 2 times
Lazylinux
7 months, 2 weeks ago
data. You can use Table storage to store flexible datasets like user data for web applications, address books, device information, or other types of metadata your service requires. You can store any number of entities in a table, and a storage account may contain any number of tables, up to the capacity limit of the storage account. https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-overview Replication is for sure GRS and NOT RA-GRS as no mention of read ONLY and hence one can assume failover with write access
upvoted 2 times
...
...
JimmyYop
10 months, 2 weeks ago
appeared in Exam 01/2024
upvoted 5 times
...
hantolini
1 year, 3 months ago
Selected Answer: B
No need mentioned for Read Access on remote replica.
upvoted 3 times
...
NotMeAnyWay
1 year, 5 months ago
Selected Answer: B
The correct answer is B. Tables in an Azure Storage account that use Geo-redundant storage (GRS). Azure Table Storage offers NoSQL capabilities and provides a key-attribute store with a schema-less design. This makes it a good fit for hosting independent tables of varying sizes and usage patterns. Table Storage data is accessible via REST APIs, and GRS automatically replicates your data to a secondary region to protect against regional outages. As per the cost minimization requirement, GRS is cheaper than RA-GRS, and Azure Table Storage is generally more cost-effective than Azure SQL Database options.
upvoted 6 times
...
alexander_panfilenok
1 year, 5 months ago
I don't know why table storage is considered as correct. It does not provide flexibility of "usage pattern". There is only a primary key (partition key and row key).
upvoted 2 times
...
Sanjeevsn
1 year, 6 months ago
Selected Answer: C
C. Tables in an Azure Storage account that use read-access geo-redundant storage (RA-GRS). Explanation: Azure Storage tables provide REST-based access to data, which meets the requirement of accessing the data using a REST connection. Azure Storage tables can accommodate multiple tables of varying sizes and usage patterns. Read-access geo-redundant storage (RA-GRS) ensures automatic replication of data to a second Azure region, providing data redundancy and disaster recovery capabilities. Azure Storage tables are typically more cost-effective compared to Azure SQL Database, making it a suitable choice for minimizing costs. Option B (Tables in an Azure Storage account that use geo-redundant storage) is not the optimal choice as it does not provide read-access to the replicated data in the second Azure region, which is a requirement in this scenario.
upvoted 2 times
morito
1 year, 6 months ago
Read Access to the replica is not a requirement! Quite the opposite is the case. It asks for a backup, but with minimized costs, therefore RA-GRS does not meet the scope of the requirement.
upvoted 1 times
...
NotMeAnyWay
1 year, 5 months ago
RA-GRS is also more expensive than GRS.
upvoted 1 times
...
...
techrat
1 year, 7 months ago
Selected Answer: B
Passed exam today with 979, all questions were in this dump. My answer to this question on the exam was B
upvoted 5 times
...
zellck
1 year, 9 months ago
Selected Answer: B
B is the answer. https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-overview Azure Table storage is a service that stores non-relational structured data (also known as structured NoSQL data) in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it's easy to adapt your data as the needs of your application evolve. Access to Table storage data is fast and cost-effective for many types of applications, and is typically lower in cost than traditional SQL for similar volumes of data. https://learn.microsoft.com/en-us/azure/storage/common/storage-redundancy#geo-redundant-storage Geo-redundant storage (GRS) copies your data synchronously three times within a single physical location in the primary region using LRS. It then copies your data asynchronously to a single physical location in a secondary region that is hundreds of miles away from the primary region. GRS offers durability for storage resources of at least 99.99999999999999% (16 9's) over a given year.
upvoted 4 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: B
B. tables in an Azure Storage account that use geo-redundant storage (GRS)
upvoted 1 times
...
Born_Again
2 years ago
Selected Answer: B
: minimize cost GRS!
upvoted 1 times
...
DikSoft
2 years, 2 months ago
"20 independent tables of varying sizes and usage patterns" - why is it not an elastic pool ?
upvoted 2 times
Jeffab
2 years, 1 month ago
I'm a novice in this space, but as I understand, Elastic pools are used for SQL database. Azure Tables refer to NoSQL or structured, non-relational data. This may explain it https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-overview
upvoted 2 times
...
Snownoodles
2 years, 1 month ago
SQL DB(include elastic pool) doesn't support REST
upvoted 4 times
tfulanchan
1 year, 10 months ago
Confused here. https://learn.microsoft.com/en-us/rest/api/sql/
upvoted 1 times
...
...
...
jellybiscuit
2 years, 2 months ago
Selected Answer: B
B - tables in an Azure Storage account that use geo-redundant storage (GRS) GRS - read from the secondary only in the event of a failover is cheaper than RA GRS - read from the secondary at all times https://azure.microsoft.com/en-us/pricing/details/storage/tables/#pricing
upvoted 7 times
...
kay000001
2 years, 2 months ago
Selected Answer: B
B. tables in an Azure Storage account that use geo-redundant storage (GRS) - is correct. **Automatically replicates the data to a second Azure region - both GRS and RA-GRS do this, but GRS costs LESS than RA-GRS.
upvoted 3 times
...
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
Loading ...