Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 291:

  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 Master Data Services (MDS) in their environment.

  You have been asked to make sure that a user, named Mia Hamm, has the ability to create a Subscription View in Master Data Services (MDS).

  Which of the following does Mia Hamm require? (Choose all that apply.)

  A. Write permissions.
  B. Model administrator permissions.
  C. Read permissions.
  D. Permission to access the Integration Management functional area.
  E. Read/Write permissions.
  B. Model administrator permissions.
  D. Permission to access the Integration Management functional area.

• Question 292:

  You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.

  The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.

  The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project.

  You need to meet the requirements by using the least amount of administrative effort.

  What should you do?

  A. Create one XML configuration file. Add a connections string for each target server. Choose the appropriate server in the package at build time.
  B. For each target server, create a separate package and include each package in the SSIS catalog. Run the appropriate server at package execution time.
  C. Create one registry configuration. Add a connection string for each target server. Choose the appropriate server in the package at build time.
  D. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.
  D. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.

• Question 293:

  You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation.

  The reference data to be used in the transformation does not change.

  You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance.

  What should you do?

  A. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
  B. Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
  C. Select the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor.
  D. Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
  E. Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
  A. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.

  ---

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

• Question 294:

  You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.

  You need to monitor control flow tasks to determine whether any of them are running longer than usual. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list ofactions to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

• Question 295:

  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 Advance Page of the Lookup Transformation Editor.

  Which of the following is a reason for doing this? (Choose all that apply.)

  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.
  B. To configure partial caching.
  C. To modify the SQL statement for the Lookup transformation.