What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is named UpdateTable.dtsx and contains a variable named runID. The package must run by using the dtexec utility. The runID variable must be set at runtime to a value of 5. You need to meet the outlined requirements. What should you do?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A runs Windows Server 2003 and hosts a database named DB1.
DB1 is used for a critical, enterprise-level application that all sales representatives in the company use. The database is currently 87 GB and grows 5 GB each quarter. AIOTestKing A recently experienced a hard disk failure that resulted in significant system downtime.
You purchase two new hardware RAID controllers named Controller1 and Controller2.
You also purchase five new hard disk drives to try to prevent reoccurrences of hardware-related downtime. The new hard disk drives are configured as shown in the following table.
Disk drive Size RPM Disk1 100 GB 7200 Disk2 100 GB 7200 Disk3 100 GB 7200 Disk 460 GB 7200 Disk5 60 GB 7200 The operating system is configured for redundancy. You decide to build a RAID5 array on Controller1 and a RAID1 array on Controller2.
You need to ensure that DB1 continues to perform in the event of a disk failure.
What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package must be deployed on 10 servers. You do not have access to the file system on any of these 10 servers. You need to set different package configuration properties at the package run time. What should you do?
What are two possible ways to achieve this goal?
You are the database administrator for a SQL Server 2005 computer named AIOTestKing A.
A user reports that his query has been running for a very long time and is still running.
You access the sys.dm_tran_locks dynamic management view (DMV). The relevant results are shown in the following table.
You need to find the user name of the user with the blocking connection. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is connected to a database on your development server by using a connection manager. You decide to use the DTExecUI utility to run the package. You need to change the connection of the connection manager to a different server at run time without using a package configuration file. What should you do?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A runs three instances of SQL Server. Your company’s disaster recovery plan includes having the ability to connect to the dedicated administrative connection on each instance of SQL Server. While testing this ability, you discover that you can connect to the dedicated administrative connection on AIOTestKing As default instance. But you cannot connect to the dedicated administrative connection on the two other instances on AIOTestKingA. You verify that the instances are running and that client applications are able to access them. You also verify that the dedicated administrative connection is enabled for all instances. You confirm that no other administrators are attempting to connect to any dedicated administrative connections on AIOTestKingA. You need to ensure that you can connect to the dedicated administrative connection on all three instances. What should you do?
Which query should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You have a cube named SalesCube that contains the following objects:
A measure group named Sales that contains a measure named Internet Sales Amount.
A dimension named DimProduct that contains a hierarchy named Product Category. The hierarchy contains the Category attribute on the first level, the Subcategory attribute on the second level, and the Product attribute on the third level.
You need to write a Multidimensional Expressions (MDX) query that displays only the product names and the Internet sales amount for each product.
Which query should you use?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. All servers run Microsoft Windows Server 2003 and belong to a Microsoft Active Directory domain. The companys written security policy mandates strong passwords for all domain, local, and application accounts. The appropriate domain password policy has been deployed through the use of a Group Policy object (GPO).
Many of the company’s computers run MS-DOS-based or UNIX-based operating systems. These computers require varying levels of access to a database named Services on AIOTestKingA . You need to ensure that these computers can access the Services database without violating the company’s written security policy. What should you do?
What should you do?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube that uses a dimension named Product. The Product dimension contains an attribute named ProductName. You also create a URL action and set the action expression to “http://mycompany.com/ProductInfo.aspx?Product=”+Product.ProductName.CurrentMember.Na me You need to set the action target properties for the URL action. What should you do?
What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 application. Each night, data is imported into a database, and the database is then set to be read-only. During business hours, users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)