Microsoft 70-448 Online Practice Questions and Exam Preparation

Microsoft 70-448 Online Questions & Answers

• Question 251:

  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 you are in charge of a SQL Server Integration Services (SSIS) instance.

  The SSIS instance has the packages stored in a SQL Server 2008 instance while another SSIS instance had its packages stored in a shared directory.

  According to the order of your manager, you need to deploy the package from the SSIS instance to another

  SSIS instance.

  In order to achieve this goal, which command should be executed?

  A. The dtexecui command should be executed
  B. The dtswiza command should be executed
  C. The dtutil command should be executed
  D. The Dtexec command should be executed
  C. The dtutil command should be executed

  ---

  Manual package deployment You can move your SSIS packages to a destination folder by copying them manually, by using a source-control tool that handles file deployment, or by creating a script or an application that handles the deployment. If you store your package in SQL Server, you can either use the DTUtil command-line utility that comes with SSIS to deploy your packages to SQL Server or manually import them through SSMS.

  Using DTExecUI to Configure Package Execution The command-line executable file DTExec is a fully featured utility with broad parameterization capabilities. You can generate the command line manually by applying the command parameters to meet the execution circumstance, but to save time and avoid errors, you can use the command-line builder utility named DTExecUI. DTExecUI is a visual tool that naturally groups the command parameter options. The server on which you run DTExecUI must have SSIS installed. To open DTExecUI, type DTExecUI either from a command prompt or by choosing Start and then Run to open the Run dialog box. You can open the tool from the Run dialog box or from the command prompt without specifying the path. To use DTExecUI, follow these steps:

  1.

  Open the Execute Package Utility by executing DTExecUI either by choosing Start and then Run, and entering DTE xecUI in the Run dialog box, or through a command prompt.

  2.

  On the General property page, select the package for execution so that you can modify a property on the other pages. In the Package Source drop-down list, select File System, SSIS Package Store, or SQL Server, depending on where your package is located.

  3.

  After identifying the package location, select the specific package for execution. If your package is stored in SQL Server or the SSIS Package Store, you need to specify the connection details to the SQL Server 2008 server by providing the server name. SQL Server also requires you to either provide a user name and password or specify Windows Authentication. All location choices require that you specify the package in the Package box by clicking the ellipsis button to the right of the Package box.

  4.

  Next you need to specify how the package should be executed by configuring other package execution properties. Selecting the various property pages on the left from Configurations down through Verification will let you override settings such as connections, logging, and outputs. Table 4-3 describes the execution configuration options.

• Question 252:

  You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date dimension named Date along with a hierarchy named Calendar. The Calendar hierarchy has levels for the Year, Quarter, Month, and Date attributes. You need to create a named set that refers to the first seven months of the year 2007. Which expression should you write for the named set?

  A. PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
  B. PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
  C. ParallelPeriod([DimTime].[Yr-Qtr-Mth].[Year], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
  D. ParallelPeriod ([DimTime].[Yr-Qtr-Mth].[Month], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
  A. PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])

• Question 253:

  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.

  According to the requirement of the company CIO, you are using SQL Server 2008 Integration Services (SSIS) to create packages.

  The package connects to a third-party database server by using an OLE DB connection manager. Integrated Windows authentication is not supported by the database. A configuration file is created to configure the connection manager. The

  configuration file is added to the package after it is created.

  An error message pops up when the package executes.

  The error message says that the login step fails. Now you must solve this problem. So what should you do to successfully execute the package?

  A. In order to achieve this goal, you should use an indirect XML configuration
  B. In order to achieve this goal, you should edit the XML configuration file
  C. In order to achieve this goal, you should use a Microsoft ADO.NET connection manager while not an OLE DB connection manager
  D. In order to achieve this goal, you should run the package on the same server as the third-party database server
  B. In order to achieve this goal, you should edit the XML configuration file

• Question 254:

  You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

  You are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008 Reporting Services (SSRS).

  Now you are using SSRS to create a report and you attempt to have the report deployed on a report server.

  In order to have the report delivered to a dynamic list of subscribers regularly, a new subscription should be created on the report server.

  What action should you perform to achieve this goal?

  A. You should click the New Data-driven Subscription button after selecting the My Subscriptions page.
  B. You should click the New Data-driven Subscription button after selecting the report you created and clicking the Subscriptions tab
  C. You should click the New Subscription button after selecting the report you created and clicking the Subscriptions tab
  D. You should click the New Subscription button after selecting the My Subscriptions page.
  E. You should click the New Subscription button after selecting the report you created
  B. You should click the New Data-driven Subscription button after selecting the report you created and clicking the Subscriptions tab

