Free Microsoft 070-463 Exam Dumps Questions & Answers

You have Master Data Services (MDS) in a SQL Server deployment. You need to deploy a model that contains data to the MDS repository. What should you use?

• A.the Model Deployment Wizard
• B.the Master Data Services Configuration Manager tool
• C.the MDSModelDeploy tool
• D.the Integration Services Deployment Wizard

You are a database developer of a Microsoft SQL Server 2012 database. You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this data is as shown in the following table. You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to ensure that the data in the table is in the order of SourceID and then CustomerID.
Which Transact- SQL statement should you use?

• A.CREATE TABLE Customer
  (SourceID int NOT NULL,
  CustomerID int NOT NULL PRIMARY KEY CLUSTERED,
  CustomerName varchar(255) NOT NULL);
• B.CREATE TABLE Customer
  (SourceID int NOT NULL PRIMARY KEY CLUSTERED,
  CustomerID int NOT NULL UNIQUE,
  CustomerName varchar(255) NOT NULL);
• C.CREATE TABLE Customer
  (SourceID int NOT NULL,
  CustomerID int NOT NULL,
  CustomerName varchar(255) NOT NULL,
  CONSTRAINT PK_Customer PRIMARY KEY CLUSTERED
  (SourceID, CustomerID));
• D.CREATE TABLE Customer
  (SourceID int NOT NULL IDENTITY,
  CustomerID int NOT NULL IDENTITY,
  CustomerName varchar(255) NOT NULL);

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.Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
• B.Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
• C.Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
• D.Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
• E.Select the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor.

You are the administrator of a server that hosts Data Quality Server for a large retail company.
The server had a hardware failure during business hours.
You need to restore the server that hosts Data Quality Server to another server. You have a recent backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to another server as soon as possible.
• B.Restore only the DQS_MAIN and DQS_STAGING_DATA databases to another server as soon as possible.
• C.Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the appropriate parameter.
• D.Execute the DQS_MAIN.internal_core.InitServer stored procedure with the appropriate parameter.

You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD).
You need to add a task or component to the package that allows you to implement the SCD logic.
What should you use?

• A.a Script component
• B.an Aggregate component
• C.an SCD component
• D.a Merge component