Valid DP-300 Dumps shared by ExamDiscuss.com for Helping Passing DP-300 Exam! ExamDiscuss.com now offer the newest DP-300 exam dumps, the ExamDiscuss.com DP-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-300 dumps with Test Engine here:
You have the following Transact-SQL query. Which column returned by the query represents the free space in each file?
Correct Answer: C
Example: Free space for the file in the below query result set will be returned by the FreeSpaceMB column. SELECT DB_NAME() AS DbName, name AS FileName, type_desc, size/128.0 AS CurrentSizeMB, size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB FROM sys.database_files WHERE type IN (0,1); Reference: https://www.sqlshack.com/how-to-determine-free-space-and-file-size-for-sql-server-databases/