Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-441
Title
: Designing Database
Solutions by Using MS SQL
Serv 2005
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. You need to design a solution for deploying the database to new stores as they are opened. Your solution
must minimize the number of steps that are required to make the database ready for use in the production
environment.
What should you do?
A. Replicate the database schema and all lookup data from an existing server to new servers.
B. Detach the database on an existing server, copy the database files to new servers, and attach the copies
on the new servers. Reattach the database on the existing server.
C. Use SQL Server Integration Services (SSIS) to copy the entire database from an existing server to new
servers.
D. Back up the database on an existing server, and restore the backup to new servers.
Answer: A
2. You need to design a solution for controlling changes to database objects on the SQL Server database
servers. Your solution must comply with existing company policies and procedures.
What should you do?
A. Require developers to check in all code changes to a source control database.
B. Create a single database user account that has permission to change database objects.
C. Give one developer permissions to change database objects, and enable logging of those changes on
the server.
D. Disable replication of database objects between servers.
Answer: B
3. You need to ensure that the XML data that is exported to distributors can be reviewed for accuracy at any
time. Your solution must create a minimal amount of additional data.
What should you do?
A. Create a stored procedure that generates the XML data, and rerun the stored procedure when the XML
data needs to be reviewed.
B. Create a SQL Server Integration Services (SSIS) package that generates the XML data, and rerun the
package when the XML data needs to