• Question 255:

  You administer an instance of SQL Server Analysis Services (SSAS).

  To troubleshoot access rights issues, you need to find out which roles are applied to a user.

  Which event should you trace in Microsoft SQL Profiler?

  A. The Audit Login event
  B. The Audit Object Permissions event
  C. The Session Initialize event
  D. The Notification event
  B. The Audit Object Permissions event

• Question 256:

  You are creating a SQL Server 2008 Reporting Services (SSRS) report which would show from a SQL Server 2005 Analysis Services database for Company.com. You should make sure that the report shows member attributes and extended attributes. Which is the correct answer?

  A. You should utilize the Web Service.
  B. You should utilize the SQL Server Analysis Services data source.
  C. You should utilize the OLE DB for SQL Server data source.
  D. You should utilize the DBCC SHRINKFILE.
  B. You should utilize the SQL Server Analysis Services data source.

• Question 257:

  You are creating a SQL Server 2008 Integration Services (SSIS) data flow which gets information from two sources for Company.com.

  You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. Every source database is belongs to a different server and based on a SELECT statement which utilizes an ORDER BY clause.

  The data flow is listed below:

  You get error message below when you connect the paths from the two sources "Data Flow Task: The input is not sorted.

  The 'input "Merge Join Left Input" (80)' must be sorted."

  You should make sure that data from every search is contained in every row in the data flow. In order to solve the problem, which is the correct answer?

  A. You should increase a Lookup transformation for some data flows.
  B. You should increase a Lookup transformation for every data flow.
  C. You should refresh the sorting properties in each source component.
  D. You should choose a default transformation.
  C. You should refresh the sorting properties in each source component.

• Question 258:

  You maintain a SQL Server Integration Services (SSIS) instance that uses Windows Authentication.

  You need to determine if there is a package named DailyLoad in the MSDB database on the local instance of SQL Server.

  Which dtutil command syntax should you use?

  A. dtutil /SQL DailyLoad /EXISTS
  B. dtutil /SQL DailyLoad /USERNAME xyz /USERPASSWORD xxxxxx /EXISTS
  C. dtutil /DTS DailyLoad.dtsx /MOVE SQL;destPackage
  D. dtutil /File W:/DailyLoad.dtsx /EXISTS
  A. dtutil /SQL DailyLoad /EXISTS

• Question 259:

  You administer a SQL Server 2008 Reporting Services (SSRS) instance. The instance contains several reports that use stored credentials to access data from a SQL Server 2008 instance.

  A computer that hosts the instance recovers from a hardware failure and has a newly installed SSRS instance.

  You need to ensure that the reports hosted on the instance continue to function correctly. What should you do?

  A. Reinitialize the Report Server.
  B. Restore the encryption keys.
  C. Recreate the Report Server database.
  D. Recreate the encryption keys.
  B. Restore the encryption keys.

  ---

  Managing the Encryption Keys is a core to any SQLRS database recoveries that may need to be done. It is therefore recommended that those responsible for supporting SQLRS instances familiarise themselves with the concepts discussed SQLRS Books Online (BOL) under "Managing Encryption Keys"

  During setup SQLRS creates encryption keys, which are then used to secure credentials, connection information, and accounts that are used in server operations. As soon as you finish installing SQLRS, you should make a copy of the symmetric key. If you ever need to repair a Reporting Services installation due to changes in computer name, instance name, or user account values, you can apply the key to make the report server database operational.

• Question 260:

  You administer an instance of SQL Server 2008 Reporting Services.

  You deploy various drill-down reports to the server. When users render these reports, detail information that must be hidden by default is always present.

  You need to ensure that users use an appropriate rendering extension that supports the toggling of visibility.

  Which rendering extensions should the users select?

  A. PDF
  B. Excel
  C. HTML
  D. XML
  D. XML

  ---

  A rendering extension is a component or module of a report server that transforms report data and layout information into a device-specific format. SQL Server Reporting Services includes seven rendering extensions: HTML, Excel, Word,

  CSV or Text, XML, Image, and PDF.

  Reports that are rendered using the XML rendering extension also follow these rules:

  XML elements and attributes are rendered in the order that they appear in the report definition.

  Pagination is ignored.

  Page headers and footers are not rendered.

  Hidden items that cannot be made visible by toggling are not rendered. Initially visible items and hidden items that can be made visible through a toggle are rendered.

  Images, lines, and custom report items are ignored.