70-518 · Question #69
You are designing an n-tier solution that includes a Windows Presentation Foundation (WPF) client application. The WPF application connects to a middle-tier server that runs the data access layer…
The correct answer is C. Create a data access layer class that uses a database factory class to access all databases. See the full explanation below for the reasoning.
Question
You are designing an n-tier solution that includes a Windows Presentation Foundation (WPF) client application. The WPF application connects to a middle-tier server that runs the data access layer. The data access layer connects to a Microsoft SQL Server 2008 database and to a mainframe- based database. The mainframe-based database will be replaced in one year. You have the following requirements:
- Centrally manage all database connections.
- Minimize changes to the code base when the database is replaced.
- Ensure that the WPF application will not need to be redeployed when
the database is replaced. You need to recommend an approach for designing the data access layer. What should you recommend?
Options
- ACreate a data access layer class that uses a database factory class to access all databases.
- BAdd the connection string information for the databases to the configuration file for the WPF
- CCreate a data access layer class that uses a database factory class to access all databases.
- DAdd the connection string information for the databases to the configuration file for the WPF
How the community answered
(24 responses)- A8% (2)
- B4% (1)
- C71% (17)
- D17% (4)
Community Discussion
No community discussion yet for this question.