Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 241:

  You are developing a SQL Server 2008 Integration Services (SSIS) project in Business Intelligence Development Studio. 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. Build the Integration Services project.
  B. Modify the AllowConfigurationChanges property of the project.
  C. Copy each package. Rename each copy with a .SSISDeploymentManifest file extension.
  D. View the code of each Data Transformation Services (DTS) package. Copy the first xml node to a file with a .SSISDeploymentManifest file extension.
  A. Build the Integration Services project.

• Question 242:

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

  You plan to document the Analysis Services performance information.

  You need to collect information related to the temporary file usage when the database is processed.

  Which object should you use?

  A. MSAS 2008: Memory
  B. MSAS 2008: Cache
  C. MSAS 2008: Proc Aggregations
  D. MSAS 2008: Storage Engine Query
  C. MSAS 2008: Proc Aggregations

• Question 243:

  You work for an organization with global operations. You are responsible for the SQL Server 2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and weekly feeds. These packages are deployed via the SQL

  Server method.

  The servers reside in geographies with a high risk of natural disaster.

  You need to implement a disaster recovery plan to back up the SSIS packages for availability.

  What should you back up?

  A. The model database
  B. The package folder
  C. The master database
  D. The MSDB database
  D. The MSDB database

• Question 244:

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

  Your instance supports several different rendering extensions.

  You need to configure the server so that all reports render only to Microsoft Excel.

  What should you do?

  A. Modify the RSMgrPolicy.config file.
  B. Modify the Web.config file.
  C. Modify the Global.asax file.
  D. Modify the RSReportServer.config file.
  D. Modify the RSReportServer.config file.

  ---

  You can specify rendering extension parameters in the RSReportServer configuration file to override default report rendering behavior for reports that run on a Reporting Services report server. You can modify rendering extension parameters

  to achieve the following objectives:

  Change how the rendering extension name appears in the Export list of the report toolbar (for example, to change "Web archive" to "MHTML"), or localize the name to a different language.

  Create multiple instances of the same rendering extension to support different report presentation options (for example, a portrait and landscape mode version of the Image rendering extension).

  Change the default rendering extension parameters to use different values (for example, the Image rendering extension uses TIFF as the default output format; you can modify the extension parameters to use EMF instead).

• Question 245:

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

  You plan to process a cube by using an XML for Analysis (XMLA) script.

  You need to ensure that aggregations are populated.

  What should you do?

  A. Execute a processIndex command.
  B. Execute a processUpdate command.
  C. Execute a processStructure command.
  D. Execute a processData command.
  A. Execute a processIndex command.

• Question 246:

  You are working as reporting administrator for a product development company. The company uses SQL Server 2008 Reporting Services (SSRS) deployed in native mode.

  You need to deploy multiple reports via InstallShield.

  Which three components are you required to use? (Each correct answer presents part of the solution.

  Choose three.)

  A. Report Builder
  B. rs.exe
  C. rsconfig utility
  D. ReportService2010.asmx
  E. .rss file
  B. rs.exe
  C. rsconfig utility
  E. .rss file

  ---

  B: rs Utility (rs.exe) (SSRS)

  Processes script you provide in an input file. Use this utility to automate report server deployment and administration tasks.

  Example:

  rs i c:\scriptfiles\script_copycontent.rss -s http://localhost/reportserver

  C: The rsconfig.exe utility encrypts and stores connection and account values in the RSReportServer.config file. Encrypted values include report server database connection information and account values used for unattended report processing.

  E: The script [used as input to rs.exe] must be written in Visual Basic .NET code, and stored in a Unicode or UTF-8 text file with an .rss file name extension. You cannot debug scripts with the rs utility. To debug a script, run the code within Microsoft Visual Studio.

  Incorrect:

  Not A: Report Builder is a report authoring environment for business users who prefer to work in the Microsoft Office environment. When you design a report, you specify where to get the data, which data to get, and how to display the data.

  When you run the report, the report processor takes all the information you have specified, retrieves the data, and combines it with the report layout to generate the report.

  Reference: rs Utility (rs.exe) (SSRS)

