Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 (2) Set 3

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which is one of three servers in a peer-to-peer transactional replication topology. The publication has a table called SRB which contains 220 GB of data across multiple partitions. Regularly 12 GB of data is loaded to the SRB tableby a batch process. You have to reduce the latency by developing a replication strategy. So what should you do?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance. A management data warehouse uses the data collector to collect performance data. You intend to maintain the management data warehouse. You have 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 are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. And the Funds database is being used in single-user mode. The backup strategy for the Finance database meets the following two requirements: 1. At 09:00 every day, full database backup to a file called funds.bak is performed. 2. Since 09:15 every day, a transaction log backup to a file named funds_HHMM.trn is performed every 15 minutes. A user came to report that a query deleted some important data by accident. The query was executed at 09:24. You are asked to recover the database to its original state. So which Transact-SQL statement(s) should you use to achieve this?

You are the administrator of your company network. And you're in charge of a SQL Server 2008 infrastructure. Now you are assigned a task to enforce naming standards for the database objects, so you have to design a solution to achieve this while using as little programming and administrative efforts as possible. So what should you do?