Which instance should you use?
You are designing Microsoft SQL Server 2005 Analysis Services (SSAS) cubes for two business units.
Each business unit has the following requirements:
Full administrative access only to its own cubes and not to the cubes of the other unit.
Ability to run its cubes on a different computer in the event of a hardware failure.
You need to install SSAS in a configuration to create cubes that meet the above requirements.
Which instance should you use?
What is the most likely cause of the problem?
You are a database administrator for AIOTestKing.com. You run SQL Server Profiler by using the SP:Recompile event class. You notice a large number of recompiles occurring.
You need to identify the possible cause of the large number of recompiles. What is the most likely cause of the problem?
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?
Which two actions should you perform?
You are the database administrator for AIOTestKing.com. The company uses a database that contains a table named Sales. The CREATE statement for the Sales table is shown in the exhibit.
The Sales table is very write-intensive and is commonly used in queries. Both of the indexes on the Sales table become fragmented within the first two hours of being rebuilt.
Both leaf and intermediate level pages split frequently. There is sufficient disk space available to fully optimize the indexes. You need to optimize the nonclustered index on the Sales_Amount column of the Sales table. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. The instance contains cubes that use the HOLAP storage mode. The retrieval of data from the cubes is slow. You need to monitor the frequency with which the users access a member of each cell in a cube in System Monitor.
What should you do?
Which Transact-SQL statement should you use?
You are a database administrator for AIOTestKing.com. You administer a SQL Server 2005 database named Contracts. The Contracts database becomes corrupted. You perform a restore by using the following Transact-SQL script.
RESTORE DATABASE Contracts FROM contracts_bu_device WITH CONTINUE_AFTER_ERROR, CHECKSUM, RECOVERY After the restore, the SQL Server logs show errors in some of the page restores. You need to repair the database pages that are corrupt. You need to achieve this goal by using the method that facilitates the fastest possible repair. Which Transact-SQL statement should you use?
What should you do?
You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You have deployed a Microsoft SQL Server 2005 Analysis Services (SSAS) based data source named PhoneMetrics that accesses the PhoneMetrics cube. You need to permit clients to create ad hoc reports from the Web.
What should you do?
which SQL Server activity is causing the high disk activity. You want to accomplish this task by using SQL Ser
You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application is performing poorly. You use System Monitor and discover that disk activity on the volumes that contain the database data files is very high. You need to find out which SQL Server activity is causing the high disk activity. You want to accomplish this task by using SQL Server Profiler. What should you do?
What should you do?
You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance.
The following events must occur at 2:00 on every Sunday:
A data-driven subscription for the Human Resources report must write to several file shares.
The execution of the Sales report must expire.
The history of the Manufacturing report must include a new state of the data.
You need to configure the package so that the events occur and are exposed for a single-step batch job.
What should you do?
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?