Microsoft-TS Microsoft SQL Server 2008 - Implementation and Maintenance Set 2

You plan to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance. You need to ensure that both database instances are available for their applications. Your solution must meet the following requirements: Minimize administrative effort. Prevent changes to the existing application environments. What should you do?

You administer a SQL Server 2008 instance. A stored procedure is used as the data source for a report that is frequently executed during business hours. Users report that the data returned by the report is inconsistent. You discover that the inconsistencies are caused by phantom reads. You need to ensure that the report returns consistent results without affecting other users. What should you do?

You maintain a default SQL Server 2008 instance. You plan to configure FILESTREAM data to meet the following requirements: Enable FILESTREAM for file I/O streaming access. Allow remote client computers to have streaming access to FILESTREAM data. You need to ensure that FILESTREAM data is enabled. What should you do?

You maintain a SQL Server 2008 instance. You plan to deploy an instance of SQL Server Reporting Services (SSRS) to the same machine. You need to ensure that by default, SSRS maintains version histories of all deployed reports. What should you do?

You manage a SQL Server 2008 instance. You plan to maintain a management data warehouse that collects performance data by using the data collector. You need to implement a process that routinely gathers and uploads data in the management data warehouse on different schedules. What data collection process should you implement?

You manage several SQL Server 2008 instances. You plan to collect performance data periodically on all instances by using the data collector. All collected data must be stored in the same database hosted on a single instance. You need to collect and load performance data in the management data warehouse every 6 hours. Which data collection process should you implement?

You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database has a table named Products that stores information about all types of products. Users frequently query the Products table based on the TelevisionSize column. The TelevisionSize column has the NULL value for all products other than Televisions. There is currently no index on the TelevisionSize column. You need to improve the query performance by ensuring that the effect on the disk space is minimized. What should you do?

You administer a SQL Server 2008 instance. You have a stored procedure that implements a database maintenance process. You need to create a SQL Server Agent job that runs the stored procedure. You also need to ensure that the job is removed after successful completion. What should you do?

You administer a SQL Server 2008 instance. The security policy permits members of a Windows group named CONTOSO\Sales to establish new connections to the SQL Server instance only during business hours between 07:00 hours and 19:00 hours. Other users may connect to the SQL Server instance any time. You write the following Transact-SQL statements. CREATE TABLE Security.RestrictedLogonHours ( Id int NOT NULL IDENTITY(1,1), GroupName sysname NOT NULL, RestrictedTimeStart time NOT NULL, RestrictedTimeStop time NOT NULL, CONSTRAINT RestrictedLogonHours_pk PRIMARY KEY CLUSTERED(Id) ); INSERT INTO Security.RestrictedLogonHours ( GroupName, RestrictedTimeStart, RestrictedTimeStop ) VALUES ( 'CONTOSO\Sales', Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-432 CAST('07:00' AS time), CAST('19:00' AS time) ); You need to implement the company security policy that is stored in the RestrictedLogonHours table. What should you do?

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains the OrderHistory table. The OrderHistory table is partitioned on the OrderId column. The first partition contains integer values between 1 and 100,000. The second partition contains integer values greater than 100,000. You need to add a new partition that contains integer values greater than 200,000. What should you do?