Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 81:

  You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis Services (SSAS) database. The database contains a dimension named Employee.

  You plan to configure the security for the Managers role.

  You need to allow the Managers role to access aggregate data based on only three or less employees.

  What should you do?

  A. Add members of the [Employee].[Employees] hierarchy that contain three or less children to the denied set for the Managers role.
  B. Add members of the [Employee].[Employees] hierarchy that contain more than three children to the allowed set for the Managers role.
  C. Add the following expression to the Allow Reading property in Cell Data in the Managers role. Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count
  D. Add the following expression to the Allow Reading property in Cell Data in the Managers role. IIF (Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count
  C. Add the following expression to the Allow Reading property in Cell Data in the Managers role. Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count

• Question 82:

  You are developing a SQL Server 2008 Analysis Services (SSAS) solution for Company.com. There is a key performance indicator (KPI) named PerKey in your solution.

  You configure the Value expression of the KPI below.

  [Measures].[Amount],[Account].[Accounts].[Operating Expenses] /[Measures].[Amount], [Account].

  [Accounts].

  [Gross Margin]

  There is a time dimension called TestTime in your solution Multidimensional Expressions (MDX) statement are listed below

  11 IIf(

  13 ParallelPeriod

  14 ( [TestTime].[Calendar].[Quarter],1,[ TestTime].[Calendar].CurrentMember 15 ) ), 2, -10 )

  In order to configure a Trend expression of the KPI to show a difference in the values compared with the before quarter.In order to solve the problem, which is the correct answer?

  A. You should insert KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ) at line 12,
  B. You should insert KPITrend( "GPMargin" )
  C. You should insert KPIStatus( "GPMargin" ) < ( KPIValue( "GPMargin" ) at line 12,
  D. You should insert KPIGoal( "GPMargin" ) => ( KPIValue( "GPMargin" ) at line 12,
  A. You should insert KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ) at line 12,

• Question 83:

  You maintain a SQL Server 2008 Analysis Services (SSAS) database on a production server.

  The database contains a cube.

  You add new functionality to the cube on a development server. You need to deploy the new functionality from the development server to the production server by ensuring that the effect on the users is minimized.

  What should you do?

  A. Use the Synchronize Database Wizard.
  B. Copy the appropriate files from the development server to the production server.
  C. Detach the production database. Copy the appropriate files to the production server, and then attach the database on the production server.
  D. Modify the Target Server property to the production server by using Business Intelligence Development Studio (BIDS). Deploy the solution.
  A. Use the Synchronize Database Wizard.

• Question 84:

  You are maintaining a SQL Server 2008 Analysis Services (SSAS) solution in the production environment. You modify the solution to include two new measure groups in the development environment. You need to ensure that only one measure group is deployed to the cube in the production environment. What should you do?

  A. Use the Deployment Wizard.
  B. Use Microsoft SQL Server Management Studio (SSMS) to issue an XMLA command.
  C. Use Microsoft SQL Server Management Studio (SSMS) to issue an UPDATE MEMBER command.
  D. Use Business Intelligence Development Studio (BIDS) along with the Deploy only changes option set to True.
  B. Use Microsoft SQL Server Management Studio (SSMS) to issue an XMLA command.

• Question 85:

  You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.

  Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.

  Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You use SQL Server 2008 Reporting Services (SSRS) to create a solution.

  There is a table in the solution.

  The table is named FinishedBills. The table contains two columns respectively named BillKey and ClientKey.

  You have to create a measure, the number of customers who have placed bills is returned by the measure.

  So what action should you perform?

  A. The Usage property should be set to Count of rows and the Source Column property should be set to OrderKey.
  B. The Usage property should be set to Count of rows and the Source Column property should be set to CustomerKey.
  C. The Usage property should be set to Distinct count and the Source Column property should be set to OrderKey.
  D. The Usage property should be set to Distinct count and the Source Column property should be set to CustomerKey
  D. The Usage property should be set to Distinct count and the Source Column property should be set to CustomerKey

• Question 86:

  You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.

  Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.

  You company CIO decides to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008 failover cluster.

  Since you are the IT support, the company CIO assigns this task to you.

  You check and find that both nodes of the cluster have been installed with Internet Information Services (IIS) which is virtualized on the Network Load Balancing (NLB) cluster. Now you have to perform the deployment of the SSRS in a fault-

  tolerant scale-out deployment.

  So what action should you perform?

  A. On both cluster nodes, you should install SSRS to use the same ReportServer database
  B. On both cluster nodes, you should install SSRS to use separate ReportServer databases
  C. On both cluster nodes, you should install SSRS, and then you should use the SQL Server resource group to cluster the SSRS service D. On both cluster nodes, you should install SSRS, and then you should use a new resource group to cluster the SSRS service
  A. On both cluster nodes, you should install SSRS to use the same ReportServer database

• Question 87:

  You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.

  An existing report on shoe sales allows the user to see the company's revenue across many different attributes.

  You need to create a drop down list that filters the report by one or more shoe colors.

  You alter the main dataset and configure the report parameter to accept multiple values.

  What should you do next?

  A. Create a distinct dataset that includes all possible values and attach it to the parameter.
  B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
  C. Create a dynamic data source from a dataset by using the IN operator.
  D. Configure the Internal Visibility option for the parameter.
  E. Change the dataset from a shared dataset to an embedded dataset in the report.
  F. Create a dynamic data source from a dataset that includes a list of distinct servers.
  G. Create a dynamic dataset that includes a list of the different users.
  H. Configure the Hidden Visibility property.
  A. Create a distinct dataset that includes all possible values and attach it to the parameter.

• Question 88:

  You are developing a SQL Server 2008 Analysis Server (SSAS) method which includes a measure group called TestGroup with a one partition for Company.com. The condition listed below should be included

  *

  Searches which utilize TestGroup on the newest version of the information.

  *

  In a many aspects format, the whole collections which are member of TestGroup are reserved.

  In order to solve the problem, which is the correct answer?

  A. You should configure Real-time hybrid online analytical processing (HOLAP)
  B. You should configure Real-time relational offline analytical processing (ROLAP).
  C. You should configure scheduled relational offline analytical processing (ROLAP).
  D. You should configure scheduled online processing (MOLAP).
  A. You should configure Real-time hybrid online analytical processing (HOLAP)

  ---

  HYBRID OLAP As its name suggests, HOLAP is a hybrid between MOLAP and ROLAP. In HOLAP, the cube data remains in the relational store, but the aggregations are stored on the SSAS server. HOLAP is the most effi cient mode in terms of disk space because detail-level data is not duplicated, as it is with MOLAP, and HOLAP requires less space to store aggregations than ROLAP does. ------------------------------------------------------------------------------------------------------------------- EXAM TIP Choose the HOLAP storage mode if you want to store cube aggregations on the SSAS server but keep the fact data in the source database. ------------------------------------------------------------------------------------------------------------------- In terms of query performance, HOLAP scores in the middle. If the query can be satisfi ed entirely by existing aggregations, HOLAP performs as well as MOLAP. But if it cannot be satisfied, the query is sent to the relational database, and performance suffers. In terms of processing times, HOLAP cubes might be processed faster than either MOLAP or ROLAP cubes because data is read only once to create aggregations. However, because SSAS has an efficient storage architecture, in real life MOLAP and HOLAP should give you comparable processing times, so it is best to consider HOLAP only for large historical partitions that are queried infrequently.

• Question 89:

  You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

  Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Reporting Services (SSRS) solution for the company. Then you add a report with a query parameter and a single dataset to the

  solution. Now you get an order from your company CIO, according to his requirement, you need to make sure that the report can be executed with no user interaction from the Report Manager.

  What action should you perform to achieve this goal?

  A. From the dataset, you should have available values configured for the parameter.
  B. You should have the default value configured for the parameter based on an expression
  C. You should have the parameter data configured to refresh whenever the parameter is refreshed.
  D. You should have the default value configured for the report.
  E. You should use snapshot execution to configure the report.
  B. You should have the default value configured for the parameter based on an expression

• Question 90:

  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 IsAggregatable property of the Price attribute to False.
  B. Set the AttributeHierarchyEnabled property of the Price attribute to False.
  C. Set the MembersWithData property of the Price attribute to NonLeafDataHidden.
  D. Set the GroupingBehavior property of the Price attribute to DiscourageGrouping.
  B. Set the AttributeHierarchyEnabled property of the Price attribute to False.