QUESTION 51
You are configuring a new SQL Server installation.
The SQL Server instance will be used for both online analytical processing (OLAP) and relational data. The data in the server is accessed frequently. You can configure the services, startup type, and accounts used by the services that run on the server according to the following table:
You want to raise the level of security on the server. You need to minimize the surface area for potential attacks on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Change the Startup type property for all the services to Manual.
B. Change the Startup type property for all the services to Disabled.
C. Create a single non-administrative local user account and assign it to each of the services.
D. Create three different non-administrative local user accounts and assign them to each of the services.
Answer: D
QUESTION 52
You administer a SQL Server 2008 instance that will host a new database application.
You plan to design the security requirements for the application. Each application user has a unique login to the SQL Server 2008 server. The application database contains stored procedures to execute stored procedures in the MSDB database. The stored procedures in the MSDB database schedule SQLAgent jobs.
You need to ensure that the stored procedures in the MSDB database are executed by using the security context of the application user.
What should you do?
A. Add each user to the public role in the MSDB database.
B. Add each user to the db_dtsltduser database role in the MSDB database.
C. Configure the new database to use the TRUSTWORTHY option, and then add each user to the MSDB
database.
D. Configure the MSDB database to use the TRUSTWORTHY option, and then add each user to the MSDB
database.
Answer: C
QUESTION 53
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 permission necessary to MarketingUser.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Set only Execute on SetCustomerStatus.
B. Set only Take Ownership on ustomer and Order.
C. Perform the following tasks:
* Set Select on Customer.
* Set Update on Order.
D. Perform the following tasks:
* Set Execute on SetCustomerStatus.
* Set Select on Customer.
* Set Update on Order.
Answer: A
QUESTION 54
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 Execute on SetCustomerStatus.
B. Set only Take Ownership on Customer and Order.
C. Perform the following tasks: Set Select on Customer.
D. Perform the following tasks: Set Execute on SetCustomerStatus.
Answer: A
QUESTION 55
You administer a SQL Server 2008 instance. You plan to deploy multiple databases to the instance. You design the security policy for the instance.
A stored procedure verifies the partition compression settings on each database deployed to the instance. You plan to use a policy to execute the stored procedure. You need to ensure that the policy is enforced by using Policy-Based Management Framework. What should you do?
A. Enable the nested triggers server configuration option.
B. Grant EXECUTE permissions on the stored procedure to the SQLAgent service account.
C. Grant EXECUTE permissions on the stored procedure to the ##MS_PolicyTsqlExecutionLogin## login.
D. Grant EXECUTE permissions on the stored procedure to the ##MS_PolicyEventProcessingLogin## login.
Answer: C
QUESTION 56
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 scheduled task on each server.
B. Define a SQL job on each database server.
C. Define a maintenance plan on each database server.
D. Define a SQL Server policy and import it on each database server.
Answer: D
QUESTION 57
You are designing a database solution by using SQL Server 2008.
The database has a large number of tables that have columns that contain sensitive data. The sensitive data must be protected.
You need to choose an encryption strategy that has the minimum effect on the performance of the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use Bitlocker Encryption.
B. Use Cell-Level Encryption.
C. Use Encrypting File System.
D. Use Transparent Data Encryption (TDE).
Answer: D
QUESTION 58
You administer SQL Server 2008 servers on a single site.
The site contains the following two SQL Server 2008 instances:
* An Enterprise Edition server on a server that has a redundant array of independent disks (RAID) 10 disk system
* A Standard Edition server on a server that has a RAID 5 disk system
Each instance hosts a single application. You need to recommend a high-availability solution for the site to meet the following business requirements:
* The solution can be implemented on the existing systems.
* The database is available with minimal downtime.
* Data loss is minimal.
* There is minimal effect on the existing system.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
A. Replication
B. Log shipping
C. Failover clustering
D. Database snapshot
Answer: AB
QUESTION 59
You are a professional level SQL Sever 2008 Database Administrator.
An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance. The performance of the instance should be optimized.
Which action will you perform to accomplish the goal?
A. To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.
B. To accomplish the goal, the Resource Governor should be configured.
C. To accomplish the goal, the Windows System Resource Manager should be configured.
D. To accomplish the goal, an increase should be configured in the maximum degree of parallelism option.
Answer: A
QUESTION 60
You are a professional level SQL Sever 2008 Database Administrator.
A database is included by the instance, and a table named EmployeeData is contained by the database.
There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are stored in the column.
The space utilized by the Profile column should be cut to the least. In addition, a reasonable performance should be maintained to retrieve the content of the column.
Which action will you perform?
A. ROW compression should be utilized for the EmployeeData table.
B. The Profile column should be stored by utilizing filestream storage, and the NTFS file system compression
should be utilized.
C. PAGE LEVEL compression should be utilized for the EmployeeData table.
D. The Profile column should be implemented as a CLR user-defined type.
Answer: B
If you want to pass Microsoft 70-450 successfully, donot missing to read latest lead2pass Microsoft 70-450 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.
