Prep and try our 70-450 valid and latest training questions & answers

Microsoft 70-450 Exam Overview:

Microsoft 70-450 Exam Syllabus Topics:

Microsoft PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu Sample Questions:

Question 1

Your SQL Server 2008 database contains two tables named Customer and Order inside the Sales schema.
The Sales schema is defined as follows:
It has a stored procedure named SetCustomerStatus that reads from Order and modifies Customer.
It is owned by a user named SalesUser.
Another user named MarketingUser wants to be able to call SetCustomerStatus and change the status of Customer.
You need to assign the least permissions necessary to MarketingUser.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Set only Take Ownership on Customer and Order.
B. Set only Execute on SetCustomerStatus.
C. Perform the following tasks: Set Select on Customer.
D. Perform the following tasks: Set Execute on SetCustomerStatus.

Question 2

Your organization has many servers that run SQL Server 2008.
You define a rule to ensure that all database servers have Database Mail disabled.
You need to be able to identify and resolve any violation of the rule by using the minimum amount of administrative effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Define a SQL Server policy and import it on each database server.
B. Define a maintenance plan on each database server.
C. Define a SQL job on each database server.
D. Define a scheduled task on each server.

Question 3

You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated.
You need to ensure the successful recovery of any single database from a catastrophic failure without requiring a backup data center in a different location.
Which three tasks should you include? (Each correct answer presents part of the solution. Choose three.)

A. Script SQL login accounts and credentials.
B. Maintain one list of all Windows logins and passwords.
C. Install all SQL Server instances on a failover cluster.
D. Store all backup media offsite.
E. Document the administrative processes and application access requirements.

Question 4

You are a professional level SQL Sever 2008 Database Administrator.
A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01.
There is a sales team in your company, and their task is to finish purchase orders for customer requests.
The sales team updates data regularly in a local database by utilizing their portable computers.
When the central site is connected by portable computers, a database named Sales will be synchronized
with
the local database. A duplication model will be created to duplicate the local database to the Sales
database.
The requirements listed below should be satisfied by the duplication model:
First, when the same data is updated by multiple users independently, there should be no data conflicts.
Secondly, sensitive data such as product price cannot be updated by the sales team.
Thirdly, the data should be synchronized by the sales team not only at scheduled times but also on demand.
The best model should be identified to have data duplicated, and you should be reduced the development efforts to the least.
Which action will you perform?

A. You should utilize snapshot duplication along with each portable computer that is set up as a subscriber.
B. You should utilize merge duplication along with each portable computer that is set up as a subscriber.
C. You should utilize transactional duplication along with each portable computer that is set up as a publisher.
D. You should utilize SQL Server Integration Services (SSIS) to promote the date modification and pull updates to the Sales database along with the SSIS packages, on demand.

Question 5

You are a professional level SQL Sever 2008 Database Administrator.
The security requirements should be designed for a new database application. A code segment is utilized by the application, and the code segment includes the following components:
A method that the registry is accessed on the SQL Server
A method that the file system is accessed on a network file server
A class definition that public static fields are utilized
SQL CLR integration is utilized by the code segment
The code segment is implemented as a single assembly.
Since you are the technical support, you are required to make sure that the application should be successfully deployed to the instance.
Which action will you perform?

A. All public static fields should be replaced with public fields.
B. All public static fields should be utilized with public static read-only fields. And then the assembly should be registered by utilizing the regasm.exe utility before deployment.
C. The SAFE code access security should be utilized for the assembly.
D. All public static fields should be replaced with public static read-only fields. And then the EXTERNAL_ACCESS code access security should be utilized for the assembly.

Solutions: