What should you do?
You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) solution. The current reporting solution consists of a single computer that hosts both the Web server components and the database server components of SSRS. This computer is dedicated to the sales department. The company security policy requires a separate SSRS solution for the payroll department. There is no budget for any new hardware. You need to isolate the security models of each department without using separate Web servers or database servers. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. You are responsible for monitoring the performance of your SQL Server 2005 computers. You have a SQL Server Integration Services (SSIS) package that usually takes 10 minutes to run. Today, the package is taking more than one hour to run. You suspect memory is too low. You need to identify the problem. What should you do?
What should you do?
You administer a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You need to edit the items that are included within the <Extension> subelement of the <Render> element in the RSReportServer.config file so that all the reports render only to Microsoft Excel. What should you do?
What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. Your company is a large retail store chain with more than 500 outlets. Each retail store maintains its own SQL Server 2005 database that must replicate data to the corporate server each night. You need to monitor replication for each store. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
Which role should you assign to the group?
You are administering a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You need to assign a group of users a predefined security role that permits them to read all the report definitions. Which role should you assign to the group?
What should you do?
You are a database administrator for AIOTestKing.com. Users report that the performance of a SQL Server 2005 application seems slow. You verify that the SQL Server computers CPU utilization, disk utilization, and memory utilization are normal. You also verify that the network is operating normally. You need to examine more detailed performance information for the appropriate instance of SQL Server 2005. What should you do?
What should you do?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a machine named COMPANYCUBE for a SSAS instance. The COMPANYCUBE machine hosts a SSAS database that has a cube named HR. You need to restrict the local administrators from accessing any data stored in the HR cube. What should you do?
Which object_id and index_id combination should you use?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer. The performance of the server has degraded to a great extent over time. You are troubleshooting the indexing environment. You rebuild the clustered indexes that are used the most frequently. You want to optimize the most frequently accessed nonclustered index. You access the sys.dm_db_index_usage_stats dynamic management view (DMV). The results are shown in the following table.
You need to identify which nonclustered index is being used the most frequently when the entire index is not read. Which object_id and index_id combination should you use?
Which impersonation information should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution by using Business Intelligence Development Studio (BIDS). The SSAS instance runs under a local system account.
A trust relationship exists between the machine that hosts the SSAS instance and the data source. You need to use the Impersonation Information dialog box to create a data source that SSAS can connect to when SSAS is deployed from any workstation. Which impersonation information should you use?
What should you do?
You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do?