Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 8 Question 20 Discussion

You have an Azure SQL database named sqldb1.You need to minimize the amount of space by the data and log files of sqldb1.What should you run?
A) DBCC SHRINKDATABASE
B) sp_clean_db_free_space
C) sp_clean_db_file_free_space
D) DBCC SHRINKFILE

Microsoft DP-300 Exam - Topic 8 Question 20 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 20
Topic #: 8
[All DP-300 Questions]

You have an Azure SQL database named sqldb1.

You need to minimize the amount of space by the data and log files of sqldb1.

What should you run?

Show Suggested Answer Hide Answer
Suggested Answer: A

DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database.

Incorrect Answers:

D: To shrink one data or log file at a time for a specific database, execute the DBCC SHRINKFILE command.


https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql

by Staci at May 08, 2022, 12:36 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Lenna
10 months ago
sp_clean_db_free_space sounds interesting, but I’ve never tried it.
upvoted 0 times
...
Serina
10 months ago
Wait, does shrinking really help in the long run?
upvoted 0 times
...
Lauryn
11 months ago
I agree with Daisy, that’s what I usually use!
upvoted 0 times
...
Charlena
11 months ago
I think DBCC SHRINKFILE is better for specific files.
upvoted 0 times
...
Daisy
11 months ago
DBCC SHRINKDATABASE is the way to go!
upvoted 0 times
...
Marget
11 months ago
I feel like I might have seen sp_clean_db_file_free_space in a different context, but I can't remember how it relates to minimizing space.
upvoted 0 times
...
Vallie
11 months ago
DBCC SHRINKFILE sounds familiar for reducing file sizes, but I wonder if it applies to both data and log files equally.
upvoted 0 times
...
Mattie
11 months ago
I think sp_clean_db_free_space was mentioned in a practice question, but I can't recall what it specifically does.
upvoted 0 times
...
Peter
11 months ago
I remember we discussed DBCC SHRINKDATABASE in class, but I'm not sure if it's the best option for just the log files.
upvoted 0 times
...
Luann
11 months ago
A, Countermeasures, is the correct answer. It's the natural progression after establishing the specific risk points - you need to create the plans and strategies to address those risks.
upvoted 0 times
...
Irving
11 months ago
This one seems pretty straightforward. I'm pretty sure the Visual Experience Composer for assisted channels is the right choice for a voice assistant channel.
upvoted 0 times
...
Judy
11 months ago
Ah, this is a tricky one. I'm torn between B and D. I'll have to make an educated guess on this. Hopefully, I can narrow it down.
upvoted 0 times
...

Save Cancel