Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 121:

  You implement a SQL Server 2008 Integration Services (SSIS) package. The package contains the following components:

  

  A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit button.)

  

  A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the Exhibit button.)

  

  A String variable named FileName.

  

  A String variable named DirectoryPath.

  

  

  You need to update the package so that the DirectoryPath variable returns the directory path for the file path stored in the FileName variable. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

  A. Set the RaiseChangedEvent property of the User::FileName variable to True.
  B. Set the EvaluateAsExpression property of the User::DirectoryPath variable to True.
  C. Add a Script task to the OnPostExecute event handler of the Foreach Loop container.
  D. Set the Expression property of the User::DirectoryPath variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) - FINDSTRING( REVERSE( @ [User::FileName] ), "\\", 1 ))
  E. Set the Expression property of the User::FileName variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) - FINDSTRING( REVERSE( @ [User::FileName] ), "\\", 1 ))
  B. Set the EvaluateAsExpression property of the User::DirectoryPath variable to True.
  D. Set the Expression property of the User::DirectoryPath variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) - FINDSTRING( REVERSE( @ [User::FileName] ), "\\", 1 ))

• Question 122:

  You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The SSIS package must contain six Data Flow tasks and three Control Flow tasks. You should alter the package .Which is the correct answer?

  A. You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Supported.
  B. You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Disabled.
  C. You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Required.
  D. You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to RequiredNew.
  C. You should increase the two Control Flow tasks and one Data Flow task to a container. Change the TransactionOption property of the container to Required.

  ---

  If a series of tasks must be completed as a single unit in which either all the tasks are successful and committed or an error occurs and none of the tasks are committed, place the tasks within a Sequence Container and then set the TransactionOption property of the container to Required

• Question 123:

  You are an ETL developer for a mortgage company. In your application you have to load data from a Microsoft Excel source and an OLE DB source.

  The Excel source contains vendor data and has approximately 1000 records.

  The OLE DB source contains loan data and has approximately 1,000,000 records.

  Sample vendor data (Excel source) is shown in the following table:

  

  Sample loan data (OLE DB source) is shown in the following table:

  

  The CIO asks you to generate an Excel file with the loan list information for each vendor. You build a SQL Server 2008 Integration Services (SSIS) package that can generate the Excel files dynamically. The Excel files should have the vendor name as the prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).

  You get the error message shown in the exhibit. (Click the Exhibit button.)

  

  You need to sort both sources in order to merge join the data. What should you do?

  A. Sort the data in the select statement of the OLE DB source and use Sort transformation after the Excel source.
  B. Set the IsSorted property to True for OLE DB, sort the data in the select statement of the OLE DB source, and use Sort transformation after the Excel source.
  C. Set the IsSorted property to True for both the OLE DB and Excel sources.
  D. Use Sort transformation after the OLE DB source and set the IsSorted property to True for the Excel destination.
  B. Set the IsSorted property to True for OLE DB, sort the data in the select statement of the OLE DB source, and use Sort transformation after the Excel source.

• Question 124:

  You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a data source view (DSV) which owns a table called Worker for Company.com. There are some columns in the Worker below

  *

  WorkerKey

  *

  BossKey

  The BossKey column references the manager of the Workers. You should make sure that you should create the relationship between the workers and their boss in the DSV.

  Which is the correct answer?

  A. You should develop a Calculation which utilizes WorkerKey and BossKey
  B. You should develop a View which utilizes a relationship with WorkerKey as the source column and BossKey as the destination column.
  C. You should develop a Query which utilizes a relationship with WorkerKey as the source column and BossKey as the destination column.
  D. through utilizing BossKey, you should develop a relationship as the source column and WorkerKey as the destination column.
  D. through utilizing BossKey, you should develop a relationship as the source column and WorkerKey as the destination column.

• Question 125:

  You are developing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. You should make sure that you could set the analysis services search log for the SSAS sample. Which is the correct answer?

  A. You should utilize a SQL Server 2008 Integration Services (SSIS)
  B. You should utilize SQL Server Management Studio.
  C. You should utilize Transactions Log Tool
  D. You should utilize Web Service Tool
  B. You should utilize SQL Server Management Studio.

• Question 126:

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

  You change the DataDir property of the instance to a new folder.

  You need to ensure that the instance uses the new folder in the minimum amount of downtime.

  What should you do?

  A. Process the database.
  B. Synchronize the database.
  C. Restart the Analysis Services service.
  D. Delete the files in the original folder, and then restart the Analysis Services service.
  A. Process the database.

