Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-447
Title
: UPGRADE:MCDBA Skills to
MCITP DB Admin by Using
MS SQL 2005
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Case 1, Coho Vineyard & Winery
Questions
1. You are reviewing the code that is used to retrieve order data in the ASP.NET Web application.
You need to update the application to meet the security requirements.
What should you do?
A. Create a view to retrieve the order data, and replace the table name with the view name in the ASP.NET
code.
B. Create an HTTP endpoint that has BATCHES enabled, and modify the ASP.NET code to connect to the
HTTP endpoint.
C. Create a SQL Server login that has a complex password, and modify the ASP.NET code to connect by
using the SQL Server login.
D. Create a stored procedure to retrieve the order data, and modify the ASP.NET code to call the stored
procedure by using parameters.
Answer: D
2. You plan to create a unique nonclustered index on the CustomerID, LastName, and FirstName columns
of the CustomerData.Customers table in the CRM database. To aid in estimating the space requirements
for the index, you identify the following variables:
You need to identify the most significant additional variable that will increase the estimated index size.
Which additional variable should you identify?
A. current number of rows
B. null bitmap
C. fill factor
D. automatically generated uniqueifier value
Answer: C
3. You need to migrate the DeliveryVans, AirlinePreferences, and SeasonalContractors databases into
the data center.
What should you do?
A. Install a separate instance of SQL Server 2005 for each of the databases on a single server.
B. Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
C. Import the data from each of the databases into a single database in an instance of SQL Server 2005.
D. Install a default instance of SQL Server 2005 on three