[Tested] 70-463 Microsoft answers 145-160 (Mar 2016)

Verified of 70-463 exam guide materials and preparation exams for Microsoft certification for client, Real Success Guaranteed with Updated 70-463 pdf dumps vce Materials. 100% PASS Today!

2016 Mar 70-463 Study Guide Questions:

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


Q146. You are preparing to install SQL Server 2012 Master Data Services (MDS). 

You need to ensure that the database requirements are met. 

What should you install? 

A. Microsoft SharePoint Server 2010 Standard Edition SP1 

B. Microsoft SharePoint Server 2010 Enterprise Edition SP1 

C. SQL Server 2012 Data Center (64-bit) x64 on the database server 

D. SQL Server 2012 Enterprise (64-bit) x64 on the database server 

Answer: D 

Explanation: 

* Master Data Services is a new feature introduced in SQL Server 2008 R2 and further enhanced in SQL Server 2012. 

* SQL Server 2012 Enterprise features include Master Data Services: 


Note: 

* Microsoft SQL Server Master Data Services is a Master Data Management (MDM) product from Microsoft, which will ship as a part of the Microsoft SQL Server database.Originally code-named Bulldog, Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007. Master Data Services is architecturally similar to +EDM, with increased integration with other Microsoft applications as well as some new features. Master Data Services first shipped with Microsoft SQL Server 2008 R2. 


Q147. You are the Master Data Services (MDS) administrator at your company. 

An existing user must be denied access to a certain hierarchy node for an existing model. 

You need to configure the user's permissions. 

Which user management menu item should you select? (To answer, configure the 

appropriate option or options in the dialog box in the answer area.) 


Answer: 



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



Q149. You are developing a SQL Server Integration Services (SSIS) package. 

OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by 

using SQL Server Management Studio. 

You need to execute the package and minimize the number of event types that are logged. 

Which setting should you use? (To answer, change the appropriate setting in the answer 

area.) 


Answer: 



70-463 exam guide

Renew 70-463 free exam questions:

Q150. You are creating a SQL Server Master Data Services (MDS) model for a company. 

The source data for the company is stored in a single table that contains the manager-to-subordinate relationships. 

You need to create a hierarchy representing the organizational structure of the company. 

Which hierarchy type should you use? 

A. Organizational 

B. Recursive 

C. Non-Mandatory Explicit 

D. Many-to-Many 

Answer: B 


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


Q152. You are designing a complex SQL Server Integration Services (SSIS) project that uses the Project Deployment model. 

The project will contain between 15 and 20 packages. All the packages must connect to the same data source and destination. 

You need to define and reuse the connection managers in all the packages by using the least development effort. 

What should you do? 

A. Copy and paste the connection manager details into each package. 

B. Implement project connection managers. 

C. Implement package connection managers. 

D. Implement parent package variables in all packages. 

Answer: B 


Q153. 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 junk dimension for the geography dimension. 

B. Implement change data capture. 

C. Create a conformed dimension for the geography dimension. 

D. Create three geography dimensions. 

Answer: C 


Q154. You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse. 

You are importing data from a relational table named Projects. The table has change data capture enabled on all columns. 

You need to process only the most recent values from rows that have been inserted or updated since the previous execution of the package. 

Which query should you use as the data source? 


A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: D 

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

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

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


70-463 exam price

Top Quality 70-463 free practice exam:

Q155. You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS). 

You must develop an SSIS project and deploy it to the server by using the Project Deployment model. 

Operations Log records that are outside the configured retention period must be cleaned automatically. 

You need to create the SSIS catalog on the production server. 

What should you do? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Enable XP Command Shell. 

B. Enable CLR Integration. 

C. Enable OLE Automation. 

D. Start the SQL Server Browser service. 

E. Enable Cross Database Ownership Chaining 

F. Start the SQL Server Agent service 

G. Enable Ad Hoc Remote Queries. 

Answer: B,F 


Q156. To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. 

The methodology has the following requirements: 

Centralized logging in SQL Server 

Simple deployment 

Availability of log information through reports or T-SQL 

Automatic purge of older log entries 

Configurable log details 

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. 

What should you do? 

A. Deploy the package by using an msi file. 

B. Use the gacutil command. 

C. Create an OnError event handler. 

D. Create a reusable custom logging component. 

E. Use the dtutil /copy command. 

F. Use the Project Deployment Wizard. 

G. Run the package by using the dtexec /rep /conn command. 

H. Add a data tap on the output of a component in the package data flow. 

I. Run the package by using the dtexec /dumperror /conn command. 

J. Run the package by using the dtexecui.exe utility and the SQL Log provider. 

K. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration. 

Answer: I 

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

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


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

The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model. 

Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder path to the package. 

You need to configure the package to accept the folder path from each job. 

Which package configuration should you use? 

A. .dtsConfig file 

B. Registry Entry 

C. Environment Variable 

D. Parent Package Variable 

E. XML Configuration File 

Answer: C 

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

http://msdn.microsoft.com/en-us/library/ms141708.aspx http://msdn.microsoft.com/en-us/library/hh213214.aspx http://msdn.microsoft.com/en-us/library/hh213296.aspx http://msdn.microsoft.com/en-us/library/hh213293.aspx 


Q158. You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing. 

Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories: 

Valid addresses 

Autocorrected addresses 

Invalid addresses 

You need to enhance the SSIS packages to perform address validation by using an external service. 

Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.) 


Answer: 



Q159. 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 Integration Services Deployment Wizard 

B. SQL Server Configuration Manager 

C. SSIS Upgrade Wizard in SQL Server Management Studio 

D. SSIS Upgrade Wizard in SQL Server 2008 BIDS 

Answer: C 

Explanation: You can upgrade packages that were created in earlier versions of Integration Services to the Integration Services format that SQL Server 2012 uses. SQL Server provides the SSIS Package Upgrade Wizard to help in this process. Because you can configure the wizard to backup up your original packages, you can continue to use the original packages if you experience upgrade difficulties. 

You can run the SSIS Package Upgrade Wizard from SQL Server Data Tools (SSDT), from SQL Server Management Studio, or at the command prompt. 

Note: 

* When you upgrade an instance of SQL Server 2005 or SQL Server 2008 to the current release of SQL Server, your existing SQL Server 2008 Integration Services (SSIS) packages are not automatically upgraded to the package format that the current release SQL Server Integration Services uses. You will have to select an upgrade method and manually upgrade your packages. 


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