• Question 127:

  You are managing a SQL Server 2008 Reporting Services (SSRS) sample for Company.com.

  A developer called Clerk published a lot of reports to the SSRS sample by accidents. You should make sure that you should recovery the before status for the SSRS sample

  Which is the correct answer?

  A. You should recovery the tempdb database
  B. You should recovery the default database
  C. You should recovery the Report Server database
  D. You should recovery the system database
  C. You should recovery the Report Server database

• Question 128:

  You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method.

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

  A. You should utilize ProcessAdd for Analysis (XMLA) command
  B. You should utilize default command for Analysis (XMLA)
  C. You should utilize ProcessNone for Analysis (XMLA) command
  D. You should utilize ProcessView for Analysis (XMLA) command
  A. You should utilize ProcessAdd for Analysis (XMLA) command

  ---

  BEST PRACTICES CONSIDER FULLY PROCESSING THE ENTIRE DATABASE fully processing the entire SSAS database is the cleanest and easiest solution to process all objects in the database, but it is not necessarily the fastest. Because SSAS processes objects in parallel and has a very effi cient processing architecture that can handle some 10,000 records per second, you might fi nd that you can process even large cubes within a reasonable time frame. Consider more advanced processing options, such as incremental processing (ProcessUpdate), only when fully processing the database is not an option.

• Question 129:

  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.
  B. Set the InteractiveHeight property to 100.

  ---

  To control pagination, you specify page-related properties in the report definition. Each rendering extension varies in how it supports page properties and whether it supports pagination altogether. The same report will paginate differently

  depending on which rendering extension you use to view it.

  InteractiveHeight and InteractiveWidth are used by the HTML rendering extension to provide the equivalent of PageHeight and PageWidth. Because the HTML rendering extension dynamically resizes a report to accommodate drilldown,

  drillthrough, and show/hide features, the report server uses different properties to support pagination on dynamic pages.

  There is no maximum size for InteractiveHeight. A value of 0 is used to specify infinite height, regardless of the size designator it is paired with. When InteractiveHeight=0, the user can't see a report until all rendering completes.

  Incorrect answers:

  PageHeight and PageWidth properties are used by the PDF and Image rendering extensions to establish the regular occurrence of page breaks based on a physical measurement.

• Question 130:

  You create a data mining model by using SQL Server 2008 Analysis Services (SSAS).

  You create a mining structure by using the following Data Mining Extensions (DMX) code.

  CREATE MINING STRUCTURE [Bike Buyer](

  [Customer Key] LONG KEY,

  [Age] LONG DISCRETIZED(Automatic, 10),

  [Bike Buyer] LONG DISCRETE,

  [Commute Distance] TEXT DISCRETE,

  [Yearly Income] DOUBLE CONTINUOUS

  )

  You need to create a mining model that can be processed by using this mining structure. You also need to ensure that the model uses the Microsoft Decision Trees algorithm.

  Which DMX statement should you use?

  A. SELECT * INTO [Decision Tree] USING [Hicrosoft_Decision_Trees] FROM [Bike Buyer]
  B. CREATE MINING MODEL [Decision Tree] ( [Customer Key] LONG KEY, [Age] LONG DISCRETIZED(Automatic, 10), [Bike Buyer] LONG DISCRETE, [Commute Distance] TEXT DISCRETE, [Yearly Income] DOUBLE CONTINUOUS ) USING Microsoft_Decision_Trees
  C. ALTER MINING STRUCTURE [Bike Buyer] ADD MINING MODEL [Decision Tree] ( [Customer Key] , [Age], [Bike Buyer] PREDICT, [Commute Distance], [Yearly Income] ) USING Microsoft_Decision_Trees WITH DRILLTHROUGH INSERT INTO [Decision Tree] ( [Customer Key], [Age], [Bike Buyer], [Commute Distance], [Yearly Income] ) OPENQUERY ([Bike Buyer], 'Select [Customer Key], [Age], [Bike Buyer] , [Commute Distance],[Yearly Income]' )
  C. ALTER MINING STRUCTURE [Bike Buyer] ADD MINING MODEL [Decision Tree] ( [Customer Key] , [Age], [Bike Buyer] PREDICT, [Commute Distance], [Yearly Income] ) USING Microsoft_Decision_Trees WITH DRILLTHROUGH INSERT INTO [Decision Tree] ( [Customer Key], [Age], [Bike Buyer], [Commute Distance], [Yearly Income] ) OPENQUERY ([Bike Buyer], 'Select [Customer Key], [Age], [Bike Buyer] , [Commute Distance],[Yearly Income]' )