MCTS 70-451考试题库由我们专业IT认证讲师及产品专家精心打造，包括了当前最新的全真考试试题，全部附有正确答案。这门题库随着微软认证厂商对考题做出的变化而及时更新，覆盖率达96%以上，答案由多位专业资深讲师原版破解得出，正确率100%。确保考生能一次通过考试。
考试代号：70-451
认证名称：PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
版本号：V10.02
考题数量：116道
更新日期：2011-01-11
1. You are a database solutions architect. Your company plans to develop a solution by using a SQL Server 2008 instance.
The solution has the following business requirements:
Import data from various data sources such as Microsoft Office Excel, Microsoft SQL Server 2000,
Microsoft SQL Server 2005, and CSV files.
Profile the source data before it is imported.
Provide collaboration and offline capabilities to mobile users.
Allow mobile users to use heterogeneous data stores.
You need to configure the appropriate SQL Server components to accomplish the business requirements.
You want to achieve this goal by using the minimum amount of administrative effort.
Which two SQL Server components should you use? (Each correct answer presents part of the solution. Choose two.)
A. Analysis Services
B. Reporting Services
C. Integration Services
D. Notification Services
E. Microsoft Sync Framework
Answer: CE
2. You need to design a database solution that meets the following capabilities:
Executes SQL Server Integration Services (SSIS) packages
Executes Transact-SQL
Schedules tasks
Sends alerts
Which SQL Server component should you use?
A. Notification Services
B. Service Broker
C. SQL Mail
D. SQL Server Agent
Answer: D
3. You have a table in a database that contains 30 million rows.
You need to ensure that the table meets the following requirements:
Enables queries on all string values within the table
Enables queries to be returned by order of proximity
Minimizes the amount of time required to execute queries
What should you do?
A. Create a filtered index.
B. Create a clustered index.
C. Configure Service Broker.
D. Configure a Full-Text-Search.
Answer: D
4. You are a database developer. You plan to create a database by using SQL Server 2008.
The database will store information about students, teachers, classes, and rooms in a school. The database will be used by a scheduling application.
In the design plan, the following facts have to be considered:
Each teacher can teach one or more classes.
Each student can register for one or more classes.
Each class can be in one or more rooms.
Each room can host one or more classes.
You identify the following entities for the database design:
Students
Teachers
Classes
Rooms
ClassesStudents
ClassesTeachers
You need to design the database to ensure normalization.
What should you do?
A. ¡¤Add a new entity named TechersStudents.
¡¤Est abli sh ar el ati onshi p bet weent he Teacher s and St udent s entiti es by usi ngt he Teacher sSt udent s entity.
B. ¡¤Add a new entity named ClassesRooms
¡¤Establish a relationship between the Classes and Rooms entities by using the ClassesRoms entity.
C. ¡¤Add a new entity named TeachersRooms
¡¤Est abli sh a r el ati onshi p bet ween t he Teacher s and Roo ms entiti es by usi ng t he Teacher s Roo ms entity.
D. ¡¤Create a new entity named StudentsRooms
¡¤Establish a relationship between the Students an Rooms entities by using the StudentsRooms entity.
Answer: B
考生如需下载更多完整的题库，可登陆killtest题库网！
