Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 51:

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

  Your solution contains a measure group named FactMeasures with a single partition.

  You need to ensure that the following requirements are met:

  

  Queries that use FactMeasures always refer to the latest version of the source detail data.

  

  All aggregations that are part of FactMeasures are stored in a multidimensional format. Which storage mode should you set the ProactiveCaching property of the partition to?

  A. Real-time hybrid online analytical processing (HOLAP)
  B. Real-time relational online analytical processing (ROLAP)
  C. Automatic multidimensional online analytical processing (MOLAP)
  D. Scheduled multidimensional online analytical processing (MOLAP)
  A. Real-time hybrid online analytical processing (HOLAP)

• Question 52:

  You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).

  You create a new role.

  You need to grant the following permissions to the role:

  

  View and modify security settings for reports, folders, resources, and shared data sources.

  

  Create and delete reports.

  

  Modify report properties.

  Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

  A. Assign Set Security Policies for Items task to the role.
  B. Assign the Consume Reports task to the role,
  C. Assign the Manage Resources task to the role.
  D. Assign the Manage Reports task to the role.
  A. Assign Set Security Policies for Items task to the role.
  D. Assign the Manage Reports task to the role.

  ---

  You can modify the My Reports role to suit your needs. However, it is recommended that you keep the "Manage reports" task and the "Manage folders" task to enable basic content management. In addition, this role should support all view-

  based tasks so that users can see folder contents and run the reports that they manage.

  Although the "Set security policies for items" task is not part of the role definition by default, you can add this task to the My Reports role so that users can customize security settings for subfolders and reports.

  The Manage reports task: Add and delete reports, modify report parameters, view and modify report properties, view and modify data sources that provide content to the report, view and modify report definitions, and set security policies at the

  report level.

  Note:

  Reporting Services uses a role-based security model to control access to reports, folders, and other items that are managed by a report server. The model maps a specific user or group to a role, and the role describes how that user or group

  is to access a given report or item. The security model consists of the following components:

  A user or a group account that can be authenticated by Windows security or another authentication mechanism.

  Role definitions that define a set of actions or operations. Examples of role definitions include System Administrator, Content Manager, and Publisher.

  Securable items for which you want to control access. Examples of securable items include folders, reports, and resources.

  The combination of all these elements is characterized as a role assignment. In Reporting Services, role assignments provide the security context for items and the report server itself.

  Note 2:

  In Reporting Services, tasks are all possible actions that a user or administrator performs. There are twenty tasks in all. Some examples of tasks include "View reports," "Manage reports," and "Manage report server properties."

  Tasks are predefined. You cannot create custom tasks or modify the ones provided either programmatically or through a tool.

  Each task consists of a set of permissions, which are also predefined. For example, the "Manage folders" task contains the permissions create and delete folders, and view and update folder properties. Users never interact with permissions

  directly. Users are granted permissions indirectly through the tasks that are included in role definitions. These permissions allow access to specific report server functionality. For example, users who have permission to subscribe to reports

  can use subscription-related pages and buttons in Report Manager to create and manage subscriptions. Users who do not have permission do not see subscription-related pages in Report Manager.

  To work, a task must be assigned to a role that is actively used in a security policy. A task that is not assigned to a role has no impact on user actions or security.

• Question 53:

  You are creating a SQL Server 2008 Reporting Services (SSRS) package which includes a parameter named @ProductID for Company.com. Through choosing a specific region you should configure the value of the @ ProductID parameter in the report.

  You should make sure that you set the report to prevent users from changing the value of the @ ProductID parameter.

  Which is the correct answer?

  A. You should set the Prompt value null.
  B. You should modify the Hidden property.
  C. You should configure the internal property.
  D. You should update the biggest values.
  C. You should configure the internal property.

  ---

  Report parameters are defined globally for the report. Report parameters are created automatically if the report query includes parameters, or they can be created manually. After a report parameter is created, you must set properties that identify it and that control how it is used in the report. Report parameters are automatically created for query parameters when a dataset query is saved, or you can create a report parameter manually. After you create a report parameter, you may need to adjust the default values for report parameter properties to get the functionality you want. For example, you may need to change the data type, create a dataset to provide an available values list, create a dataset to for default values, or set whether the values can be blank or null.

  Hidden and Internal Parameters You can set options that control parameter visibility in the published report. Setting the Hidden and Internal options provides different levels of visibility. You can hide the parameter on the parameter input area of the published report, yet set values for it on a report URL or in a subscription definition. If you set a parameter to Internal, it is not exposed in any way except in the report definition. An internal parameter must have a default value, which can be null if the Allow null value option has been selected.

