What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
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 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 developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a dimension that contains a parent-child hierarchy. The dimension has a key attribute named Employee and a parent attribute named Employees. You need to ensure that the dimension identifies the topmost employee member of the hierarchy as the root member. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. Your company uses a SQL Server 2005 application. The application executes a query that returns three columns of the nvarchar data type and one column of the XML data type. The query uses a WHERE clause that includes all three of the nvarchar columns. The table contains 5 million rows, and the query returns 50,000 rows. You need to improve the performance of the query.
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 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 process option should you choose?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You want to change the design of the data mining structure to test different data mining theories. You add columns of the Ordered content type in the data mining model and the underlying case table. You need to ensure that Data Mining Viewer reflects the changes in the data mining structure and the data mining model. Which process option should you choose?
What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
Which four tasks should you perform?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
The query that builds the dataset for the report uses a WHERE clause to filter the rows.
The report parameter must perform the following actions:
Use the new parameterized query.Run without any user input.Allow users to change the value that is passed to the query by selecting a value from a drop-down list.
You need to modify the settings of the Report Properties dialog box to meet the outlined requirements.
Which four tasks should you perform? (Each correct answer presents part of the solution. Choose four.)