• Question 247:

  You develop a report by using SQL Server 2008 Reporting Services (SSRS).

  The report has a dataset that contains 25 columns of data. You plan to render the dataset to a Microsoft Office Excel worksheet.

  You need to ensure that the report columns are properly aligned when rendering to Excel.

  Which type of data region should you use?

  A. List
  B. Table
  C. Rectangle
  D. Matrix
  B. Table

  ---

  Tables in reports are rendered as rows and columns of cells in Excel. Page breaks on report items inside a table cell are ignored.

  Note: A data region is an area on a report containing data from a data source. Types of data regions are charts, lists, tables, and matrices.

  Incorrect answers:

  List elements show only their contents. The list is rendered for each data row or data group in Excel. Items in the list are positioned on the worksheet relative to their location in the report, which can lead to unexpected results. For this reason,

  lists are not recommended for incorporation in reports designed to be rendered in Excel.

  Matrices in reports are rendered as a set of formatted cells in the Excel file, much like the report in HTML. Matrix subtotals are not rendered as formulas, and the matrix is not rendered as an Excel PivotTable. Matrix data regions are fully

  expanded when rendered in Excel. If you hide all or part of a matrix at design time, at run time the hidden property is ignored and all rows and columns are visible in the report.

• Question 248:

  You are developing a sales report by using SQL Server 2008 Reporting Services (SSRS).

  The report contains a table.

  You need to implement a technology that allows users to open a new report when they click on a field in a table.

  Which SSRS technology should you use?

  A. Subreport
  B. Tablix Data Region
  C. Drillthrough action
  D. Interactive Sorting
  C. Drillthrough action

• Question 249:

  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 and you use it to create a report, which is so complex that it needs a few minutes to generate.

  Now you are assigned a task to find a solution to configure the report server so that it can be cached for half an hour after the original request.

  Which solution should be chosen to accomplish this task?

  A. The solution of using snapshot isolation to configure the data source would be chosen to accomplish this task
  B. The solution of using a database snapshot to configure the data source would be chosen to accomplish this task
  C. The solution of implementing report snapshots would be chosen to accomplish this task
  D. The solution of implementing report execution caching would be chosen to accomplish this task.
  D. The solution of implementing report execution caching would be chosen to accomplish this task.

  ---

  Using Report Caching Reporting Services has two mechanisms to reduce the overhead associated with a large number of concurrent users, large datasets, and long-running queries: report caching and report snapshots. Report snapshots are reviewed in the next section. By default, a report is rendered using the most recent data. This means that every execution starts by reading the database data. This could be a large processing burden on a production server. To reduce the load on your server, you can cache a temporary copy of a report. SSRS caches the report in the ReportServer database with all the data but without any of the rendering information. If a report exists in the cache, when the next user runs the report, the user gets the data from the cache, and there is no need to reread data from the database. Because the rendering information is not stored in the cache, a user can use any rendering format on the data.

  The data in the cache might become outdated after time, so you can define an expiration period for the cached report. You can define an expiration time in minutes, or you can force expiration on a shared or report-specific schedule. The Execution properties are grouped by caching options, report execution snapshot, and report execution time-out. After caching is enabled and the report is run for the first time after you enabled caching, the server stores the report data, and you can specify when the cache expires in one of two ways. First, the cache can be invalidated by specifying a number of minutes for which the cache is valid or by defining a report-specific schedule, or second, the cache can be invalidated through a shared schedule. The cache of a report will also be invalid if the data source credentials are changed or no longer stored on the report server.

  To enable caching for a report, you can choose the Expire Copy Of Report After A Number Of Minutes option and set the expiration minutes. Alternatively, you can choose the Expire Copy of Report on the Following Schedule option and then select the Report-Specific.

  If you cache a report, the first user who runs the report after the cache has expired will have to wait longer to view the report than the users who follow, because the fi rst user triggers the data being read from the database.

• Question 250:

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

  The instance contains a large number of reports that take a long time to execute. The reports contain multiple execution snapshots.

  You have a new production server along with SSRS installed.

  You need to migrate the reports and their snapshots to the production server in the minimum amount of time.

  What should you do?

  A. Use the rs.exe utility.
  B. Use the rskeymgmt.exe utility.
  C. Deploy the solutions by using Business Intelligence Development Studio (BIDS).
  D. Copy the Report Server databases to the production server. Configure the server by using the Reporting Services Configuration tool.
  D. Copy the Report Server databases to the production server. Configure the server by using the Reporting Services Configuration tool.