Tips to Pass 70-463 Exam (129 to 144)


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Microsoft 70-463 Real Exam (Full Version!)

★ 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: http://www.certleader.com/70-463-dumps.html


70-463 Product Description:
Exam Number/Code: 70-463 vce
Exam name: Implementing a Data Warehouse with Microsoft SQL Server 2012
n questions with full explanations
Certification: Microsoft Certification
Last updated on Global synchronizing

Instant Access to Free VCE Files: Microsoft 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

70-463 examcollection

Validated of 70-463 practice exam materials and preparation exams for Microsoft certification for IT examinee, Real Success Guaranteed with Updated 70-463 pdf dumps vce Materials. 100% PASS Implementing a Data Warehouse with Microsoft SQL Server 2012 exam Today!

2016 May 70-463 Study Guide Questions:

Q129. A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database. 

To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a comma-

separated values (CSV) file that contains one row per currency. 

You need to download the CSV file to the environment. 

What should you use to retrieve the document from the website? 

A. a Script component 

B. a Web Service task 

C. a Web Service source 

D. a Script task 

Answer: D 


Q130. 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 Configuration Manager 

B. SQL Server Agent 

C. SSIS Upgrade Wizard in SQL Server Management Studio 

D. SQL Server DTExecUI utility (dtexecui.exe) 

Answer: C 

Explanation: 

Use the SSIS Package Upgrade Wizard to migrate packages that were developed in SQL Server 2005 Integration Services (SSIS) and SQL Server 2008 Integration Services (SSIS) to the package format that the current release of Integration Services uses. 

Reference: SSIS Upgrade Wizard (SSIS Package Upgrade Wizard) 


Q131. A Data Flow task in a SQL Server Integration Services (SSIS) package produces run-time errors. 

You need to edit the package to log specific error messages. 

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: 



Q132. You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. The package includes a data flow and is executed on ServerB. The destination table has its own identity column. 

The destination data load has the following requirements: . The identity values from the source table must be used. . Default constraints on the destination table must be ignored. . Batch size must be 100,000 rows. 

You need to add a destination and configure it to meet the requirements. 

Which destination should you use? 

A. OLE DB Destination with Fast Load 

B. SQL Server Destination 

C. ADO NET Destination without Bulk Insert 

D. ADO NET Destination with Bulk Insert 

E. OLE DB Destination without Fast Load 

Answer: A 

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

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

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


Q133. You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. 

The SSIS package has the following requirements: 

Every night, a very large amount of data is imported into the staging database. 

Package processing time must be minimized. 

The package must run on its own dedicated server when it is deployed to 

production. 

Transaction log activity when data is imported must be minimized. 

You need to design the package to meet the requirements. 

Which destination component should you use? 

A. DataReader 

B. OLE DB 

C. ADO.NET 

D. SQL Server 

Answer: B 


70-463  practice exam

Improved 70-463 free question:

Q134. 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. After 10 executions, view the job history for the SQL Server Agent job. 

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

C. Enable logging to the Application Event Log in the package control flow for the Onlnformation event. After 10 executions, view the Application Event Log. 

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

Answer: B 

Explanation: The All Executions Report displays a summary of all Integration Services executions that have been performed on the server. There can be multiple executions of the sample package. Unlike the Integration Services Dashboard report, you can configure the All Executions report to show executions that have started during a range of dates. The dates can span multiple days, months, or years. 

The report displays the following sections of information. 

* Filter 

Shows the current filter applied to the report, such as the Start time range. 

* Execution Information 

Shows the start time, end time, and duration for each package execution.You can view a 

list of the parameter values that were used with a package execution, such as values that 

were passed to a child package using the Execute Package task. 


Q135. You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment 

Model. This project is deployed to SQL Server on a test server. 

You need to ensure that the project is deployed to the SSIS catalog on the production server. 

What should you do? 

A. Open a command prompt and run the dtexec /dumperror /conn command. 

B. Create a reusable custom logging component and use it in the SSIS project. 

C. Open a command prompt and run the gacutil command. 

D. Add an OnError event handler to the SSIS project. 

E. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility. 

F. Open a command prompt and run the dtexec /rep /conn command. 

G. Open a command prompt and run the dtutil /copy command. 

H. Use an msi file to deploy the package on the server. 

I. Configure the SSIS solution to use the Project Deployment Model. 

J. Configure the output of a component in the package data flow to use a data tap. 

K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server. 

