Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 31:

  To render correctly the report with dataset for 25 column to Excel what would you use

  A. Matrix
  B. Rectangular
  C. Table
  D. Lists
  C. Table

  ---

  http://technet.microsoft.com/en-us/library/cc966445.aspx

  Data Regions

  One of your first critical design decisions is which type of data region to use in your report. Reporting Services offers the following types of data regions:

  Tables A table represents data, row by row. The columns are static in that they do not expand, but the rows expand downward. Thus, as a table grows, it pushes the data beneath it downward.

  You can also group data within the table.

  Matrices

  A matrix, or crosstab, is like a table, but both columns and rows can expand to accommodate data. A matrix can push other report objects downward and outward on the report page. You can group data and also nest columns and rows within

  the matrix.

  Lists

  A list is a freeform data region that is often used for creating forms. You can nest lists within lists to group data.

  Charts

  A chart is a graphical representation of data. Reporting Services offers a wide range of chart formats. Your choice of data regions may depend on the type of data you are using, what you want the report to look like, and how you are rendering

  the report. For example, reports rendered to Microsoft?Excel?tend to work better when using a table instead of a list.

• Question 32:

  You are creating a SQL Server 2008 Integration Services (SSIS) data flow which increases information from a source search to a result table for Company.com. In order to increase those rows which could not include the destination table, which is the correct answer? (Select more than one)

  A. You should utilize the Data Conversion Transformation.
  B. You should utilize the Lookup transformation.
  C. You should utilize the Character Map Transformation.
  D. You should utilize the Merge Join transformation.
  E. You should utilize the Data Mining Query Transformation
  F. You should utilize the Term Extraction Transformation
  B. You should utilize the Lookup transformation.
  D. You should utilize the Merge Join transformation.

• Question 33:

  You are managing a SQL Server 2008 Reporting Services (SSRS) database server for Company.com. You find that it will cost so much time to run reports which include many execution snapshots in the instance.

  You own a new production server together with SSRS fixed. You should make sure that you could save time when you move the reports and their snapshots to the production server.

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

  A. You should utilize the default command.
  B. You should utilize the taskrun.exe command.
  C. You should publish the results through utilizing a Dynamic Management View (DMV)
  D. Before setting the server through utilizing the Reporting Services Configuration tool, you should transfer the Report Server databases to the production server.
  D. Before setting the server through utilizing the Reporting Services Configuration tool, you should transfer the Report Server databases to the production server.

