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. Reference: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql
I agree on this, because SHRINKFILE provides more control, but here question asks for Data and Logs files not a single or set of files. So Better to use SHRINKDATABASE, run and prepare coffee and enjoy the wait.
For an Azure SQL database, it's generally not recommended to use DBCC SHRINKDATABASE (option A) as it can cause performance issues and should only be used as a last resort. Instead, DBCC SHRINKFILE (option D) is the preferred option to minimize the amount of space used by the data and log files of an Azure SQL database.
DBCC SHRINKDATABASE shrinks all data and log files in a database using a single command. The command shrinks one data file at a time, which can take a long time for larger databases. It also shrinks the log file, which is usually unnecessary because Azure SQL Database shrinks log files automatically as needed.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Geese_Howard
Highly Voted 4 years, 2 months agoSr18
10 months, 1 week agoyuck
Highly Voted 4 years, 2 months agokkkiet
Most Recent 2 years, 2 months agolouisaok
2 years, 3 months ago