Exam 70-764 topic 1 question 55 discussion

Actual exam question from Microsoft's 70-764

Question #: 55
Topic #: 1

HOTSPOT -
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instanced. The environments host several customer databases.
You host a local database and a Stretch database that has a table named Members for one specific customer.
You need to provide the customer with information about the space used in the databases.
In the table below, identify the query that provides the required information for each database.
NOTE: Make only one selection in each column.
Hot Area:

Show Suggested Answer

Suggested Answer:

by TheSwedishGuy at Jan. 24, 2020, 12:57 p.m.

Comments

Submit Cancel

dxico

4 years, 5 months ago

local database -> EXEC sp_spaceused @updateusage = N'TRUE'; strecht database -> EXEC sp_spaceused N'Company.Members', @mode = 'REMOTE_ONLY' https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-spaceused-transact-sql?view=sql-server-ver15#b-displaying-updated-space-information-about-a-database

upvoted 2 times

...

TheSwedishGuy

5 years, 4 months ago

Running sp_spaceused with the @updateusage = 'true' parameter tells the sp_spaceused procedure to update space allocation information prior to reporting on the space allocation

upvoted 2 times

...

TheSwedishGuy

5 years, 5 months ago

Stretch Database migrates your cold data transparently and securely to the Microsoft Azure cloud.

upvoted 3 times

TheSwedishGuy

5 years, 4 months ago

Cold data refers to data that is infrequently accessed, as compared to hot data that is frequently accessed.

upvoted 3 times

...

TheSwedishGuy

5 years, 5 months ago

sp_spaceused displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database. The Mode REMOTE_ONLY returns the storage statistics of only the remote portion of the object or database (i.e. the stretch database)

upvoted 3 times

...