70-465 Question #53: Real Exam Question with Answer & Explanation

Question

You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort. What should you include in the recommendation?

Options

• AIndexed views
• BFilegroups
• CTable partitioning
• DIndexes

Explanation

To address a backup issue with minimal development effort, Filegroups allow selective backup and restore of specific portions of a database, providing granular control without requiring significant code changes.

Common mistakes.

• A. Indexed views are precomputed result sets stored as physical data used to improve query performance, and they have no direct capability to address backup or restore challenges.
• C. Table partitioning divides large tables into smaller segments for manageability and performance, but it does not directly provide a mechanism for selective or optimized backups without additional configuration and development work.
• D. Indexes are data structures that improve query performance by enabling faster data retrieval, and they have no functionality related to backup strategies or resolving backup issues.

Concept tested. SQL Server filegroups for selective database backup

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-files-and-filegroups-sql-server

No community discussion yet for this question.