• Question 34:

  You create a SQL Server 2008 Reporting Services (SSRS) report.

  The report contains a table that displays a list of products. The list of products includes the three fields named ProductName, ProductCategory, and ProductPrice. The table contains a textbox named ProductCategory that displays the

  ProductCategory field.

  The dataset is sorted by ProductCategory.

  You need to ensure that the report header displays the ProductCategory of the first product listed on each page of the report.

  Which code segment should you use in the report header?

  A. =Fields!ProductCategory.Value
  B. =First (Fields(ProductCategory.Value )
  C. =First( ReportItems ("ProductCategory ").Value)
  D. =ReportItems (" ProductCategory ") .Value
  D. =ReportItems (" ProductCategory ") .Value

  ---

  Page headers and footers can contain static content, but they are more commonly used to display varying content like page numbers or information about the contents of a page. To display variable data that is different on each page, you

  must use an expression.

  If there is only one dataset defined in the report, you can add simple expressions such as [FieldName] to a page header or footer. Drag the field from the Report Data pane dataset field collection or the Built-in Fields collection to the page header or page footer. A text box with the appropriate expression is automatically added for you.

  To calculate sums or other aggregates for values on the page, you can use aggregate expressions that specify ReportItems or the name of a dataset. The ReportItems collection is the collection of text boxes on each page after report rendering occurs. The dataset name must exist in the report definition.

• Question 35:

  You are a SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters named Region and City in that order. When the Region parameter is selected, the City parameter should be filtered by the Region selected.

  You need to enable this functionality.

  What should you do?

  A. Create a distinct dataset that includes all possible values and attach it to the parameter.
  B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
  C. Create a dynamic data source from a dataset by using the IN operator.
  D. Configure the Internal Visibility option for the parameter.
  E. Change the dataset from a shared dataset to an embedded dataset in the report.
  F. Create a dynamic data source from a dataset that includes a list of distinct servers.
  G. Create a dynamic dataset that includes a list of the different users.
  H. Configure the Hidden Visibility property.
  B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

• Question 36:

  You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. You decide to utilize SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You own a complex package which costs too much time

  You should make sure that the package could be restored if the package runs during a failover. Which is the correct answer?

  A. Before restarting the package whenever a failover happening you should run store procedure in your package.
  B. You should increase the SSIS service to the SQL Server cluster resource group.
  C. Before restarting the package whenever a failover happening you should run checkpoints in your package.
  D. Before restarting the package whenever a failover happens you should run transactions in your package.
  C. Before restarting the package whenever a failover happening you should run checkpoints in your package.

• Question 37:

  You are creating a SQL Server 2008 Integration Services (SSIS) instance for Company.com. The package is listed below:

  

  You should make sure that you create a parameter which includes important information that is only useful to the Data Flow Task and the Execute SQL Task and so on.

  Which is the correct answer?

  A. You should develop the parameter at the default scope.
  B. You should develop the parameter at the Control Flow Job scope.
  C. You should develop the parameter at the Running SQL Job scope.
  D. You should develop the parameter at the Sequence Container scope.
  D. You should develop the parameter at the Sequence Container scope.

• Question 38:

  You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a Data Flow task which reproduces some million rows for Company.com.

  The data flow asks a match against a reference table which includes 50,000 rows including every row would be utilized during the data flow in the reference table.

  You should make sure that the data flow runs least time.

  Which is the correct answer?

  A. You should choose a Lookup transformation along with the half cache option
  B. You should choose a Lookup transformation along with the Full cache option
  C. You should choose a default Lookup transformation
  D. You should choose a Lookup transformation along with the Default cache option
  B. You should choose a Lookup transformation along with the Full cache option

  ---

  EXAM TIP

  When trying to determine which transformation to use that brings more than one data source together, remember that the Merge Join Transformation brings two sorted sources together and matching rows together with either an Inner Join, a

  full outer Join, or a Left outer Join. Merge Join can match more than one row across the join columns. This behavior is different from that of the Lookup Transformation, which brings back only a single match across the join columns of the

  Lookup table. The union All Transformation does not join rows together but rather brings each row separately from the sources, stacking the rows together. The number of rows in the output of union All is the combined row counts of all the

  inputs. The Merge Transformation is similar to union All, except that the sources have to be sorted and the sort position is preserved. You could also use a Lookup Transformation to associate data from two sources. The Lookup can cache a

  table in memory and, through matching columns, can return new columns to the data flow.

  http://msdn.microsoft.com/en-us/library/bb895289.aspx

  You can configure the Lookup transformation to use full cache mode and a Cache connection manager. In full cache mode, the reference dataset is loaded into cache before the Lookup transformation runs.

• Question 39:

  You are creating a SQL Server 2008 Integration Services (SSIS) project for Company.com.

  Your project attributes are listed below:In order to develop a deployment manifest for packages in the project.

  Which is the correct answer?

  A. You should develop the Integration Services project.
  B. You should make the default property enable.
  C. You should reset every copy with a .config file extension.
  D. You should develop the Web Services project.
  A. You should develop the Integration Services project.

• Question 40:

  You are developing a SQL Server 2008 Reporting Services (SSRS) sample for Company.com. You decide to publish the report which would be moved on a common basis to a list of subscribers on a report server.

  You should make sure that you develop a novel subscription on the report server.

  Which is the correct answer?

  A. Before clicking the My Subscriptions button you should choose the developed report.
  B. Before clicking the My Subscriptions page you should choose the My Subscriptions page.
  C. Before clicking the Subscriptions tab you should choose the developed report and then click the New Data driven Subscription button.
  D. You should choose the developed report.
  C. Before clicking the Subscriptions tab you should choose the developed report and then click the New Data driven Subscription button.