Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 21:

  You work as a database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are in the process of designing a SQL Server Integration Services (SSIS) package that is saved in the file system. You want make use of the command prompt to load the package. Which of the following actions should you take?

  A. You should consider making use of dtutil /Fi from the command prompt.
  B. You should consider making use of dtexec /ISServer from the command prompt.
  C. You should consider making use of dtexec /f from the command prompt.
  D. You should consider making use of dtutil /Si from the command prompt.
  C. You should consider making use of dtexec /f from the command prompt.

• Question 22:

  You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages.

  The new capability is not available as an SSIS task. Each package must be extended with the same new capability.

  You need to add the new capability to all the packages without copying the code between packages.

  What should you do?

  A. Use the Expression task.
  B. Use the Script task.
  C. Develop a custom task.
  D. Use the Script component.
  E. Develop a custom component.
  C. Develop a custom task.

  ---

  References: http://msdn.microsoft.com/en-us/library/ms135965.aspx http://msdn.microsoft.com/en-us/library/ms345161.aspx

• Question 23:

  You have a secured database that contains all of the customer data for your company.

  You plan to use a project deployment model.

  You need to create a SQL Server Integration Services (SSIS) package that connects to the data base by using a dedicated username and password. The solution must ensure that the password used for the connection string is encrypted.

  Which two actions should you perform? Each correct answer presents part of the solution.

  A. Modify the set_execution_parameter_value stored procedure.
  B. Set the package protection level to EncryptSensitiveWithPassword.
  C. Select the Sensitive check box for the catalog environment.
  D. Set the sensitive property of the package parameter to True.
  E. Set the package protection level to EncryptSensitiveWithUserKey.
  B. Set the package protection level to EncryptSensitiveWithPassword.
  D. Set the sensitive property of the package parameter to True.

• Question 24:

  You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

  You are running a training exercise for ABC.com's database developers. You are currently discussing the transformations data flow component. You are highlighting the Derived Column type.

  Which of the following is TRUE with regards to the Derived Column type?

  A. It is used to obtain a randomly selected subset of an input dataset.
  B. It sorts input data in ascending or descending order and copies the sorted data to the transformation output.
  C. It makes a normalized data set into a less normalized but more compact version.
  D. It creates new column values by applying expressions to transformation input columns.
  E. It creates a sample data set by selecting a percentage of the transformation input rows.
  D. It creates new column values by applying expressions to transformation input columns.

• Question 25:

  You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on a Microsoft Azure SQL Database. The package contains a data flow task that has seven source-to-destination execution trees.

  Only three of the source-to-destination execution trees are running in parallel.

  You need to ensure that all the execution trees run in parallel. What should you do?

  A. Place the data flow task in a For Loop container that is configured to execute seven times.
  B. Set the EngineThreads property of the data flow task to 7.
  C. Create seven data flow tasks that contain one source-to-destination execution tree each.
  D. Set the MaxConcurrentExcecutables property of the package to 7.
  B. Set the EngineThreads property of the data flow task to 7.

• Question 26:

  You are implementing a new SQL Server Integration Services (SSIS) package that loads data from various flat files and a Microsoft Azure SQL Database database.

  Daily transactions must be loaded into a staging database. All the SSIS tasks will use the CurrentDate variable date.

  You need to set the CurrentDate variable to the date stored in a control table of the Windows Azure SQL Database database when the package starts. You need to achieve this goal by using the least amount of development effort.

  What should you use to set the variable?

  A. an Expression task
  B. an Execute SQL task
  C. a Script component
  D. a Script task
  A. an Expression task

  ---

  Property expression is an expression that is assigned to a property to enable dynamic update of the property at run time. For example, a property expression can update the To line that a Send Mail task uses by inserting an e-mail address

  that is stored in a variable.

  An expression can be added to a package, task, Foreach Loop, For Loop, Sequence, Foreach enumerator, event handler, a package or project level connection manager, or log provider. Any property of these objects that is read/write can

  implement a property expression. Integration Services also supports the use of property expressions in some custom properties of data flow components. Variables and precedence constraints do not support property expressions, but they

  include special properties in which you can use expressions.

  Property expressions can be updated in different ways:

  User-defined variables can be included in package configurations and then updated when the package is deployed. At run time, the property expression is evaluated using the updated variable value. System variables that are included in

  expressions are updated at run time, which changes the results of the property evaluation.

  Date and time functions are evaluated at run time and provide the updated values to property expressions.

  Variables in expressions can be updated by the scripts that the Script task and the Script component run.

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

  http://blog.sqltechie.com/2012/11/expression-task-in-ssis-2012.html

• Question 27:

  You work as a database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

  You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured upload a file to a table in a SQL Azure database. You need to make sure that the code includes an event handler that

  makes use of an executable to raise the event directly after it has finished running.

  Which of the following is the event handler that you should use?

  A. The OnPostExecute event handler.
  B. The OnTaskFailed event handler.
  C. The OnPreExecute event handler.
  D. The OnPostValidate event handler.
  A. The OnPostExecute event handler.

• Question 28:

  You work as a database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

  You have been asked to revise a SQL Server Integration Services (SSIS) package. The package only includes Execute SQL tasks.

  To make sure that, in the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back. To do this, you want to alter the TransactionOption property of the package.

  Which of the following is the value that must be set for the TransactionOption property of the package?

  A. NotSupported.
  B. Supported.
  C. NotRequired.
  D. Required.
  D. Required.

• Question 29:

  You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.

  You have the following requirements:

  

  The deployment model must support changing the content of connection strings by using parameters at execution time.

  

  The deployment model must automatically log events to the SSISDB database.

  

  Maximize performance at execution time.

  You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

  A. Use a project deployment model. Modify connection manager properties to use project parameters.
  B. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
  C. Use a package deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.
  D. Use a project deployment model. Modify connection manager properties to use package parameters.
  A. Use a project deployment model. Modify connection manager properties to use project parameters.

• Question 30:

  You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom functionality that is implemented in Microsoft Visual C.

  The implementation of the custom functionality changes overtime. The design of the package allows you to deploy new releases of the custom functionality without redeploying the entire package.

  You need to implement and deploy an update to the custom functionality without requiring package redeployment.

  Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

  Select and Place: