MENU
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?
Suggested Answer: A
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
12 comments · newest first
LE
Lenna
12 months ago
sp_clean_db_free_space sounds interesting, but I’ve never tried it.
SE
Serina
1 year ago
Wait, does shrinking really help in the long run?
LA
Lauryn
1 year ago
I agree with Daisy, that’s what I usually use!
CH
Charlena
1 year ago
I think DBCC SHRINKFILE is better for specific files.
DA
Daisy
1 year ago
DBCC SHRINKDATABASE is the way to go!
MA
Marget
1 year 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.
VA
Vallie
1 year ago
DBCC SHRINKFILE sounds familiar for reducing file sizes, but I wonder if it applies to both data and log files equally.
MA
Mattie
1 year ago
I think sp_clean_db_free_space was mentioned in a practice question, but I can't recall what it specifically does.
PE
Peter
1 year 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.
LU
Luann
1 year 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.
IR
Irving
1 year 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.
JU
Judy
1 year 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.