Microsoft 070-448 - TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimProduct that contains an attribute named Price. You use the
DimProduct dimension in a cube.
You need to ensure that aggregations are not associated with the Price attribute.
What should you do?

• A. Set the MembersWithData property of the Price attribute to NonLeafDataHidden.
• B. Set the IsAggregatable property of the Price attribute to False.
• C. Set the GroupingBehavior property of the Price attribute to DiscourageGrouping.
• D. Set the AttributeHierarchyEnabled property of the Price attribute to False.

You build and deploy a SQL Server 2008 Integration Services (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration to the deployed package.
What should you do?

• A. Use the SETX command line utility.
• B. Use the DTEXEC command line utility.
• C. Use the Deployment utility.
• D. Use the DTUTIL command line utility.

You build and deploy a SQL Server 2008 Integration Service (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration file to the deployed package stored in files system.
Which parameter should you set in the DTEXEC command line utility?

• A. /CheckF
• B. /L
• C. /conf
• D. /Set

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in the question apply only to that question.
You maintain the SQL Server 2008 integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses third-party event based scheduler.
You develop a package named Memberinformation.dtsx and save it in the SSIS packages folder on the company network.
You need to deploy this package by connecting with the DBPROD production server SSIS engine. The event based scheduler will execute the deployed SSIS package.
Which command syntax should you use

• A. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)
• B. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
• C. dtexec /f " Z:\ Memberinformation.dtsx " /conf "
  Z: \Memberinformationconfig,cfg "
• D. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
• E. dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
• F. dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
• G. dtexec /sq Memberinformation /ser productionServer / va
• H. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database
that is used by the members of the Engineering group.
You configure a new role named Engineering and Design by using the following allowed permission set:
{[Employees].[Department].[Engineering and Design]}
You assign the Engineering group to the Engineering and Design role.
You need to ensure that users in the Engineering and Design role can view data only for their department.
What should you do?

• A. Add your account temporarily to the Engineering and Design role.
• B. Add the Roles = [Engineering and Design]; parameter to the connection string.
• C. Add the User ID = [Engineering and Design]; parameter to the connection string.
• D. Select the Enable Visual Totals check box for the Engineering and Design role.