Question
Why might SQL Server warehouse partitions be placed on different filegroups?
Select an option. Your answer will be checked instantly.
Correct Answer: D. To support storage management, backup strategies, and partition administration
Explanation:
Filegroups map database objects to sets of physical files.
They can separate hot and cold data and support piecemeal operational strategies.
Leave a Reply