Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 171:

  You are developing a SQL Server 2008 Reporting Services (SSRS) report which includes a table and a matrix which utilize the dataset that searches data through running a stored procedure for Company.com.

  You should make sure that which is showed in the table while ensuring that the matrix is running normally.

  Which is the correct answer?

  A. You should increase a filter to the dataset and table.
  B. You should delete a filter to the matrix.
  C. You should increase a filter to the table.
  D. You should modify the configurations of SQL Server 2008 Reporting Services (SSRS) report
  C. You should increase a filter to the table.

• Question 172:

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

  

  A data flow task contained in a For Loop container

  

  A Flat File destination component that uses a Flat File connection manager

  

  An OnError event handler

  When an error occurs in the package, you plan to write diagnostic information from an expression that includes the version of the package to a text file.

  You need to ensure that the required information is written to the text file.

  What should you do?

  A. Use the VersionGUID variable.
  B. Use the ExecutionGUID variable.
  C. Use the SourceID variable.
  D. Use the TaskID variable.
  A. Use the VersionGUID variable.

• Question 173:

  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 a developer of a SQL Server 2008 Reporting Services (SSRS) for the company.

  You use SSRS to design a report with a dataset contained and a Table data region used. Besides, a column named FirstPicture is contained in the dataset. Now you get an order from your company CIO, according to his requirement, you need to make sure that the second character in the FirstPicture column makes group for the report items.

  Which option below would be chosen?

  A. =Second(Fields!FirstPicture.Value) in the Group properties dialog box should be used
  B. =Fields!FirstPicture.Value.Substring(0,1) in the Group properties dialog box should be used
  C. =Second(Fields!FirstPicture) in the Group properties dialog box should be used.
  D. =Fields!FirstPicture.Value in the Group properties dialog box should be used
  B. =Fields!FirstPicture.Value.Substring(0,1) in the Group properties dialog box should be used

• Question 174:

  You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The package should contain a Data Flow task with a Fuzzy Grouping transformation that creates data. You should browser the output data of the Fuzzy Grouping transformation to debug the package.

  Which is the correct answer?

  A. You should increase a Data Viewer object to the Data Flow task for constraints on the Fuzzy Grouping transformation.
  B. You should increase a DBCC SHRINKFILE to the Data Flow task for constraints on the Fuzzy Grouping transformation.
  C. You should increase a web service to the Data Flow task for constraints on the Fuzzy Grouping transformation.
  D. You should increase a Transactions log to the Data Flow task for constraints on the Fuzzy Grouping transformation.
  A. You should increase a Data Viewer object to the Data Flow task for constraints on the Fuzzy Grouping transformation.

  ---

  Fuzzy Grouping Associates column values with a set of rows based on similarity, for data cleansing. SSIS Designer runs the package and provides detailed visual feedback about the pipeline. Depending on the size of the reference data, you may notice a delay while the error-tolerant index (ETI) is built. The ETI is the main data structure that Fuzzy Lookup uses at run time. After the ETI is built, all the input rows are processed and the results are written to the destination. SSIS Designer gives you feedback about the progress of the pipeline by displaying the number of rows processed by each component. You can also place a Data Viewer on the pipeline by right- clicking the path between Fuzzy Lookup and the OLE DB destination. This allows you to visualize in real-time which rows Fuzzy Lookup has matched to your input rows. In addition to matching tuples, Fuzzy Lookup outputs a record-level similarity, individual column-level similarities, and a confidence score for each match result. For more information about these scores, see Interpreting the Results later in this paper.

• Question 175:

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

  Through utilizing a Dynamic Management View (DMV), you decide to troubleshoot query performance you should make sure that you could improve query sessions times. In order to solve the problem, which is the correct answer?

  A. You should utilize Discover_Log for DMV.
  B. You should utilize Discover_Link for DMV.
  C. You should utilize Discover_Commands for DMV.
  D. You should utilize Discover_request for DMV.
  C. You should utilize Discover_Commands for DMV.

