Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 1:

  You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a folder named Management Reports.

  All groups can view and modify reports in any folder.

  You need to ensure that only the Managers group can view and modify reports in the Management Reports folder.

  What should you do?

  A. Remove all groups from the Management Reports folder. Add the Managers group to the folder and assign the Content Manager role.
  B. Create a Managers role. Assign the Managers role to the Management Reports folder. Remove all other groups from the Management Reports folder.
  C. Create a Managers role. Assign the Managers role to the root folder. Remove all groups from the Management Reports folder.
  D. Add the Managers group to the root folder and assign the Content Manager role. Remove all groups from the Management Reports folder.
  A. Remove all groups from the Management Reports folder. Add the Managers group to the folder and assign the Content Manager role.

• Question 2:

  You are managing a SQL Server 2008 Analysis Services (SSAS) sample which includes a database that is utilized through the members of the Shopping group for Company.com. You set a new role named Southern Region through utilizing

  the "{[Product]. [Place]. [Place].

  [Southern]}" Permitted permission configuration.

  You assign the Shopping group to the Southern Region role.

  You should make sure that you could clarify that users could browser data in the Southern Place role.

  Which is the correct answer?

  A. You should make Visual Totals check box enable
  B. You should increase the User Local Group = Southern Place; parameter to the connection string
  C. You should increase the Roles= Southern Place; parameter to the connection string
  D. You should increase the User ID = Southern Place; parameter to the connection string
  C. You should increase the Roles= Southern Place; parameter to the connection string

  ---

  http://www.activeinterface.com/b2008_12_29.html

• Question 3:

  You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the sales manager to access the database. You have two roles named Northeast Region and Bikes. The schemas of the two roles are as shown in the following table.

  

  The Visual Totals property is set to True for both roles. You need to ensure that the sales manager can view only the members in the Product dimension that relate to the Bikes category in the Northeast region.

  What should you do?

  A. Add the manager to the Bikes role.
  B. Add the manager to the Northeast Region role.
  C. Add the manager to a new role that has the following two components: {[Sales Territory]. [Sales Territory Region].and[Northeast]} as the allowed set.{[Product].[Product Category]. [Product Category].and[Bikes]} as the allowed set.
  D. Add the manager to a new role that has the following four components: {[Sales Territory]. [Sales Territory Region].AllMembers} as the denied set{[Sales Territory].[Sales Territory Region].and [Northeast]} as the allowed set.{[Product].[Product Category].[Product Category].AllMembers} as the denied set. {[Product].[Product Category].[Product Category].and[Bikes]} as the allowed set.
  C. Add the manager to a new role that has the following two components: {[Sales Territory]. [Sales Territory Region].and[Northeast]} as the allowed set.{[Product].[Product Category]. [Product Category].and[Bikes]} as the allowed set.

• Question 4:

  You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance.

  CurrentBalance contains the current account balance.

  You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period.

  What should you do?

  A. Set the AggregationFunction property of AccountBalance to Sum.
  B. Set the AggregationFunction property of AccountBalance to ByAccount.
  C. Set the AggregationFunction property of AccountBalance to LastNonEmpty.
  D. Set the AggregationFunction property of AccountBalance to FirstNonEmpty.
  C. Set the AggregationFunction property of AccountBalance to LastNonEmpty.

• Question 5:

  You design a report by using SQL Server 2008 Reporting Services (SSRS).

  The report contains a dataset that has 25 million rows of data. The report is rendered by using the HTML rendering extension.

  You need to ensure that users can view the report without delay during rendering.

  What should you do?

  A. Set the PageHeight property to 0.
  B. Set the InteractiveHeight property to 100.
  C. Set the InteractiveHeight property to 0.
  D. Set the PageHeight property to 100.
  D. Set the PageHeight property to 100.

• Question 6:

  You are deploying a SQL Server 2008 Reporting Services (SSRS) instance for Company.com. You decide to publish SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008 failover cluster.

  There is Internet Information Services (IIS) which is installed on the Network Load Balancing (NLB) cluster on both nodes of the cluster.

  You should make sure that publish SSRS in a fault-tolerant scale-out deployment. Which is the correct answer?

  A. Through utilizing separate ReportServer databases, you should include SSRS on both cluster nodes
  B. You should include SSRS on both cluster nodes to utilize the same ReportServer database.
  C. You should include SSIS on both cluster nodes to utilize the different ReportServer database.
  D. You should include SSAS on cluster nodes the SSRS service through utilizing the SQL Server resource group.
  B. You should include SSRS on both cluster nodes to utilize the same ReportServer database.

• Question 7:

  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.

  According to his requirement, you have to use SQL Server 2008 Reporting Services (SSRS) to design a report.

  Each time the users render the report, detail information is displayed. According to the requirement of the CIO, Summary information must be displayed when the report is initially rendered.

  Besides this, only when the users click a column header, detail information is displayed. You must satisfy these requirements.

  So what action should be performed?

  A. You should set the hidden property to False. Then you should set the Visibility can be toggled by another report item property to True
  B. You should set the hidden property to True on the column that contains detail information. Then set the Visibility can be toggled by another report item property to True.
  C. You should set the hidden property to False on the column that contains detail information. Then set the Visibility can be toggled by another report item property to False.
  D. You should set the hidden property to True on the column that contains detail information. Then set the Visibility can be toggled by another report item property to False.
  B. You should set the hidden property to True on the column that contains detail information. Then set the Visibility can be toggled by another report item property to True.

• Question 8:

  You are managing a SQL Server Analysis Services (SSAS) database which is set through utilizing security roles and operated through a Microsoft ASP.NET application which does not located in local computer for Company.com. You should utilize Windows Authentication for the application. Not only you should make sure that the application users access the SSASdatabase normally but also you should make sure that roles' security restrictions are permitted. Which is the correct answer?

  A. You should set Kerberos authentication for it.
  B. You should set HTTP configurations.
  C. You should configure Web Services for HTTP authentication.
  D. You should make Security\Authentication attribute false
  A. You should set Kerberos authentication for it.

• Question 9:

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

  

  Processes multiple files by using a ForEach Loop container.

  

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

  

  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 execute within a single transaction.

  What should you do?

  A. In the ForEach Loop container, configure the TransactionOption property to NotSupported.
  B. In the package, configure the TransactionOption property to Required.
  C. In the Data Flow task, configure the TransactionOption property to Required.
  D. In the package, configure the TransactionOption property to NotSupported.
  B. In the package, configure the TransactionOption property to Required.

• Question 10:

  You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows.

  You need to monitor the data that passes through each path in the data flow by using the Business Intelligence Development Studio. You also need to ensure that data flow logic is retained.

  What should you do?

  A. Use the Data Viewer tool.
  B. Use the Data Profiling task.
  C. Use the Audit transformation.
  D. Use breakpoints in the Script component.
  A. Use the Data Viewer tool.