Home » Microsoft » 70-765 » How should you complete the statement?
DRAG DROP
You have database that contains a 400-GB table that is read-only.
You need to enable the Stretch Database feature.
How should you complete the statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
To configure an existing table for Stretch Database, run the ALTER TABLE command.
Here’s an example that migrates the entire table and begins data migration immediately.
USE <Stretch-enabled database name>;
GO
ALTER TABLE <table name>
SET ( REMOTE_DATA_ARCHIVE = ON ( MIGRATION_STATE = OUTBOUND ) ) ;
GO
References: https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/enable-stretch-database-for-a-table