Exam AZ-204 All Questions

View all questions & answers for the AZ-204 exam

Exam AZ-204 topic 5 question 3 discussion

Actual exam question from Microsoft's AZ-204

Question #: 3
Topic #: 5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You are developing and deploying several ASP.NET web applications to Azure App Service. You plan to save session state information and HTML output.
You must use a storage mechanism with the following requirements:
✑ Share session state across all ASP.NET web applications.
✑ Support controlled, concurrent access to the same session state data for multiple readers and a single writer.
✑ Save full HTTP responses for concurrent requests.
You need to store the information.
Proposed Solution: Deploy and configure an Azure Database for PostgreSQL. Update the web applications.
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by necate2359 at Oct. 15, 2020, 11:22 a.m.

Comments

Submit Cancel

profesorklaus

Highly Voted 4 years, 4 months ago

The worst solution from a performance and scalability standpoint is to use a database backed session state provider. https://docs.microsoft.com/en-us/azure/azure-cache-for-redis/cache-aspnet-session-state-provider

upvoted 27 times

ferut

4 years ago

Although Postgres will lack the performance compared to Redis, the solution will work. Any thought?

upvoted 8 times

lugospod

3 years, 4 months ago

https://docs.microsoft.com/en-us/azure/azure-cache-for-redis/cache-aspnet-session-state-provider Postgresql is not listed as viable option on MS site. So I guess this is why it is not acceptable.

upvoted 8 times

...

warchoon

2 years, 3 months ago

maybe worst but exists https://learn.microsoft.com/en-us/previous-versions/aspnet/ms178587(v=vs.100)

upvoted 2 times

...

venki21

Highly Voted 4 years, 6 months ago

But the question says, does it meet the goal? So using a postgres db to save the session does meet the goal. Any thoughts on this

upvoted 22 times

Stel0Papad4

1 year ago

I think Microsoft doesn't care if a solution meets the minimum of the goal, even if they say "if it meets the goal". They need to enforce you their ways. Microsoft is the only way towards to greatness!

upvoted 1 times

...

ML333

2 years, 11 months ago

Another brilliantly worded and completely unambiguous question, LOL, thanks MS! Questions should be clear (like is this a best practice or a recommended approach), because the question "does it meet the goal" is it does... but should you do this? ever? Never!

upvoted 6 times

SaneSage123

1 year, 10 months ago

10000%

upvoted 2 times

...

Pooochie

4 years, 2 months ago

Got a simmilar question on udemy, where both soultions were marked as correct. Redis and Postgress

upvoted 8 times

...

Cornholioz

4 years, 6 months ago

It will meet the goal, but my take is that it is a huge Overkill to introduce PostgreSQL.

upvoted 3 times

matejka

4 years, 4 months ago

I think that it would be better to provide four options and you should pick the best one rather than four questions with YES/NO answers as there is no chance to review the futher options (further questions).

upvoted 4 times

...

Load full discussion...

...

overhill

Most Recent 7 months ago

I redo my Answer, it's a no. Session State across multiple ASP.NET applications would be implemented through distributed cache and Postgres is not one of the supported options. You can do it by hand and on your own but it doesn't seem that's what Microsoft wants.. So the answer is yes but NO.

upvoted 1 times

...

overhill

7 months ago

It's not ideal but it meets the goal

upvoted 1 times

...

Mattt

7 months, 1 week ago

Selected Answer: A

It meet the goal. But is not optimal. The answer is yes

upvoted 1 times

overhill

7 months ago

I agree

upvoted 2 times

...

FeriAZ

1 year, 4 months ago

Selected Answer: B

Share Session State Across Applications: While PostgreSQL can store session state, sharing session state across multiple ASP.NET applications is not its primary use case. It requires additional configuration and programming to handle session state management. Controlled, Concurrent Access for Multiple Readers and a Single Writer: PostgreSQL supports concurrent access, but managing this for session state data would require additional programming effort. Save Full HTTP Responses for Concurrent Requests: PostgreSQL is not designed for caching full HTTP responses. It is primarily a relational database for structured data, not a cache for HTTP responses.

upvoted 1 times

...

dom271219

1 year, 8 months ago

B. No why they would choose this DB while Microsoft sells Sql DB?

upvoted 1 times

...

75daltonic

1 year, 10 months ago

Selected Answer: B

I think No. The question says: Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. There are three questions in examtopics about this: 1-Enable Application Request Routing (ARR). 2-Deploy and configure an Azure Database for PostgreSQL. Update the web applications. 3-Deploy and configure Azure Cache for Redis. Update the web applications. And only one is the solution in order to the note at the beginning, so the best answer is Redis.

upvoted 9 times

ay_m

1 year, 9 months ago

Thanks for summing them up!

upvoted 3 times

...

JH81

1 year, 11 months ago

Selected Answer: B

MS is looking for Redis as the answer.

upvoted 1 times

...

thebarber87

2 years, 1 month ago

Selected Answer: B

No - not best for the goal

upvoted 2 times

...

JamieS

2 years, 2 months ago

I'd do A, but B would work. Potentially poorly worded question if they want you to pick the best option.

upvoted 1 times

...

warchoon

2 years, 3 months ago

ASP.NET session state is designed to enable you to store user session data in different sources. By default, session state values and information are stored in memory ... Another alternative is to store session data in a SQL Server database, where it can be shared by multiple Web servers. Reference: https://learn.microsoft.com/en-us/previous-versions/aspnet/ms178587(v=vs.100)

upvoted 1 times

warchoon

2 years, 3 months ago

=> https://www.codeproject.com/Articles/18456/Sample-Session-Providers-with-PostgreSQL

upvoted 1 times

...

alexein74

2 years, 4 months ago

Selected Answer: B

B. No An Azure Database for PostgreSQL is a fully-managed relational database service based on the PostgreSQL open-source database engine, it can be used to store data, but it's not designed to store session state information or HTML output, it will not meet the requirements of sharing session state across all ASP.NET web applications, support controlled, concurrent access to the same session state data for multiple readers and a single writer, or save full HTTP responses for concurrent requests.

upvoted 3 times

...

rotimislaw

2 years, 5 months ago

Selected Answer: B

The question description says "unique solution" so I'd say Redis is better and here the answer is B. NO

upvoted 2 times

...

mitu7

2 years, 5 months ago

Selected Answer: B

Azure Database for PostgreSQL is a managed database service that can be used to store and retrieve data, but it is not designed for storing and managing session state information or HTML output. It does not provide the necessary features and capabilities to share session state across multiple web applications or support concurrent access to session state data.

upvoted 2 times

...

hubekpeter

2 years, 6 months ago

Selected Answer: A

Yes, we used to do it that way when redis/memcached key value in memory store wasn't available.

upvoted 1 times

...

OPT_001122

2 years, 7 months ago

Selected Answer: B

No - redis cache is the correct ans

upvoted 4 times

...

Load full discussion...