Microsoft
70-451 · Question #1
70-451 Question #1: Real Exam Question with Answer & Explanation
The correct answer is D. Design a conceptual Entity Data Model that contains an entity named EMPLOYEE_ADDRESS.. See the full explanation below for the reasoning.
Question
You are a database developer. You develop a database application for a SQL Server 2008 instance. The instance hosts a third-party database. You are not allowed to modify the database schema. The database contains two tables that are as shown in the following diagram. You plan to extract address information about full-time employees based on the FullTimeIndicator flag. You need to design a data access layer to simplify the extraction process. What should you do?
Exhibit
Options
- ADesign an Entity Data Model that contains the EMPLOYEES and ADDRESS entities.
- BCreate a view on the database to include full-time employees and their address details.
- CRe-design the underlying database model to include employee and address information in one
- DDesign a conceptual Entity Data Model that contains an entity named EMPLOYEE_ADDRESS.
Community Discussion
No community discussion yet for this question.