• Question 176:

  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 a developer of a SQL Server 2008 Reporting Services (SSRS) for the company.

  To meet the business requirement, you develop a SSRS report with a parameter named @ProductPriceRangeID.

  Then you select a specific region to set the value of @ProductPriceRangeID in the report. In order to stop modifying the value of @ProductPriceRangeID, you have to configure the report. So of the methods below, which one would be used to

  configure the report?

  A. Set the Internal property to configure the report
  B. Remove the default values to configure the report
  C. Clear the Hidden property to configure the report
  D. Clear the Prompt value to configure the report.
  E. Set the Hidden property to configure the report
  A. Set the Internal property to configure the report

  ---

  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 177:

  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.

  There is a SQL Server 2008 Reporting Services (SSRS) instance. Now you are in charge of a report in this instance.

  Query parameters are contained in this report which queries the data source at random. Users are allowed to filter the contents of the report according to the query parameters. You perform this configuration on the report, making it be

  rendered from a report execution snapshot.

  You must make sure that parameters can still be used to filter the report after the configuration. So what action should you perform?

  A. A default value should be added to all parameters
  B. First, the queries should be moved to the stored procedures. Then populate and filter the datasets of the report by using the stored procedures.
  C. The datasets should be modified to use the Table query type
  D. First, from the dataset queries remove the filters. Then filter the datasets by using the parameters.
  D. First, from the dataset queries remove the filters. Then filter the datasets by using the parameters.

• Question 178:

  You are an ETL Developer for a mortgage company. You have two staging sources named Stg_Vendor and Stg_Loan that you need to load into a destination table named Loan. Stg_Vendor is a Microsoft Excel source.

  The following table shows Stg_Vendor (Excel source) sample data:

  

  The following table shows Stg_Loan sample data:

  

  The following table shows Loan sample data:

  

  You need to build the ETL package.

  What should you do? (To answer, drag the appropriate components to the correct locations in the answer area.

  Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)

  Select and Place:

  

  

  ---

  Note:

  * The excel data need to be converted.

  * Before the Merge Join we sort both data.

• Question 179:

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

  You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTotal and CostTotal.

  You need to derive the profit for each order without modifying the underlying data.

  What should you do?

  A. Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.
  B. Add a Named Calculation to the SalesOrder table, using OrderTotal, CostTotal as the expression.
  C. Add a Named Query to the DSV, using Select * From SalesOrder as the expression.
  D. Add a Named Calculation to the SalesOrder table, using OrderTotal - CostTotal as the expression.
  D. Add a Named Calculation to the SalesOrder table, using OrderTotal - CostTotal as the expression.

  ---

  Note: A named calculation is a SQL expression represented as a calculated column. This expression appears and behaves as a column in the table. A named calculation lets you extend the relational schema of existing tables or views in a data source view without modifying the tables or views in the underlying data source. For example, a common calculated value derived from the columns of a fact table can be expressed as a single named calculation in the data source view, instead of modifying the underlying database table or creating a view in the underlying database. A named calculation can also be used in place of calculated member in each cube based on the data source view. Named calculations are calculated during processing whereas calculated members are calculated at query time.

  A named calculation is also frequently used to construct a user friendly name for a dimension member.

  Reference: Define Named Calculations in a Data Source View (Analysis Services)

• Question 180:

  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.

  You are in charge of a SQL Server 2008 Reporting Services (SSRS) instance with several reports contained.

  Then you use the Business Intelligence Development Studio (BIDS) to have a report project configured on the instance.

  After the deployment, you notice that the test data sources of the report project substitute the production data sources on the instance, so you should find a solution to make sure that the deployment of the report project in future will not affect

  the existing reports, that is to say, all the data in the existing reports will not be changed or replaced.

  What action should you perform?

  A. You should have the TargetReportFolder property configured on the instance
  B. You should have the OverwriteReportFolder property configured on the instance
  C. You should have the OverwriteDataSources property configured on the instance
  D. You should have the TargetServerURL property configured on the instance
  E. You should have the TargetDataSourceFolder property configured on the instance
  C. You should have the OverwriteDataSources property configured on the instance