Answer: I 

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

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


Q136. You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. 

You are developing the part of the SSIS package that populates the ProjectDates dimension table. The business key of the ProjectDates table is the ProjectName column. 

The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table: 

ExpectedStartDate - New values should be tracked over time. 

ActualStartDate - New values should not be accepted. 

ExpectedEndDate - New values should replace existing values. 

ActualEndDate - New values should be tracked over time. 

You use the SSIS Slowly Changing Dimension Transformation. 

You must configure the Change Type value for each source column. 

Which Change Type values should you select? (To answer, drag the appropriate value from the list of values to the correct location or locations in the answer area.) 


Answer: 



Q137. 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 Team Type, does not yet have a domain. 

You need to complete the mapping of the Team Type column. 

What should you do? 

A. Add a column mapping for the Team Type column. 

B. Map a composite domain to the source column. 

C. Create a composite domain that includes the Team Type column. 

D. Add a domain for the Team Type column. 

Answer: D 

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

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


Q138. 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 data source will be polled once per hour. The data is updated with multiple important status changes per minute. 

For each captured data change, the before and after values must be included. 

You need to configure the CDC Source component. 

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


Answer: 



70-463  practice exam

High quality 70-463 free demo:

Q139. You are deploying a new SQL Server Integration Services (SSIS) package to five servers. 

The package must meet the following requirements: 

. .NET Common Language Runtime (CLR) integration in SQL Server must not be enabled. . The Connection Managers used in the package must be configurable without 

editing and redeploying the package. 

. The deployment procedure must be automated as much as possible. 

. Performance must be maximized. 

You need to set up a deployment strategy that meets the requirements. 

What should you do? 

A. Add an OnError event handler to the SSIS project. 

B. Use an msi file to deploy the package on the server. 

C. Open a command prompt and run the gacutil command. 

D. Open a command prompt and run the dtutil /copy command. 

E. Open a command prompt and run the dtexec /rep /conn command. 

F. Open a command prompt and run the dtexec /dumperror /conn command. 

G. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility. 

H. Create a reusable custom logging component and use it in the SSIS project. 

I. Configure the SSIS solution to use the Project Deployment Model. 

J. Configure the output of a component in the package data flow to use a data tap. 

K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server. 

Answer: D 


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


Q141. You administer a Microsoft SQL Server database. You want to import data from a text file to the database. 

You need to ensure that the following requirements are met: 

. Data import is performed by using a stored procedure. 

. Data is loaded as a unit and is minimally logged. 

Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Each data import command or recovery model may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.) 


Answer: 



Q142. You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database. 

When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four 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: 



Q143. You are developing a SQL Server Integration Services (SSIS) package that loads data into a data warehouse hosted on Windows Azure SQL Database. 

You must combine two data sources together by using the ProductID column to provide complete details for each record. The data retrieved from each data source is sorted in ascending order by the ProductID column. 

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: 



Q144. You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named Quotes. The table has no indexes and consists of seven columns: 

 [ID] 

[QuoteDate] 

[Open] 

[Close] 

[High] 

[Low] 

[Volume] 

Each of the following queries must be able to use a columnstore index: 

SELECT AVG ([Close]) AS [AverageClose] FROM Quotes WHERE [QuoteDate] 

BETWEEN '20100101' AND '20101231'. 

SELECT AVG([High] - [Low]) AS [AverageRange] FROM Quotes WHERE 

[QuoteDate] BETWEEN '20100101' AND '20101231'. 

SELECT SUM([Volume]) AS [SumVolume] FROM Quotes WHERE [QuoteDate] 

BETWEEN '20100101' AND '20101231'. 

You need to ensure that the indexing strategy meets the requirements. The strategy must also minimize the number and size of the indexes. 

What should you do? 

A. Create one columnstore index that contains [ID], [Close], [High], [Low], [Volume], and [QuoteDate]. 

B. Create three coiumnstore indexes: 

One containing [QuoteDate] and [Close] 

One containing [QuoteDate], [High], and [Low] 

One containing [QuoteDate] and [Volume] 

C. Create one columnstore index that contains [QuoteDate], [Close], [High], [Low], and 

[Volume]. 

D. Create two columnstore indexes: 

One containing [ID], [QuoteDate], [Volume], and [Close] 

One containing [ID], [QuoteDate], [High], and [Low] 

Answer: C 

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

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



see more Implementing a Data Warehouse with Microsoft SQL Server 2012