Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 131:

  You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been deployed to a production server that runs Windows

  Server 2008 R2 and SQL Server 2012.

  The package fails when executed on the production server.

  You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal.

  What should you do?

  A. Create a custom SSIS source component that encapsulates the 32-bit driver and compile it in 64-bit mode.
  B. Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
  C. Execute the package by using the 32-bit run-time option.
  D. Replace the SSIS Excel source with a SSIS Flat File source.
  C. Execute the package by using the 32-bit run-time option.

  ---

  * See step 3 below.

  To publish an Excel worksheet to Azure SQL Database, your package will contain a Data Flow Task, Excel Source task, and ADO NET Destination.

  

  Create an SSIS project.

  

  Drop a Data Flow Task onto the Control Flow design surface, and double click the Data Flow Task.

  

  Drop an Excel Source onto the Data Flow design surface.

  Note When using the Excel Source task on a 64-bit machine, set Run64BitRuntime to False.

• Question 132:

  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 Microsoft SQL Server 2012 junior developers. You are discussing Data Quality Services (DQS) Knowledge Bases.

  Which of the following is TRUE with regards to DQS Knowledge Bases?

  A. It is a repository of knowledge with reference to your data that enables you to understand your data and maintain its integrity.
  B. It creates and evaluates expressions that set variable values at runtime.
  C. It runs an application or batch file as part of a SQL Server Integration Services package workflow.
  D. It allows you to run SQL statements during package execution.
  A. It is a repository of knowledge with reference to your data that enables you to understand your data and maintain its integrity.

• Question 133:

  You work as a database administrator 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 recently created an SQL Server Integration Services (SSIS) project catalog that contains two Environments. A single Environment Variable, named ConnectionString, of type string is specified by each environment. The project also

  has a project Connection Manager configured to link up with the data warehouse.

  You have been instructed to make sure that deployed packages are executed using any of the specified Environments.

  Which of the following suitably describes an Environment Variable?

  A. An environment variable specifies the data that will be used by a package.
  B. An environment variable can be used to manage Integration Services objects in the catalog.
  C. An environment variable defines a literal value that can be assigned to a parameter during package execution.
  D. An environment variable allows you to use folders to organize your projects and environments.
  E. An environment variable is a container of variables that can be referenced by Integration Services projects.
  C. An environment variable defines a literal value that can be assigned to a parameter during package execution.

• Question 134:

  You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You are developing the part of the SSIS package that populates the ProjectDates dimension table. The business key of the ProjectDates table is the ProjectName column. The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table:

  ExpectedStartDate - New values should be tracked over time.

  ActualStartDate - New values should not be accepted.

  ExpectedEndDate - New values should replace existing values.

  ActualEndDate - New values should be tracked over time.

  You use the SSIS Slowly Changing Dimension Transformation.

  You must configure the Change Type value for each source column.

  Which settings should you select? (To answer, select the appropriate setting or settings in the answer area. Each Change Type may be used once, more than once, or not at all.)

  Select and Place:

  

  

• Question 135:

  You are developing a SQL Server Integration Services (SSIS) package.

  You need to design a package to change a variable value during package execution by using the least amount of development effort.

  What should you use?

  A. Term Lookup transformation
  B. Expression task
  C. Data Profiling task
  D. Fuzzy Lookup transformation
  E. Data Cleansing transformation
  B. Expression task

  ---

  The Expression Task creates and evaluates expressions that set variable values at runtime, using the Expression Builder. References: http://msdn.microsoft.com/en-us/library/hh213137.aspx

• Question 136:

  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. Every evening data is copied to a directory automatically, via an external FTP procedure. You want to make sure that the package loads this data into a

  SQL Server destination table. You have configure the use of a Foreach ADO enumerator, and configured the ADO object source variable.

  Which of the following actions should you take NEXT?

  A. You should consider creating a task host container.
  B. You should consider creating a Sequence container.
  C. You should consider creating a For Loop container.
  D. You should consider creating a Foreach Loop container.
  C. You should consider creating a For Loop container.

• Question 137:

  You are developing a SQL Server Integration Services (SSIS) package that loads data from a source transactional system to several tables in a data warehouse.

  You discover that one of the data flows loads incorrect data to one of the destination tables.

  You need to identify the cause of the incorrect data flow.

  Which tool should you use?

  A. a data viewer
  B. the Locals window
  C. SSIS logging
  D. a breakpoint
  A. a data viewer

• Question 138:

  A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse. The SSIS catalog includes two Environments:

  Test

  Production

  Each Environment defines a single Environment Variable named ConnectionString of type string. The value of each variable consists of the connection string to the test or production data warehouses.

  You need to execute deployed packages by using either of the defined Environments.

  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:

  

  

• Question 139:

  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 package configurations.

  Which of the following are benefits of package configurations? (Choose all that apply.)

  A. It beneficial when deploying packages to numerous diverse servers.
  B. It enables you to perform data cleansing on your source data by using the knowledge in a DQS knowledge base.
  C. It simplifies the transfer of packages from a development environment to a production environment.
  D. It allows you to perform data matching on your source data by using the matching policy in a knowledge base.
  E. It allows for packages to have greater flexibility.
  A. It beneficial when deploying packages to numerous diverse servers.
  C. It simplifies the transfer of packages from a development environment to a production environment.
  E. It allows for packages to have greater flexibility.

• Question 140:

  You work as a senior database administrator 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 data flow to load sales data into a fact table. You have configured a full cache mode Lookup Transformation in the data flow to find the product data for sales. Two tables host the lookup source for the

  product data. You then access the Connection Page of the Lookup Transformation Editor.

  Which of the following is a reason for doing this?

  A. To configure a suitable connection manager.
  B. To configure partial caching.
  C. To modify the SQL statement for the Lookup transformation.
  D. To specify the join between the source table and the reference table.
  A. To configure a suitable connection manager.