Prep and try our 070-448 valid and latest training questions & answers

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to update only the Products dimension while processing the cube by using an XML for Analysis
(XMLA) script.
You need to ensure that only the dimensions are updated.
What should you do?

• A. Execute a processDefault command.
• B. Execute a processIndex command.
• C. Execute a processUpdate command.
• D. Execute a processStructure command.

You maintain a SQL Server Analysis Services (SSAS) database. The database is configured by using
multiple security roles.
The database is accessed by a Microsoft ASP.NET application that runs on a remote computer. The
application is configured to use Windows Authentication.
You need to ensure that the users of the application can successfully access the SSAS database. You also
need to ensure that security restrictions of the roles are applied.
What should you do?

• A. Set the AnonymousConnectionsEnabled policy to True.
• B. Configure Kerberos authentication.
• C. Configure Analysis Services for HTTP authentication.
• D. Set the Security\RequireClientAuthentication property to True.

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named
Customer.
You need to configure the Dimension Data settings to meet the following requirements:
Deny access to the {[Customer].[Country].&[Germany],[Customer].[Country].&[France]} set of attribute
members.
New members added to the attribute are visible by default.
What should you do?

• A. Add the following set to the Allowed Set property. Extract({[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]} ,[Customer].[Country])
• B. Add the following set to the Denied Set property. {[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]}
• C. Add the following set to the Denied Set property. Except([Customer].[Country].[Country] ,{[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]})
• D. Add all the country members except those of France and Germany to the Allowed Set property.

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

• A. Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
• B. Create a regular relationship between DimCustomer and FactTransaction.
• C. Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.
• D. Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.

Note: This question is part of a series of questions that use the same of 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 a question apply only to that question.
You maintain the SQL Server 2008 Integration Services (SSIS) instances for a an insurance company.
You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network. The package is configured externally to the file Mamberinformationconfig.cfg.
You need to execute the package.
Which command syntax should you use?

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