What should you do?
You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application is performing slowly. You need to identify the queries that are experiencing slow performance due to blocking. What should you do?
Which event handler should you use?
You create a package by using 47 Execute SQL Control Flow tasks. The Execute SQL task returns an error during a calculation of a percentage change over time. You need to add an event handler to the package that processes all of the messages that are returned from each task. Which event handler should you use?
What should you do?
You are a database administrator for AIOTestKing.com. You discover that a SQL Server 2005 application performs slowly when you execute the following query. SELECT * FROM Orders WHERE OrderStatus = ‘InProgress’ The application executes this query as an ad hoc query. This query usually executes much more quickly. The OrderStatus column is indexed. Only a small number of the rows contain the value InProgress.
However, the OrderStatus column index is not being used, even though the index is optimal for this query. You need to improve the performance of this query. However, you cannot modify the application that executes the query. Your solution must also minimize the impact on end users. What should you do?
What should you do to ensure that the DTS package runs in SQL Server 2005?
You are a database administrator for AIOTestKing.com. You have a Data Transformation Services (DTS) package stored in SQL Server 2000 that you want to migrate into SQL Server 2005. The DTS package uses complex Microsoft Visual Basic Scripting Edition (VBScript) to dynamically configure precedence constraints. You run the SQL Server 2005 Package Migration Wizard, which fails to convert the package from SQL Server 2000 to SQL Server 2005. You need to ensure that the DTS package runs in SQL Server 2005. You must get the package running as quickly as possible. What should you do?
What should you do?
You are designing a data mining structure for a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The solution requires the use of relational data. You need to design the data mining structure so that the data mining models can use the data from a case table and a nested table. What should you do?
What should you do?
You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains two databases named Production and DW. You create a new database named Staging.
The Staging database temporarily stores and manipulates data as the data moves from the Production database into the DW database. You need to ensure that tables are not removed from the Staging database. You also need to ensure that any attempts to remove tables are logged. Other databases must not be affected by your solution. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. You need to ensure that the package came from a trusted source. What should you do?
What should you do?
You are a database administrator for a financial services company. You are configuring replication between two SQL Server 2005 computers named SQL1 and SQL2. SQL1 stores real-time transactional data. SQL2 is used for reporting. SQL2 must not change data on SQL1. The publication contains a large amount of data. You need to ensure that during replication, data is copied from SQL1 to SQL2 in as near real-time as possible to ensure accurate reporting. You need to ensure that this data is copied securely. What should you do?
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. You administer a SQL Server 2005 computer that contains a database named Customers. The database includes a table named CustInfo. The table includes an identity column named CustID and an nvarchar column named CustName. Company policy requires that rows containing duplicate CustName values be removed from the CustInfo table once each year. However, rows cannot be removed from the CustInfo table until they have been manually examined and verified as being duplicates. You need to provide a way to identify potential duplicate rows for manual examination. You need to accomplish this goal by using the least amount of administrative effort. What should you do?