What should you do?
You are a database administrator for AIOTestKing.com. You receive nightly data feeds from your consumer electronics suppliers that show their inventory levels. The data value format that you receive from each supplier is not necessarily consistent. You need to ensure that the data that you import into your database is accurate and is not duplicated.
What should you do?
Which three tasks should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
While testing, a Transact-SQL user-defined function causes duplicate key values that stop the transformation.
To permit the transformation to continue, the package must perform the following tasks:
1 Ascertain which rows are affected.
2 Insert the rows that fail into a table.
3 Continue with the process.
You need to change certain properties in the package to meet the requirements.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
What should you do?
You are a database administrator for AIOTestKing.com. You are configuring a SQL Server 2005 database on a server named ServerA to use a CLR user-defined type. The CLR user-defined type needs to access a configuration file on a server named ServerB. You create a CLR assembly by using the default permission set. However, when the CLR user-defined type is called on ServerA, the assembly returns a security error. You need to correct the problem. What should you do?
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 are a database administrator for AIOTestKing.com. You create a SQL Server Integration Services (SSIS) package that contains confidential information. The package will be used by only two company employees. The package is stored in the msdb database. You need to ensure that only the appropriate employees can execute the package. You must accomplish this goal by using the least amount of administrative effort. 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?
Which two actions should you perform?
You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 hosts a database named AssetTrack. You need to design a strategy to quickly perform point-in-time and page-level restores of the AssetTrack database. 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. 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?
You are a database administrator for AIOTestKing.com. Users report that some reports are performing poorly. You ascertain that your tables have the appropriate indexes and that your queries should be performing optimally. You execute a SHOWPLAN statement on the poorly performing reports. You find that incorrect indexes are being used in some cases. You want the SQL Server 2005 query optimizer to automatically select the correct indexes. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package includes five Data Flow tasks and three Control Flow tasks. You need to modify the package so that two Control Flow tasks and one Data Flow task fail or succeed as a unit. What should you do?