Microsoft Certified Azure Database Administrator Associate · Free Practice Question Hard
Question 10
For a large-scale web application with a database containing a multi-terabyte dataset, which partitioning solution would be MOST appropriate to ensure scalability and manageability?
- A Row-based partitioning
- B Range partitioning on date columns
- C List partitioning
- D Hash partitioning
Reveal correct answer
Correct answer: B
Explanation
Range partitioning, especially on date columns, is commonly used for large datasets to enable efficient data loading, querying, and archiving. Reference: https://docs.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexesDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
