Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
The report must meet the following specifications:
When the report is run from a Helpdesk application, the report toolbar must not be displayed. When the report is run from an Intranet Portal application, the report toolbar must display the list of parameters only on the request of the user.
You need to provide the report URL for each application.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are a database administrator for AIOTestKing.com. Each night, you perform full backups of your SQL Server 2005 computer. During business hours, you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report dataset consists of a WHERE clause: WHERE machineID IN (@machineID). The values in the machineID column change constantly. When the report is run, users must be prompted to use a list of valid values for the @machineID parameter. When the report is run, a list of valid values for the @machineID parameter must be made available to populate the @machineID dataset parameter. You need to create a Multi-value report parameter that will meet the requirement. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. A company vendor provides product inventory data by using a Web service. Your company needs to create several reports based on this data. You need to ensure that the reports have access to the necessary data.
Your solution must provide the best reporting performance. What should you do?
What should you do?
You have designed and saved 35 Microsoft SQL Server 2005 Integration Services (SSIS) packages.
The packages are stored in a single folder on the network. All the team members can view the packages but not the property values. You need to ensure that the property values are password protected. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. You are configuring a linked server named AIOTestKing 2 on a local server named AIOTestKing 1. You need to configure the options so that any administrator who is a member of the LocalDBAdmins group can connect to the linked server by using the remote logon of DBAdmin with a password of DBAdmin!1. All other users should be able to connect by using the remote logon of Guest with a password of Guest!1. What should you do? To answer, drag the appropriate security group, login, or password to the correct location or locations in the answer area.
Which property should you use?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. A task processes rows of data from a table in the package. You decide to log the number of processed rows to Windows Event Log. You need to set a logging property on the task to ensure that the number of processed rows is logged each time the package runs. Which property should you use?
Which Transact-SQL script should you use?
You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer named AIOTestKingA. AIOTestKing A runs SQL Server 2005 and is a member of a Microsoft Active Directory domain named Contoso.com. The domain is configured with all of the default settings. Several members of the information security team have requested access to AIOTestKingA. The information security team uses the Microsoft Windows XP Professional, Linux, and Macintosh operating systems to perform vulnerability assessments. The information security team members ask you to create two new logon accounts for their use. They would like the logon accounts to have the following user names and passwords: User name\password for first account:
pentest\P@ssw0rdUser name\password for second account: hacktest\password You need to provide the information security team with the requested access to AIOTestKing A.
Which Transact-SQL script should you use?
Which two actions should you perform?
You create a Microsoft SQL Server 2005 Integration Services (SSIS) project by using Business Intelligence Development Studio (BIDS). The project contains 75 SSIS packages stored in the file system that perform various maintenance tasks. The SSIS packages must be available to the Quality Assurance (QA) team to test the packages on the test server. You need to create a package deployment utility that allows the QA team to deploy each of these packages on the test server. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are a database administrator for AIOTestKing.com. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19:00 and 04:00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do?