We're so confident of our products that we provide no hassle product exchange.
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
1. DRAG DROP
You need to recommend a backup process for data warehouse database.
The solution must meet the following requirements:
- Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions. - Minimize the amount of administrative effort required to restore any lost data. - Minimize the space used by transaction logs.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
2. You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
- The database schemas must be synchronized from SQLDev to SQLProd. - The database on SQLDev must be deployed to SQLProd by using a package. - The package must support being deployed to SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A) a data-tier application
B) SQL Server Integration Services (SSIS)
C) change data capture
D) a database snapshot
E) SQL Data Sync
3. You need to configure security on the Product table for customer support representatives.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.
A) Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice.
B) Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice.
C) Create a view called CustProduct that includes columns ProductID. ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierID.
D) GRANT SELECT on CustProduct TO OurDomain\CustomerSupport.
E) GRANT SELECT on CustProduct TO public.
F) GRANT ALL on CustProduct TO OurDomain\CustomerSupport
4. You need to recommend an isolation level for usp_UpdateOrderDetails.
Which isolation level should recommend?
A) repeatable read
B) read committed
C) serializable
D) read uncommitted
5. You need to recommend a disk monitoring solution that meets the business requirements.
What should you include in the recommendation?
A) an audit
B) a SQL Server Agent alert
C) a dynamic management view
D) a maintenance plan
Solutions:
| Question # 1 Answer: Only visible for members | Question # 2 Answer: B | Question # 3 Answer: C,D | Question # 4 Answer: A | Question # 5 Answer: C |
By Jesse
