Exam AZ-301 All Questions

View all questions & answers for the AZ-301 exam

Exam AZ-301 topic 17 question 13 discussion

Actual exam question from Microsoft's AZ-301

Question #: 13
Topic #: 17

DRAG DROP -
You are designing a virtual machine that will run Microsoft SQL Server and will contain two data disks. The first data disk will store log files, and the second data disk will store data. Both disks are P40 managed disks.
You need to recommend a caching policy for each disk. The policy must provide the best overall performance for the virtual machine.
Which caching policy should you recommend for each disk? To answer, drag the appropriate policies to the correct disks. Each policy may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance

by Ekramy_Elnaggar at Jan. 16, 2020, 2:06 p.m.

Comments

Submit Cancel

Ekramy_Elnaggar

Highly Voted 5 years, 5 months ago

This is a repeated question: https://www.examtopics.com/exams/microsoft/az-301/view/65/

upvoted 20 times

JohnAvlakiotis

5 years, 4 months ago

I don't believe what you do, helps. The discussion should be only for the specific topic and not you being annoying in the process :)

upvoted 22 times

SilentH

5 years, 2 months ago

Disagree. Ekramy helps me not create duplicate flash cards.

upvoted 24 times

RStover

5 years, 1 month ago

He helps u becoz u do flash cards but doesnt help the rest. That is a selfish approach. He can still say it is a repeated question and still give the answers.

upvoted 5 times

SIDNEY1

5 years ago

And how is it selfish? Is he making $$ out of his comments? This is the wild internet dude, get over it, precious pansies!

upvoted 5 times

...

Load full discussion...

...

fitzer

5 years ago

https:// + www.examtopics.com/ + exams/ + microsoft/ + az-301/ + view/+ 65/ = 404

upvoted 5 times

smsulai

4 years, 10 months ago

when he says 65 means....u should view/13 [5 question per view so to reach 65..view/13]. Hope this helps

upvoted 1 times

...

SIDNEY1

5 years ago

He's a smart dude but uses his apparently actual name on this site. He's a premier support engineer at Microsoft. Microsoft condemns the use of sites like these. Someone emailed them yet? :D

upvoted 4 times

denkes

4 years, 10 months ago

He's seems to be since 05.2020 at Microsoft. So he shared his knowledge before starting at Microsoft. But good to know, from know on he's feedback here, counts double for me :)

upvoted 1 times

...

Test_Taker

4 years, 11 months ago

It definitely helps. There are conversations and points made across both question discussions that should be taken into account.

upvoted 3 times

...

RStover

5 years, 1 month ago

We know but also give the answer.

upvoted 2 times

SherryWamg

4 years, 12 months ago

The answers provided are correct, here is the explanation and supporting websites: Log: None—Log files have primarily write-heavy operations. Therefore, they do not benefit from the ReadOnly cache. https://docs.microsoft.com/en-us/azure/virtual-machines/windows/premium-storage-performance#disk-caching Data: readonly—If you have separate storage pools for the log and data files, enable read caching only on the storage pool for the data files. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices I hope this helps.

upvoted 8 times

unknown4noone

4 years, 11 months ago

As an example, you can apply these guidelines to SQL Server running on Premium Storage by doing the following, Configure "ReadOnly" cache on premium storage disks hosting data files. a. The fast reads from cache lower the SQL Server query time since data pages are retrieved much faster from the cache compared to directly from the data disks. b. Serving reads from cache, means there is additional Throughput available from premium data disks. SQL Server can use this additional Throughput towards retrieving more data pages and other operations like backup/restore, batch loads, and index rebuilds. Configure "None" cache on premium storage disks hosting the log files. a. Log files have primarily write-heavy operations. Therefore, they do not benefit from the ReadOnly cache.

upvoted 2 times

...

babacandy

Highly Voted 4 years, 11 months ago

Ekramy_Elnaggar is awesome. He can explain any of the Azure questions and provide correct answers. Seems he is one of the guys who has really handled production workloads on Azure.

upvoted 8 times

...

sanketshah

Most Recent 4 years, 5 months ago

given answer is correct

upvoted 2 times

...

jivom

4 years, 10 months ago

Configure host-cache as None for write-only and write-heavy disks. Configure host-cache as ReadOnly for read-only and read-write disks. Configure host-cache as ReadWrite only if your application properly handles writing cached data to persistent disks when needed.

upvoted 1 times

...

[Removed]

4 years, 10 months ago

The provided link explicitly states: Quote: "Use premium SSDs for the best price/performance advantages. Configure ReadOnly cache for data files and no cache for the log file."

upvoted 1 times

...

ArulLivingston

4 years, 11 months ago

from the link: Caching policy: Note the following recommendations for caching policy depending on your storage configuration. If you are using separate disks for data and log files, enable read caching on the data disks hosting your data files and TempDB data files. This can result in a significant performance benefit. Do not enable caching on the disk holding the log file as this causes a minor decrease in performance.

upvoted 2 times

...