Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 141:

  You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a time dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.

  You have a measure named Amount from a measure group named Measures.

  You need to create a calculated member to display the Amount measure in the previous time period for the current level of the Yr-Qtr-Mth hierarchy.

  Which expression should you use?

  A. ([Measures]. [Amount], OPENINGPERIOD( [DimTime].[Yr-Qtr-Mth] .FirstSibling.Level))
  B. ([Measures]. [Amount], LASTPERIODS( 0,[DimTime].[Yr-Qtr-Mth].PrevMember))
  C. ([Measures]. [Amount], [DimTime].[Yr-Qtr-Mth].PrevMember)
  D. ([Measures]. [Amount], [DimTime].[Yr-Qtr-Mth].FirstSibling)
  C. ([Measures]. [Amount], [DimTime].[Yr-Qtr-Mth].PrevMember)

  ---

  PrevMember returns the previous member in the level that contains a specified member.

  Incorrect answer:

  FirstSibling returns the first child of the parent of a member. LastPeriods returns a set of members up to and including a specified member

• Question 142:

  You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com. You could show detailed information when the users changes the report.

  The requirements should be met listed below:

  *When the users click a column header, only detailed information is showed. *When the report is rendered at the beginning of it, summary information is showed.

  Which is the correct answer?

  A. Before configuring the hidden property to True you should includes detailed information on the column and then configure the Visibility can be toggled through another report item attribute to True
  B. Before configuring the hidden property to True you should includes detailed information on the column.
  C. On the column that contains detail information, set the hidden property to False. Set the Visibility can be toggled by another report item property to False.
  D. Before configuring the hidden property to True you should includes detailed information on the column and then configure the Visibility can be toggled through another report item attribute to False
  A. Before configuring the hidden property to True you should includes detailed information on the column and then configure the Visibility can be toggled through another report item attribute to True

• Question 143:

  Your organization has five departments.

  You are developing a SQL Server 2008 Integration Services (SSIS) project to calculate salary increases and bonuses under each particular manager.

  You need to develop a master package that meets the following requirements:

  

  It must give each department a different ID.

  

  These department IDs must pass on to each individual dependency package inside the master package.

  

  Each dependency package should have individual security settings to accept department ID as a variable from its master package.

  Which configuration method should you choose from the SSIS configuration options?

  A. SQL Server
  B. Parent package variable
  C. XML configuration file
  D. Environment variable
  B. Parent package variable

• Question 144:

  You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a dimension called Product for Company.com.

  You are updating a role called Tester for the Shopping Department. For the Managers role, you decide to set the security later.

  You should make sure that you permit the Managers role to operate data based on two or less workers.

  Which is the correct answer?

  A. You should remove workers of the [Product].[ Products] hierarchy which include more than two children to the permitted configure for the Tester role.
  B. You should increase workers of the [Product].[ Products] hierarchy which include more than two children to the permitted configure for the Tester role.
  C. You should add expression below: [ Products].CurrentMember,,LEAVES).Count
  D. You should add expression below: [ Products].CurrentMember,,LEAVES).Count
  C. You should add expression below: [ Products].CurrentMember,,LEAVES).Count

• Question 145:

  You are managing a SQL Server 2008 Reporting Services (SSRS) sample which does not give some same rendering extensions for Company.com.

  You should make sure that you could set the server in order to render to Microsoft Word. Which is the correct answer?

  A. You should change the AppSetttings.config file.
  B. You should change the Global.asax file.
  C. You should change the Machine.config file.
  D. You should change the RSReportServer.config file
  D. You should change the RSReportServer.config file

  ---

  Modifying the RSReportServer.config file

  The RSReportServer.config is one of several configuration files, but it is the main configuration file for both the Report Server Web service and Report Manager. In Reporting Services 2005, Report Manager had a separate confi guration fi le

  named RSWebApplication.config, but this file is no longer used in Reporting Services 2008.

  Example: Limiting the List of Report Rendering Options

  A common configuration setting in RSReportServer.config is to limit the user choices for the report rendering. For example, if you wanted to exclude Microsoft Office Excel as a choice for rendering reports, you would look for the entries under

  the tag in the XML .config file to find the following line:

  To turn off Excel in the rendering options, you would add a Visible="false" entry to the line, like this:

• Question 146:

  You maintain a SQL Server 2008 Reporting Services instance.

  Some users need to view and run reports in the Eastern Region folder on the Report Server. You need to assign these users the minimum permissions required. Which role should you use?

  A. Content Manager
  B. Publisher
  C. Report Builder
  D. Browser
  D. Browser

• Question 147:

  You create a SQL Server 2008 Analysis Services (SSAS) solution.

  The solution contains a time dimension named DimTime. You have a table named FactSales that contains the two columns named OrderDate and ShipDate. The two columns refer to the DimTime dimension. You need to ensure that the DimTime dimension can be used to browse through measures in the FactSales table for both OrderDate and ShipDate.

  What should you do?

  A. Create a reference relationship between the DimTime dimension and the FactSales measure group.
  B. Create a many-to-many relationship between the DimTime dimension and the FactSales measure group.
  C. Create two regular relationships between the DimTime dimension and the FactSales measure group. Use identical measure group columns.
  D. Create two regular relationships between the DimTime dimension and the FactSales measure group. Use different measure group columns.
  D. Create two regular relationships between the DimTime dimension and the FactSales measure group. Use different measure group columns.

• Question 148:

  You are developing SQL Server 2008 Reporting Services (SSRS) samples which include some reports which utilize stored credentials to get data from a SQL Server 2008 sample for Company.com.

  There is the instance recovers and SSRS instance in a computer.

  You should make sure that the reports could run normally. Which is the correct answer?

  A. You should delete the encryption keys and create new ones.
  B. You should recovery the encryption keys.
  C. You should change the encryption values.
  D. You should reset the encryption default values.
  B. You should recovery the encryption keys.

  ---

  MCTS Self-Paced Training Kit (Exam 70-448) p. 579

  EXAM TIP

  When faced with a system failure where you lose your SSRS instance and/or database, you will:

  *

  first need to reinstall SSRS.

  *

  After the installation is complete, you can optionally restore the latest backup of your report server catalog database (if it was also lost).

  *

  After the service and catalog databases are in place,

  *

  your final step is to restore the encryption key onto the newly installed instance of SSRS. This will enable the report server to be able to decrypt the catalog security, reports, and data sources.

• Question 149:

  You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a data source view. You add a table named Customer from the data source to the data source view.

  You alter the name of the table from Customer to DimCustomer in the data source.

  You need to ensure that the following requirements are met:

  

  The data source view uses the altered table name as the source.

  

  All existing relationships and table references are preserved.

  What should you do?

  A. Refresh the data source view.
  B. Replace the Customer table in the data source view with DimCustomer.
  C. Remove the Customer table in the data source view.
  D. Change the FriendlyName property of the Customer table to DimCustomer.
  A. Refresh the data source view.

• Question 150:

  You are creating a SQL Server 2008 Reporting Services (SSRS) package which utilizes the "Runner! RunnerID" expression in a text box in the report footer for Company.com. You should make sure that data- driven subscriptions run

  normally for this report.

  Which is the correct answer?

  A. You should delete the expression from the report footer.
  B. You should modify the configurations of the report
  C. You should set the report to utilize store procedure.
  D. You should add the expression in the report footer as "Runner! RunnerID "
  A. You should delete the expression from the report footer.