Which value should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
The project consists of a cube that contains the following objects:
A time dimension named DimTime that contains a hierarchy named Calendar. The first level of the hierarchy is named Year and the second level is named Quarter.
A dimension named DimProduct.
A fact table named FactInventory that stores the daily stock-in-hand measure for each product.
You need to set the AggregateFunction property to ensure that the cube displays the stock-in-hand measure for each product at the end of each quarter. Which value should you use?
What should you do?
You work as DBA at AIOTestKing.com. You administer two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. You were not responsible for the original installation of SQL Server on these computers. Yet you now must ensure that both computers are configured according to the following requirements. Administrators must be able to remotely connect to AIOTestKing A and AIOTestKing B for troubleshooting, even if the system becomes unresponsive. AIOTestKing A and AIOTestKing B must not be able to execute commands related to the operating system.Database access must be permitted by using Simple Object Access Protocol (SOAP) messages over HTTP. AIOTestKing A and AIOTestKing B must not be able to use stored procedures to send e-mail.Use of the OPENROWSET and OPENDATASOURCE Transact-SQL statements must not be permitted.Stored procedures for generating HTML must not be permitted. You need to configure AIOTestKing A and AIOTestKing B to meet these requirements. What should you do?
Which two actions should you perform?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
The project has the following objects:
A cube named SalesData for a database named SalesDB.
Two dimensions named Region and Gender.
A role named Employee that has the Read permission set for the cube.
You need to modify the Employee role definition to allow the SalesData cube to be browsed only by using the Region dimension.
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. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. 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 DimProducts. The DimProducts dimension contains the following features: An attribute named Product. A column named ProductEnglishName for the
English name of the product. A column named ProductFrenchName for the French name of the product.
The NameColumn property of the Product attribute is set to the ProductEnglishName column. The language property of the cube is set to French.
You need to ensure that the cube displays the product names in French when you browse through the cube from a client that uses the fr-FR locale.
What should you do?
What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. You administer a SQL Server 2005 computer. Customers send orders to your company over the Internet in an XML format.
The XML is submitted as an input argument of a stored procedure. The stored procedure needs to produce a result set that includes all invalid product identification numbers (IDs) from the order. A company database contains a list of all valid product IDs. You need to ensure that the stored procedure can produce the desired result set. Your solution must provide the fastest possible query performance. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
Which expression should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
Your data source has the following tables:
Scenarios table that contains columns named ScenarioKey and ScenarioName.FactFinance table that contains a foreign key column named ScenarioKey.
You need to create a calculated column in a data source view named ScenarioCalc in the FactFinance table to display the ScenarioName.
Which expression should you use?
What should you do?
You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application is performing slowly. You check the SQL Server error log and discover that the server frequently runs out of memory to manage locks. The application designer informs you that dirty reads are acceptable. You need to resolve the problem indicated by the error log. What should you do?
Which MDX expression should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube named FinalAccounts.
The cube contains the following objects:
A measure named Balance under a measure group named Finance.
A dimension named DimAccount that contains an attribute named Account. The attribute contains two members named Operation Expense and Gross Margin.
A calculated member and named sets as shown in the following exhibit. (Click the Exhibit button.)
You create a Key Performance Indicator (KPI) by using a Gauge status indicator that calculates the ratio between the two attribute members. If the Operation Expense member is greater than the Gross Margin balance member, the Operation Expense member is in poor status.
You need to type the Multidimensional Expressions (MDX) expression for the Status expression of the KPI.
Which MDX expression should you use?
What should you do?
You are a database administrator for AIOTestKing.com. The company has two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. AIOTestKing A is located on the local network. AIOTestKing B is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on AIOTestKing A that access data from both AIOTestKing A and AIOTestKing B. To ensure that your queries are functional, you must configure access to the vendors site. What should you do?