What should you do?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The data source for a cube has tables as shown in the following exhibit. (Click the Exhibit button.)
The cube contains the following objects:
A dimension named DimAccounts that uses a table named Accounts.
A dimension named DimCustomers that uses a table named Customers.
A measure group named Transactions that uses a fact table named Transactions.
A measure group named Customer Accounts that uses a fact table named CustomerAccounts.
You need to create a cube dimension to browse through the measures in the Transactions fact table by using the DimCustomers dimension.
What should you do?
Which approach should you recommend?
You need to design session state management for the rewritten Web application.
Which approach should you recommend?
What should you do?
You are a database administrator for AIOTestKing.com. Developers need access to create, alter, and drop tables in your SQL Server 2005 database. A list of production tables is maintained in a table named Valid_Production_Tables in the database. You need to be able to automatically roll back any commands that drop or alter current production tables.
You need to do this while minimizing the processor resources being used. 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 contains the following objects:
A time dimension named Time that has an attribute named TimeKey.
A fact table named FactOrders.
The Time dimension contains different hierarchies. Two of the columns of the fact table link to the attribute.
You need to view the measures for different hierarchies for both the columns in the fact table.
What should you do?
Which approach should you recommend?
You need to design a deployment solution for the rewritten Web application.
Which approach should you recommend?
What are three possible ways to achieve this goal?
You are a database administrator for an electronics distribution company. You are documenting your company’s requirements for data quality. You need this information so that you can store part numbers, components, and stock levels from your company’s trading partners in your SQL Server 2005 environment. You need to determine the standards for data quality. You need to consult with the business analysts and other database administrators (DBAs) in your organization to do so. What are three possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose three.)
Which expression should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The project contains a cube named Finance.
The Finance cube contains the following objects:
A measure group named SalesMeasures.
A measure named SalesAmount.
A time dimension named DimTime.
A time dimension hierarchy named Calendar that contains Year on the first level, Quarter on the second level, and Month on the third level.
You need to create a trend expression that displays the increase and decrease in the SalesAmount measure for the current DimTime member, irrespective of the level of the Calendar hierarchy.
Which expression should you use?
Which approach should you recommend?
You need to design a solution for programmatically adding reusable user-interface code to views and allowing the user-interface code to be rendered from the server side.
Which approach should you recommend?
What should you do?
You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema, application roles, and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do?
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.)