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 an Application Role for each tenant.
C.
Create a Schema for each tenant.
D.
Create a Synonym for each tenant.