Advanced Guide: pdf exam 70-463

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 Latest Implementing a Data Warehouse with Microsoft SQL Server 2012 practice guides.

2016 Sep exam 70-463 sample test:

Q145. 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.) 


Answer: 



Q146. You are developing a data flow to load sales data into a fact table. In the data flow, you configure a Lookup Transformation in full cache mode to look up the product data for the sale. 

The lookup source for the product data is contained in two tables. 

You need to set the data source for the lookup to be a query that combines the two tables. 

Which page of the Lookup Transformation Editor should you select to configure the query? To answer, select the appropriate page in the answer area. 


Answer: 



Q147. 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 changes with every package execution. 

Common language runtime (CLR) integration cannot be enabled on the SQL Server database where the reference table is located. 

You need to configure the Fuzzy Lookup transformation in the most efficient manner. 

What should you do? 

A. Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure. 

B. Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor. 

C. Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure. 

D. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor. 

Answer: B 


Q148. You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to Supported. 

You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes. 

What should you do? 

A. Move the three Execute SQL tasks into a Sequence container. 

B. Move the three Execute SQL tasks into a Foreach Loop container. 

C. Change the TransactionOption property of all three Execute SQL tasks to Required. 

D. Change the TransactionOption property of the package to Required. 

Answer: D 

Reference: 

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

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtstransactionoption.aspx 


Q149. You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into a data warehouse hosted on SQL Azure. 

You have the following requirements: 

. A destination table must contain all of the data in two source tables. 

. Duplicate records must be inserted into the destination table. 

You need to develop a data flow that imports the data while meeting the requirements. 

How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.) 


Answer: 



Q150. You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive property. 

You need to create a project parameter and configure it so that its value is encrypted when it is deployed to the SSIS catalog. 

Which three steps 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.) 


Answer: 



Q151. You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job. 

You make changes to the package that should improve performance. 

You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal. 

What should you do? 

A. Enable logging to an XML file in the package control flow for the Onlnformation event. After 10 executions, view the XML file. 

B. After 10 executions, view the job history for the SQL Server Agent job. 

C. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the package. 

D. Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10 executions, view the XML file. 

Answer: C 


Q152. A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2012 packages. The environment that you are deploying the packages to has the following constraints: 

The operating system is Windows Server 2008 R2. The SSIS packages are stored in the SSIS catalog. Some of these SSIS packages use 32-bit custom components. 

You need to install only the components that are required to deploy and run the packages on the new server. 

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.) 


Answer: 



2passeasy.com

Latest 70-463 course outline:

Q153. You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS). The package includes custom scripts that must be upgraded. 

You need to upgrade the package to SQL Server 2012. 

Which tool should you use? 

A. SQL Server dtexec utility (dtexec.exe) 

B. SQL Server DTExecUI utility (dtexecui.exe) 

C. SSIS Upgrade Wizard in SQL Server Data Tools 

D. SQL Server Integration Services Deployment Wizard 

Answer: C 

Explanation: Use the SSIS Package Upgrade Wizard to upgrade SQL Server 2005 Integration Services (SSIS) packages and SQL Server 2008 Integration Services (SSIS) packages to the package format for the current (2012) release of SQL Server Integration Services. 


Q154. You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. 

Referential integrity must be enforced declaratively. 

You need to design a solution that can join a single time dimension to both fact tables. 

What should you do? 

A. Create a view on the sales table. 

B. Partition the fact tables by day. 

C. Create a surrogate key for the time dimension. 

D. Change the level of granularity in both fact tables to be the same. 

Answer: D 

Explanation: In order to join the facts table in time dimension we cannot have two different time measures (time and day). 


Q155. You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. 

In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain. 

You need to complete the mapping of the Group column. 

What should you do? 

A. Map a composite domain to the source column. 

B. Create a composite domain that includes the Group column. 

C. Add a domain for the Group column. 

D. Add a column mapping for the Group column. 

Answer: C 


Q156. 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: 



Q157. You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project. 

The first package that you create in this project contains a package connection that accesses a flat file. Additional packages in the project must also access this file. 

You need to define and reuse the flat file connection in all project packages. 

What should you do? 

A. Convert the package Connection Manager in the first package to a project Connection Manager. 

B. Copy the package Connection Manager and paste it into the second package. 

C. Convert the project to the Package Deployment model. 

D. Set the ProtectionLevel property of the package Connection Manager to DontSaveSensitive to reuse the flat file connection. 

Answer: A 


Q158. You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS). 

The package includes custom scripts that must be upgraded. 

You need to upgrade the package to SQL Server 2012. 

Which tool should you use? 

A. SSIS Upgrade Wizard in SQL Server 2008 BIDS 

B. SSIS Upgrade Wizard in SQL Server Data Tools 

C. SQL Server DTExecUI utility (dtexecui.exe) 

D. SQL Server dtexec utility (dtexec.exe) 

Answer: B 


Q159. You are building a fact table in a data warehouse. 

The table must have a columnstore index. The table cannot be partitioned. 

You need to design the fact table and load it with data. 

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.) 


Answer: 



Q160. You are developing a SQL Server Integration Services (SSIS) package. The data source 

for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to obtain the CDC data. 

The CDC Source component has the following requirements: 

. The output must include metadata columns that indicate which source columns have changed. . The output must return only one change row per source row that is modified in the current CDC processing range. 

You need to configure the CDC Source component. 

Which CDC processing mode should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.) 


Answer: 




see more http://www.2passeasy.com/exam/70-463/