You are designing a multi-tenant Windows Presentation Foundation (WPF) application that
will connect to a Microsoft SQL Server 2008 database. The WPF application will change the
structure of database tables and views at runtime based on the tenant’s configuration. The
WPF application must meet the following requirements: • Keep each tenant’s data separate.
• Allow changes to the structure of the tables and views for each tenant without interfering
with other tenants’ data. You need to recommend an approach for managing the database
structure. What should you recommend?

A.
Create a Partition Scheme for each tenant.

B.
Create a Synonym for each tenant.

C.
Create an Application Role for each tenant.

D.
Create a Schema for each tenant.

Explanation: