nerdexam
Microsoft

70-465 · Question #107

You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The Sales department uses a database named SalesDB. SalesDB…

The correct answer is C. By partitioning the Orders table. To improve performance for recent orders while allowing historical orders to use slower storage, the Orders table should be partitioned.

Submitted by femi9· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The Sales department uses a database named SalesDB. SalesDB contains a large table named Orders that lists every order ever received by the company. You want to improve the performance of SalesDB. You want to configure the database to provide the fastest possible access to the most recent orders. Historical orders can be stored using a slower storage solution. How can you achieve this goal?

Options

  • ABy configuring database mirroring.
  • BBy configuring a failover cluster.
  • CBy partitioning the Orders table.
  • DBy partitioning a partitioned view of the Orders table.

How the community answered

(48 responses)
  • A
    6% (3)
  • B
    17% (8)
  • C
    73% (35)
  • D
    4% (2)

Why each option

To improve performance for recent orders while allowing historical orders to use slower storage, the Orders table should be partitioned.

ABy configuring database mirroring.

Database mirroring provides high availability and disaster recovery for an entire database, but it does not offer the capability to segment a table's data across different storage tiers based on recency for performance optimization.

BBy configuring a failover cluster.

A failover cluster instance provides high availability at the SQL Server instance level, ensuring continuous operation in case of hardware failure, but it does not enable the placement of different parts of a table on different storage types to optimize query performance.

CBy partitioning the Orders table.Correct

Table partitioning allows a large table to be logically divided into smaller, more manageable units based on a partition function, such as a date range. This enables placing recent, frequently accessed data on high-performance storage while older, less frequently accessed data resides on slower, less expensive storage, directly addressing the requirement for fastest access to recent orders.

DBy partitioning a partitioned view of the Orders table.

Partitioning a view, specifically a federated partitioned view, is used to combine data from multiple member tables on different servers into a single logical table, which is a different scenario than splitting a single large table's data across storage tiers.

Concept tested: SQL Server Table Partitioning for Data Tiering

Source: https://learn.microsoft.com/en-us/sql/relational-databases/partitions/create-partitioned-tables-and-indexes?view=sql-server-2012

Topics

#Table partitioning#Performance optimization#Data management

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice