70-463 Exam
Super to exam 70 463
It is impossible to pass Microsoft 70 463 exam exam without any help in the short term. Come to Examcollection soon and find the most advanced, correct and guaranteed Microsoft 70 463 pdf practice questions. You will get a surprising result by our Up to the immediate present Implementing a Data Warehouse with Microsoft SQL Server 2012 practice guides.
Q1. Topic 2)
You are the administrator for a Data Quality Server. You are adding a user who must have permission to:
Edit and execute a project
View the activity monitoring data
This user must not be able to:
Perform any kind of knowledge management
Create or change a knowledge base
Terminate an activity or perform administrative duties
You need to develop a Transact-SQL (T-SQL) script to meet these requirements.
What should you do? (To answer, drag the appropriate code segment or segments to the correct location or locations in the answer area.)
Answer:
Q2. 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:
Q3. You are loading a dataset into SQL Server. The dataset contains numerous duplicates for the Artist and Song columns.
The values in the Artist column in the dataset must exactly match the values in the Artist domain in the knowledge base. The values in the Song column in the dataset can be a close match with the values in the Song domain.
You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to identify duplicates.
How should you configure the Rule Editor? (To answer, drag the appropriate answers to the answer area.)
Answer:
Q4. You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors.
Products for each distributor source must be combined for insertion into a single product table destination.
You need to select the appropriate data flow transformation to meet this requirement.
Which transformation types should you use? (Each correct answer presents a complete solution. Choose all that apply.)
A. Multicast
B. Merge Join
C. Term Extraction
D. union All
E. Merge
Answer: D,E
Reference: http://msdn.microsoft.com/en-us/library/ms141703.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms141775.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms141020.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms141809.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms137701.aspx
Q5. You are installing the Data Quality Client on user desktops.
You need to ensure that the prerequisite software components are installed.
Which components must be present to meet this goal? (Each correct answer presents part of the solution. Choose all that apply.)
A. SQL Server Management Studio
B. Internet Explorer 6.0 SP1 or later
C. Microsoft Silverlight 5
D. .NET Framework 3.5 SP1
E. .NET Framework 4.0
F. Microsoft Silverlight 4
G. SQL Server Data Tools
Answer: B,E
Explanation: Before installing DQS, make sure that your computer meets the minimum system requirements.
Data Quality Client requirement:
NET Framework 4.0 (installed during the Data Quality Client installation, if not already installed)
Internet Explorer 6.0 SP1 or later
Q6. You are developing a SQL Server Integration Services (SSIS) package. The package contains a user-defined variable named .Queue which has an initial value of 10.
The package control flow contains many tasks that must repeat execution until the .Queue variable equals 0.
You need to enable the tasks to be grouped together for repeat execution.
Which item should you add to the package? (To answer, select the appropriate item in the answer area.)
Answer:
Q7. You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.
The package reads data from a source system. Depending on the value in a source column, the package redirects rows to one of five different data flow paths.
You need to add a data flow transformation to support the package redirection.
Which data flow transformation should you use?
A. Conditional Split
B. pjvot
C. Multicast
D. Lookup
Answer: A
Q8. You are developing a SQL Server Integration Services (SSIS) package.
The package must run a parameterized query against a Windows Azure SQL Database
database.
You need to use the least amount of development effort to meet the package requirement.
Which task should you use? (To answer, select the appropriate task in the answer area.)
Answer:
Q9. You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition:
You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
The first row of the file contains the first row of data.
Each record is of the same length.
The date follows the U.S. date format.
The file supports international characters.
What should you do? (To answer, simply select the option or options in the answer area that you would configure.)
Answer:
Q10. 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