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?

Question

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?

Accepted Answer

C. Create a Schema for each tenant.

Answer

A. Create a Partition Scheme for each tenant.

Answer

B. Create an Application Role for each tenant.

Answer

D. Create a Synonym for each tenant.

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…

Question

Options

How the community answered

Community Discussion