Azure DP 300 Part 1 Real Exam Questions

This is the part 1 of the video series covering some important questions for certification exams. It has detailed mechanism to arrive at the answer. Please focus on the concepts explained in the exam and you will surely pass the exam. The exam will have similar questions.

[@Deseeker1]

These training videos are splendid. I scored 862/1000 today following the guides here. I passed! Thank you very much.

[@cloudguruninja]

Congratulations

[@aadityaarunachalam22]

Thank you so much. But if possible can we not have the background music ? Or reduce it ?

[@7010d0]

Hello!
Regarding question 6, I believe that data flush interval is related to the interval of writes (flushes) from the collection buffer in memory to disk. Decreasing it would only make it flush more often. The read only state is caused by exhausting the amount of disk space allocated to query store, thus doubling the statistics collection interval would reduce the disk space usage.

[@starvosxant4348]

This is counterintuitive, yes, i know. But according to chatGPT, this is the right answer because it allows the query store to Manage better its resources. And not only chatGPT Said that, but also Phillip Burton, a teacher that has several courses on Microsoft SQL server.

[@user-ul6tf3dp9v]

Background music makes it very hard to understand. For those who have the same issue, just download the video and check some automated software to get subtitle out of video speech, then bind subtitles to the video and watch the video with subtitles

[@PeacefulSanatana]

Very good content, thanks for your efforts. However, the background music is not required.

[@wanderertechie]

Appreciate your efforts. Very nicely explained

[@andrewlesterthomas5581]

Are you sure about the DBCC DATABASE: that causes fragmentation.

[@samgreene7961]

Seems like a good video- you have put effort into the content and visuals, but the voice audio quality has lots of explosive air sounds - aka plosives. Try getting a usb mic to record these - it will be a big improvement. If you already have a mic, get a windsock or screen. Thank you for making these videos.

[@ifuekoeguasa331]

God bless you. Very helpful.

[@cloudguruninja]

Thank you Eguasa for your kindness and blessing.

[@dhruvitsoni4610]

I have one confusion in question number 7 . In most of the website it is showing answer 8 even if there is a 16 CPUs.

[@GermanCayoMorales]

In the best practices of sql server 2019, in the installation to create 8 datafiles for tempdb, then in the question 7, answer correct is 8, but by 1vcpu assigna 1 datafiles in the tempdb

[@alaashamaseen9996]

The number of files depends on the number of (logical) processors on the machine. As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical
processors. If the number of logical processors is greater than eight, use eight data files and then if contention continues, increase the number of data files by multiples of 4 until the contention is reduced to acceptable levels or make changes to the workload/code.

[@sonalpathak4338]

Thank you so much for this video can you please make videos on whole sylabus module wise. I cannot find any vidio or youtuber covering modules. P.s you are doing good job ❤️

[@sushantasaha4723]

Great explanation!

[@cloudguruninja]

Glad you think so!

[@s1krider855]

Good video and very bad music. Why there is music?

[@Nihdem]

Good video but the music is ruined in.

[@cloudguruninja]

sorry about the BGM

[@Nihdem]

@@cloudguruninja Thank you so much! I watched all 11 parts videos. I appreciate the time and effort you put into this. Thanks again!!! 👏

[@seintheinhtoo122]

is it still good for 2023 ?

[@cloudguruninja]

yes

[@josevilla6503]

This apply for 2022certification exam?

[@cloudguruninja]

yes

[@user-ox7py4fb9t]

Background music is really irritating