Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 91:

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

  You should set the Dimension Data configurations as following:

  Deny access to the {[ Product].[Country].[USA],[ Product].[Country].[China]} configure of property workers.

  New workers increased to the property are seen by default. Which is the correct answer?

  A. You should increase the whole country members.
  B. You should increase property below: [Country].[ China],[Product].[Country].[ USA]}
  C. You should increase property below: [Country].[ China],[Product].[Country].[ USA]}
  D. You should increase property below: [Country].[ China],[Product].[Country].[ USA]}
  B. You should increase property below: [Country].[ China],[Product].[Country].[ USA]}

• Question 92:

  You plan to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008 failover cluster. Internet Information Services (IIS) is installed on both nodes of the cluster. The IIS is virtualized on the Network Load Balancing (NLB)

  cluster. You need to deploy SSRS in a fault- tolerant scale-out deployment.

  What should you do?

  A. Install SSRS on both cluster nodes to use separate ReportServer databases.
  B. Install SSRS on both cluster nodes to use the same ReportServer database.
  C. Install SSRS on both cluster nodes and cluster the SSRS service by using a new resource group.
  D. Install SSRS on both cluster nodes and cluster the SSRS service by using the SQL Server resource group.
  B. Install SSRS on both cluster nodes to use the same ReportServer database.

• Question 93:

  You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com. You develop a cube which utilized a dimension called DimEmployeeTest.

  The dimension includes an attribute named EmployeeTest. You also host a Microsoft SQL Server 2008 Reporting Services (SSRS) project which includes a report on an employee. You can browser the information. Which is the correct answer?

  A. You should develop a URL action on the EmployeeTest attribute.
  B. You should develop a DataSet action on the EmployeeTest attribute.
  C. You should develop a DataTable action on the DimEmployeeTest dimension.
  D. You should develop a ReWrite action on the DimEmployeeTest dimension.
  A. You should develop a URL action on the EmployeeTest attribute.

• Question 94:

  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 in Business Intelligence Development Studio, you are developing a SQL Server 2008 Integration Services (SSIS) project.

  You configure the project properties as shown in the following image.

  You need to create a deployment manifest for all packages in the project.

  What should you do?

  A. You should view the code of each Data Transformation Services (DTS) package. Then you should copy the first xml node to a file with a .SSISDeploymentManifest file extension.
  B. You should build the Integration Services project
  C. You should modify the AllowConfigurationChanges property of the project
  D. You should copy each package. Then you should rename each copy with a .SSISDeploymentManifest file extension
  B. You should build the Integration Services project

• Question 95:

  You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server 2008.

  You use a development server named SQL_DEV1. There is no network connectivity between the development server and the production server.

  You deploy the package to the SQL_PROD1 server.

  The package fails to execute. The error message states that the package cannot connect to the SQL_DEV1 server.

  You need to modify the package to refer to the SQL_PROD1 server when being executed.

  What should you do?

  A. Modify the properties of the package to use the DontSaveSensitive package protection level.
  B. Modify the deployment manifest file in Microsoft Notepad, and then modify the connection string manually.
  C. On the Connection Managers tab of the Execute Package utility, select the Connection Manager check box, and then modify the connection string.
  D. Modify the properties of the package to use the ServerStorage package protection level.
  C. On the Connection Managers tab of the Execute Package utility, select the Connection Manager check box, and then modify the connection string.

• Question 96:

  You develop a SQL Server 2008 Reporting Services (SSRS) solution.

  You add a report that contains a single dataset and a query parameter.

  You need to ensure that the report executes without user interaction from the Report Manager.

  What should you do?

  A. Configure the report to use snapshot execution.
  B. Configure available values for the parameter from the dataset.
  C. Configure the default value for the parameter based on an expression.
  D. Configure the parameter data to refresh whenever the parameter is refreshed.
  C. Configure the default value for the parameter based on an expression.

• Question 97:

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

  There is a table called SalesTester which includes the two columns named OrderTester and ShipTester.

  they are connected with TimeTester.

  You should make sure that you could get information by measures using the DimTime TimeTester.

  Which is the correct answer?

  A. You should develop a one-to-many relationship between the TimeTester dimension and the OrderTester measure group.
  B. You should develop a many-to-one relationship between the ShipTester dimension and the SalesTester measure group.
  C. You should develop a many-to-many relationship between the TimeTester dimension and the ShipTester measure group.
  D. You should develop two common relationships between the TimeTester dimension and the SalesTester measure group. You should not utilize same columns of measure group.
  D. You should develop two common relationships between the TimeTester dimension and the SalesTester measure group. You should not utilize same columns of measure group.

• Question 98:

  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 the technical support for the company which uses SQL Server2008 Analysis Services (SSAS) solution. You have a table named Bills with three columns contained. They are respectively Shipper, BillKey and BillQuantity. To meet the business development, a dimension named DimBills and a measure group named TruthBills are created from the Bills table. Besides, the BillKey is set as a key column and the Shipper is set as an attribute column.

  According to the order of the CIO, a dimension relationship between the BillQuantity column and the Shipper column should be created to make sure that the Shipper column is able to aggregate BillQuantity column.

  What action below should be performed to achieve this goal?

  A. A regular dimension relationship should be created between the DimBills dimension and the TruthBills measure group.
  B. The relationship between the TruthBills measure group and DimBills dimension should be set to No Relationship.
  C. A Truth dimension relationship should be created between the TruthBills measure group and DimBills dimension
  D. A regular dimension relationship should be created between the DimBills dimension and the TruthBills measure group. Besides, the Granularity attribute to Shipper and the measure group columns should be set to BillQuantity.
  E. A regular dimension relationship should be created between the DimBills dimension and the TruthBills measure group. Besides, the Granularity attribute to BillKey and the measure group columns should be set to BillQuantity
  C. A Truth dimension relationship should be created between the TruthBills measure group and DimBills dimension

• Question 99:

  You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains a report header and a report footer.

  The report preview shows that the report is rendered correctly. You discover that when the report is rendered as a PDF file, even-numbered pages are rendered blank.

  You need to modify the report to prevent the rendering of blank pages.

  What should you do?

  A. Reduce the overall width of the report.
  B. Reduce the page size of the report.
  C. Reduce the height of the report footer.
  D. Reduce the height of the report header.
  A. Reduce the overall width of the report.

• Question 100:

  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 you are in charge of a SQL Server 2008 Analysis Services (SSRS) database for the company.

  To meet the business requirements, a new measure group is created in one of the cubes. A program with partitions maintained is on the production copy of the cube.

  Now you get an order from the CIO that you should have the cube definition updated on the production server, besides, you should not rewrite any existing partitions.

  So what action should you perform to achieve that goal?

  A. The Business Intelligence Development Studio (BIDS) should be used and the processing option should be set to Do Not Process
  B. The Analysis Wizard should be used along with the appropriate options
  C. The Deployment Wizard should be used along with the appropriate options
  D. An UPDATE CUBE statement should be executed in Microsoft SQL Server Management Studio (SSMS)
  E. The Analysis Services Destination component should be used in Microsoft SQL Server Integration Services (SSIS)
  C. The Deployment Wizard should be used along with the appropriate options