You are a database administrator for AIOTestKing.com. A database named OLTP_Report makes data available to Reporting Services reports. You use Reporting Services to create a report named SalesDeviation, which displays sales goals and sales representatives’ actual sales. You need to manage report subscriptions. All sales representatives located in the Windows Sales group who do not meet sales goals must automatically receive a SalesDeviation report every Monday morning. What should you do?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You are a database administrator for AIOTestKing.com. Developers need access to create, alter, and drop tables in your SQL Server 2005 database. A list of production tables is maintained in a table named Valid_Production_Tables in the database. You need to be able to automatically roll back any commands that drop or alter current production tables.
You need to do this while minimizing the processor resources being used. What should you do?

You are a database administrator for an electronics distribution company. You are documenting your company’s requirements for data quality. You need this information so that you can store part numbers, components, and stock levels from your company’s trading partners in your SQL Server 2005 environment. You need to determine the standards for data quality. You need to consult with the business analysts and other database administrators (DBAs) in your organization to do so. What are three possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose three.)

You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema, application roles, and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been granted membership in the local Administrators group on AIOTestKing A. You perform most of the management of AIOTestKing A from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to AIOTestKing A. What should you do?

You are a database administrator for AIOTestKing.com. You are responsible for managing 10 SQL Server 2005 computers that run Microsoft Windows Server 2003, Enterprise Edition. The company’s Microsoft Active Directory administrators handle all Group Policy object (GPO) deployments. The Active Directory administrators have deployed a security template named SQL05_Security.inf that has the appropriate settings to meet the company’s security policy. You need to identify the existing configuration of each SQL Server 2005 computer to ensure that it meets the company’s security policy. What should you do?

You are a database administrator for AIOTestKing.com. You have separate SQL Server 2005 development and production environments. You use the Business Intelligence Development Studio to create a SQL Server Integration Services (SSIS) package in your development environment. Then, you use the SSIS package to import data into your development environment from one of your company’s trading partners. You need to deploy the SSIS package to your production environment. Your production environment uses different table names than your development environment. What should you do?