Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-451
Title
: PRO:MS SQL Serv 2008,
Design & Optimizing DB
Admin Solution
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. You work in an International company named TAKEEEN. And you're in charge of the database of your
company. You use SQL Server 2008 to create a solution. You intend to import data from an external source
into a table. You must make sure that the tasks below are achieved:
The rows that fail the foreign key constraints during import are inserted into a separate table. Even if the
import encounters rows that fail foreign key constraints, it is successfully completed.
So what should you do?
A. An AFTER trigger has to be used
B. CHECK constraints have to be used
C. An INSTEAD OF trigger has to be used
D. During the import process disable the foreign keys.
Answer: C
2. You work in an International company named TAKEEEN. And you're in charge of the database of your
company. There is a SQL Server 2008 instance which hosts a third-party database. A database application
is developed for the instance. You have no permissions to modify the database schema.
The database contains two tables that are as shown in the diagram above. On the basis of
FullTimeIndicator flag, you intend to extract address information about full-time employees. In order to
simplify the extraction process, you have to design a data access layer. So what should you do?
A. You should design an Entity Data Model. The EMPLOYEES and ADDRESS entities are contained in this
Model
B. On the database, you should create a view. Full-time employees and their address details are included in
it
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
C. You should re-design the underlying database model. Employee and address information are included in
one table
D. You should design a conceptual Entity Data Model. An enti