• Question 54:

  You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a key performance indicator (KPI) named GPMargin for your solution. You set the Value expression of the KPI in the following manner.

  

  You need to set a Trend expression of the KPI to show a difference in the values compared with the previous quarter. Which MDX code segment should you insert at line 02?

  A. KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ),
  B. KPITrend( "GPMargin" ) > ( KPIValue ( "GPMargin" ),
  C. KPIStatus( "GPMargin" ) > ( KPIValue( "GPMargin" ),
  D. KPIGoal( "GPMargin" ) > ( KPIValue( "GPMargin" ),
  A. KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" ),

• Question 55:

  You are developing a SQL Server 2008 Integration Services (SSIS) package. The package performs the following tasks:

  

  Processes multiple files by using a ForEach Loopcontainer.

  

  Imports the contents of the files to a table by using a Data Flowtask.

  

  Logs the results of the status into a table by using an Execute SQL task.

  You need to ensure that all the tasks of the package except the Execute SQL task execute within a single transaction.

  Which two actions should you perform? (Each correct answer presents part of the solution.

  Choose two.)

  A. In the Foreach Loop container, configure the TransactionOption property to NotSupported
  B. In the Data Flow task, configure the TransactionOption property to Required
  C. In the package, configure the TransactionOption property to Required
  D. In the package, configure the TransactionOption property to NotSupported
  E. In the Execute SQL task, configure the TransactionOption property to NotSupported
  F. In the Execute SQL task, configure the TransactionOption property to Supported.
  C. In the package, configure the TransactionOption property to Required
  E. In the Execute SQL task, configure the TransactionOption property to NotSupported

• Question 56:

  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 are in charge of a SQL Server 2008 Analysis Services (SSAS) instance.

  Now you get an e-mail from your company CIO, in the e-mail he wants you to run the Usage- Based Optimization Wizard.

  You have to enable query logging. What action should you perform?

  A. The QueryLogSampling server property should be set to 10
  B. The LogDir server property should be set to a valid path.
  C. The QueryLogConnectionString server property should be set to a valid connection string.
  D. The AllowedBrowsingFolders server property should be set to include the folder from the LogDir setting.
  C. The QueryLogConnectionString server property should be set to a valid connection string.

  ---

  

  After you set the QueryLogConnectionString property, the server will attempt to establish a connection by using the connection string you specifi ed in the QueryLogConnectionString property. If the connection fails, the SSAS service ignores the error. Monitor the Windows event log for error messages if no queries are logged in the query log.

  EXAM TIP you want to run the usage-Based optimization Wizard to produce an aggregation design based on the actual server usage. you have a SQL Server database named SSAS_Logging. you want to confi gure the server properties to save every fi fth query to a table named QueryLog inside the SSAS_Logging database. Which server properties do you need to change? you need to change all of the four Log \QueryLog properties. Set the Log\Query-Log\CreateLogTable property to True so that the server can create the table. Set Log\QueryLog \QueryLogConnectionString property to specify a valid connection string to the SSAS_Logging database. Change the Log\QueryLog \QueryLogSampling property to 5 to sample every fi fth query. Last, change the Log \QueryLogQueryLogTablename property to QueryLog.

• Question 57:

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

  You have a table named FactSales that contains columns named Country and Year.

  You discover that data is frequently queried for the following values:

  

  The Country column as USA

  

  The Year column as 2008

  You decide to implement two partitions for the measure group based on the FactSales table. The first partition contains the frequently queried data and the second partition contains the remaining fact table data.

  Which partition query WHERE clauses should you use?

  A. Country = "USA" Year = 2008
  B. Country = "USA" AND Year = 2008 Country "USA" AND Year 2008 Country = "USA" OR Year = 2008
  C. Country = "USA" AND Year = 2008 Country "USA" AND Year 2008
  D. Country = "USA" AND Year = 2008 (Country = "USA" AND Year 2008) OR (Country "USA")
  D. Country = "USA" AND Year = 2008 (Country = "USA" AND Year 2008) OR (Country "USA")

• Question 58:

  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 are responsible for the security in SQL Server 2008 Reporting Services (SSRS). After a new user is assigned to a role, you should give the permissions to the user, making the user publish reports and manage content only in a private folder.

  So what action should you perform?

  A. You should assign the user to the Content Manager and the Report Builder roles
  B. You should assign the user to the Publisher role.
  C. You should assign the user to the My Reports role
  D. You should assign the user to the Content Manager and the Browser roles.
  C. You should assign the user to the My Reports role

  ---

  http://msdn.microsoft.com/en-us/library/ms156338.aspx My Reports Role

  SQL Server 2008 R2 Other Versions The My Reports role is a predefined role that includes a set of tasks that are useful for users of the My Reports feature. This role definition includes tasks that grant administrative permissions to users over the My Reports folder that they own. Although you can choose another role to use with the My Reports feature, it is recommended that you choose one that is used exclusively for My Reports security. For more information, see Securing My Reports.

• Question 59:

  You are developing a SQL Server 2008 Reporting Services (SSRS) report which includes a table for Company. com.

  You should make sure that different rows in the table own a yellow background. Which is the correct answer?

  A. =iif(RowNumber(Nothing) / 2, "Yellow", "Black")
  B. =iif(RowNumber(Nothing) Mod 2, "Yellow", "White")
  C. =iif(RowNumber(NULL) Divide 2, "Yellow", "White")
  D. =iif(CountRows(NULL)/2, "Yellow", " Black ")
  B. =iif(RowNumber(Nothing) Mod 2, "Yellow", "White")

  ---

  IIf(expr, truepart, falsepart)

  All three parameters are required:

  expr is the expression that is to be evaluated.

  truepart defines what the IIf function returns if the evaluation of expr returns true. falsepart defines what the IIf function returns if the evaluation of expr returns false. The MOD function can be used to divide numbers in Excel. Unlike regular

  division, however, the MOD function only gives you the remainder as an answer.

  The syntax for the MOD function is:

  = MOD ( Number , Divisor )

• Question 60:

  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].and[Germany],[Customer].

  

  [Country].and[France]}

  set of attribute members.

  New members added to the attribute are visible by default.

  What should you do?

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