★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 70-463 Exam Dumps (PDF & VCE):
Available on:
https://www.certleader.com/70-463-dumps.html
It is impossible to pass Microsoft 70-463 exam without any help in the short term. Come to Testking soon and find the most advanced, correct and guaranteed Microsoft 70-463 practice questions. You will get a surprising result by our Replace Implementing a Data Warehouse with Microsoft SQL Server 2012 practice guides.
2021 Nov braindumps for 70-463:
Q71. You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.
The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.
What should you do?
A. Change the Exhaustive property to True.
B. Change the similarity threshold to 0.55.
C. Change the similarity threshold to 0.40.
D. Increase the maximum number of matches per lookup.
Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ms137786.aspx
Q72. You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of administrative effort and maximizing data flow performance.
What should you do?
A. Use an SSIS Script task that uses the custom assembly to parse the text data when inserting it.
B. Use an SSIS Script transformation that uses the custom assembly to parse the text data when inserting it.
C. Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.
D. Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.
Answer: B
Q73. You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database.
The package is allowed to connect to only one database. An Environment variable contains the name of the database.
The OLE DB project connection manager has been parameterized.
You need to configure the connection manager property to accept the value of the Environment variable.
Which property should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
Answer:
Q74. You are developing a SQL Server Integration Services (SSIS) package to insert new data into a data mart. The package uses a Lookup transformation to find matches between the source and destination.
The data flow has the following requirements:
. New rows must be inserted.
. Lookup failures must be written to a flat file.
In the Lookup transformation, the setting for rows with no matching entries is set to Redirect rows to no match output. You need to configure the package to direct data into the correct destinations.
How should you design the data flow outputs? (To answer, drag the appropriate transformation from the list of answer options to the correct location in the answer area.)
Answer:
Q75. 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. Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the appropriate parameter.
C. Restore only the DQS_MAIN and DQS_STAGING_DATA databases to another server as soon as possible.
D. Execute the DQS_MAIN.internal_core.InitServer stored procedure with the appropriate parameter.
Answer: B,D
Explanation: Steps to restore DQS Databases:
Restore DQS_MAIN database.
Restore the DQS_PROJECTS database.
Restore the DQS_STAGING_DATA database.
In Object Explorer, right-click the server, and then click.New Query.
In the Query Editor window, copy the following SQL statements, and
replace.<PASSWORD>.with the password that you provided during the DQS
installation for the database master key:
USE [DQS_MAIN]
GO
EXECUTE [internal_core].[RestoreDQDatabases] '<PASSWORD>'
GO
.Press F5 to execute the statements. Check the.Results.pane to verify that the statements have executed successfully.
Note:
* Backup and restore of SQL Server databases are common operations that database administrators perform for preventing loss of data in a case of disaster by recovering data from the backup databases. Data Quality Server is primarily implemented by two SQL Server databases: DQS_MAIN and DQS_PROJECTS. The backup and restore procedures of the Data Quality Services (DQS) databases are similar to any other SQL Server databases.
Leading 70-463 vtc:
Q76. You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.
A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has only the @CustomerID parameter of type INT.
A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.
You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)
Answer:
Q77. You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.
Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.
You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented.
What should you do?
A. Create a conformed dimension for the geography dimension.
B. Implement change tracking.
C. Create a degenerate dimension for the geography dimension.
D. Create a Type 2 slowly changing dimension for the geography dimension.
Answer: A
Q78. You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table named Orders in a SQL Azure database.
The company's auditing policies have the following requirements:
. An entry must be written to a dedicated SQL Server log table named OrderLog.
. The entry must be written as soon as the file upload task completes.
You need to meet the company's policy requirements. Which event handler should you use?
A. OnProgress
B. Onlnformation
C. OnPostExecute
D. OnComplete
Answer: C
Reference: http://msdn.microsoft.com/en-us/library/ms140223.aspx
Q79. You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. All packages in the project must log custom messages.
You need to produce reports that combine the custom log messages with the system-generated log messages. What should you do?
A. Use an event handler for OnError for the package.
B. Use an event handler for OnError for each data flow task.
C. Use an event handler for OnTaskFailed for the package.
D. View the job history for the SQL Server Agent job.
E. View the All Messages subsection of the All Executions report for the package.
F. Store the System::SourceID variable in the custom log table.
G. Store the System::ServerExecutionID variable in the custom log table.
H. Store the System::ExecutionInstanceGUID variable in the custom log table.
I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.
J. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow,
K. Deploy the project by using dtutil.exe with the /COPY DTS option.
L. Deploy the project by using dtutil.exe with the /COPY SQL option.
M. Deploy the .ispac file by using the Integration Services Deployment Wizard.
N. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
O. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
P. Create a SQL Server Agent job to execute the
SSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures.
Q. Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.
R. Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.
Answer: G
Q80. You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model- The model consists of two entities: one named Customer and one named State. You opened the Customer entity.
Currently, data stewards can enter any text value in the Customer entity's State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity.
You need to configure the State attribute of the Customer entity.
Which command should you use? (To answer, select the appropriate command in the answer area.)
Answer: