What should you do?
Your server hosts Microsoft SQL Server 2000 Analysis Services (SSAS) databases and cubes. You need to perform the migration of a database from Analysis Services 2000 to Analysis Services 2005. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains a user database named Products. You use SQL Server Integration Services (SSIS) packages to export data from the Products database to a text file. You use FTP to send the text file to your company’s trading partners. You need to ensure that you can recover your SSIS packages if a disaster occurs. 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?
What should you do first?
You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains two user databases. SQL1 also contains the publisher database for a transactional replication publication. Every night, a full backup is made of all databases. Transaction log backups are made twice each day for both user databases. SQL1 is configured to use SQL Server and Windows authentication. Client applications connect by using SQL Server login accounts. The disk subsystem on SQL1 experiences a complete failure. You replace the failed hardware, reinstall Microsoft Windows Server 2003, and reinstall SQL Server 2005. You need to ensure that SQL1 is operating normally as quickly as possible and with a minimum loss of data. Your solution must make the user databases available to client applications as soon as those databases are restored. What should you do first?
What should you do?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a cube in an SSAS instance. You notice that the queries run slowly. You need to identify the queries that run slowly and change the storage configuration of the cube. What should you do?
What should you do?
You need to design a stored procedure to import the registry information from AppServer1. You want to accomplish this goal without allowing the execution of unmanaged code. What should you do?
What should you do?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You notice unusually high CPU utilization in the msmdsrv.exe every day during business hours. You need to identify the source of the high CPU utilization without requiring user interaction to stop and start traces. What should you do?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Users report that all client applications that connect to AIOTestKing A are responding slowly. You discover that AIOTestKing As CPU and memory utilization is low and that disk activity is low. You need to identify the cause of the performance problem.
What should you do?
Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The OLE DB data source for the package is a database that is updated frequently.
You need to create a package that accomplishes the following tasks:
Implement the IRowsetFastLoad interface.
Support various data flow destinations.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. The SQL Server service and the SQL Server Agent service are configured to start automatically. You need to configure AIOTestKing A to audit all user names and application names that attempt to access information from AIOTestKingA. AIOTestKing A must perform auditing at all times, and the results must be kept for 10 years. What should you do?