Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 221:

  You modify a SQL Server 2008 Integration Services (SSIS) package.

  The package extracts data from a text file and loads this data to a SQL Server 2008 table as shown in the following two exhibits.

  

  You need to update the package to extract data from multiple text files of the same directory.

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

  A. Add a variable to the package.
  B. Add a variable to the data flow task.
  C. Add a Foreach Loop container to the package.
  D. Add a For Loop container to the package.
  E. Add an expression to the Flat File Source component.
  F. Add an expression to the Flat File connection manager.
  A. Add a variable to the package.
  C. Add a Foreach Loop container to the package.
  F. Add an expression to the Flat File connection manager.

• Question 222:

  You have a SQL Server 2008 Reporting Services (SSRS) Enterprise Edition instance.

  You need to add a second report server to this instance.

  In which order should you perform the steps? (To answer, move the appropriate five actions from the list of actions to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

  ---

  Note:

  To install and configure the second report server instance

  Box 1:

  Run Setup to install a second instance of Reporting Services on a different computer or as a named instance on the same computer. When you install Reporting Services, choose the Install but do not configure server option on the Report

  Server Installation Options page.

  Box 2:

  Start the Reporting Services Configuration tool and connect to the new instance you just installed.

  Connect the report server to the same database you used for the first report server instance:

  Box 3:

  Configure the Report Server Web service URL. Do not test the URL yet. It will not resolve until the report server is joined to the scale-out deployment.

  Configure the Report Manager URL. Do not test the URL yet or try to verify the deployment. The report server will be unavailable until the report server is joined to the scale-out deployment.

  To join the second report server instance to the scale-out deployment

  Box 4:

  Open the Reporting Services Configuration tool, and reconnect to the first report server instance. The first report server is already initialized for reversible encryption operations, so it can be used to join additional report server instances to the

  scale-out deployment.

  Click Scale-out Deployment to open the Scale-out Deployment page. You should see two entries, one for each report server instance that is connected to the report server database. The first report server instance should be joined. The

  second report server should display a status of "Waiting to join". If you do not see similar entries for your deployment, verify you are connected to the first report server that is already configured and initialized to use the report server database.

  On the Scale-out Deployment page, select the report server instance that is waiting to join the deployment, and click Add Server.

  Box 5:

  You should now be able to verify that both report server instances are operational. To verify the second instance, you can use the Reporting Services Configuration tool to connect to the report server and click the Web Service URL or the

  Report Manager URL

  Reference: How to: Configure a Report Server Scale-Out Deployment (Reporting Services Configuration)

• Question 223:

  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 make modification on a SQL Server 2008 Integration Services (SSIS) package. Look at the following SQL Server 2008 table. The package loads the data extracted from a text file to this table.

  Now you receive an order from your company CIO, the package has to be updated to extract data from multiple text files of the same directory.

  In order to achieve this goal, what should you do? (Choose more than one)

  A. An expression should be added to the Flat File connection manager
  B. A variable should be added to the package
  C. A For Loop container should be added to the package
  D. A variable should be added to the data flow task
  E. Ad Foreach Loop container should be added to the package
  F. An expression should be added to the Flat File Source component
  A. An expression should be added to the Flat File connection manager
  B. A variable should be added to the package
  E. Ad Foreach Loop container should be added to the package

• Question 224:

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

  On a production server, you have increased new function to the cube.

  You should make sure that you cost least time for publishing the new functions.

  Which is the correct answer?

  A. You should utilize the Synchronize Database Wizard.
  B. Through utilizing a Dynamic Management View (DMV), you should change the Target Server attribute to the production server.
  C. Through utilizing Business Intelligence Development Studio (BIDS), you should change the Target Server attribute to the production server.
  D. Through utilizing a SQL Server 2008 Integration Services (SSIS) package, you should change the Target Server attribute to the production server.
  A. You should utilize the Synchronize Database Wizard.

• Question 225:

  You are developing a SQL Server 2008 Integration Services (SSIS) package.

  The package uses an OLE DB connection manager to connect to a third-party database server. The database does not support Integrated Windows authentication. You create an XML configuration file that provides configuration for the

  connection manager.

  You add the configuration file to the package.

  When the package executes, you receive an error message which indicates that login failure occurred.

  You need to execute the package successfully.

  What should you do?

  A. Edit the XML configuration file.
  B. Use an indirect XML configuration.
  C. Run the package on the same server as the third-party database server.
  D. Use a Microsoft ADO.NET connection manager instead of an OLE DB connection manager.
  A. Edit the XML configuration file.

• Question 226:

  You maintain a SQL Server 2008 Analysis Services (SSAS) instance.

  You have a cube that contains an unprocessed dimension.

  When a user attempts to process the cube, the dimension data is not refreshed.

  You need to allow the user to refresh the dimension data only.

  Which permissions should you grant the user?

  A. Read-only on the dimension
  B. Read/write permissions on the cube
  C. Process on the dimension
  D. Read and process on the cube
  C. Process on the dimension

• Question 227:

  You manage a SQL Server 2008 Analysis Services (SSAS) data warehouse for a school district. All tests are administered via a third-party application. Results are collected in your SSAS data warehouse and moved to a Scores fact table for

  analysis. This warehouse also includes a Student Dimension which contains attributes related to each student.

  The school year is starting, and the district administration wants the Student Dimension updated hourly so that new students can be identified and tracked. However, test scores located in the Scores fact table should not be updated as part of

  this incremental processing strategy.

  You need to implement this functionality. Which option should you use?

  A. Process Update
  B. Process Add
  C. Process Index
  D. Process Full
  B. Process Add

• Question 228:

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

  A developer accidentally deploys 1000 reports to the SSRS instance.

  You need to restore the SSRS instance to its original state.

  Which database should you restore?

  A. The master database
  B. The MSDB database
  C. The Report Server database
  D. The Report Server Temporary database
  C. The Report Server database

• Question 229:

  You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. You make before caching enable for a partition.

  You should make sure that SSAS could search connected information when You could update many aspects storage.

  Which is the correct answer?

  A. You should configure the attribute of ProcessingMode the partition to Immediate.
  B. You should configure the attribute of ProcessingMode the partition to LazyAggregations.
  C. You should configure the attribute of ProcessingMode the partition to OnCacheComplete.
  D. You should configure the attribute of ProcessingMode the partition to Common.
  A. You should configure the attribute of ProcessingMode the partition to Immediate.

  ---

  ProcessingMode Defines the place in the cube processing at which data becomes available to users. By default, ProcessingMode is set to Regular, and users cannot access the measure group until processing is complete. If ProcessingMode is set to LazyAggregations, data is accessible as soon as it is processed, but processing takes longer.

• Question 230:

  You are creating a Microsoft SQL Server 2005 Analysis Services (SSAS) project for Company.com. In order to move database from Analysis Services 2000 to Analysis Services 2008, which is the correct answer?

  A. You should close a new SSAS project by using Business Intelligence Development Studio (BIDS). Rightclick Project. Click the Add option, and then click the Existing Item option.
  B. You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server 2005 Reporting Services (SSRS). Right-click Instance in Object Explorer, and then click the
  C. You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server 2005 Integration Services (SSIS). Right-click Instance in Object Explorer, and then click the
  D. You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server Management Studio (SSMS). Right-click Instance in Object Explorer, and then click the Migrate
  D. You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server Management Studio (SSMS). Right-click Instance in Object Explorer, and then click the Migrate