70-463 Premium VCE File
70-463.vce - ExamCollection Verified - Instant Download
193 Questions & Answers
Get Unlimited Access to ALL Premium Files$69.99

Download Microsoft.Compilation.70-463.v2013-01-18.by.7thfreak.111q.vce

Exam: 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
Size: 2.49 MB
# of downloads: 331
Free Download: This file is outdated. Browse other 70-463 VCE Files

Rating:

0 liked this dump 0 disliked
Click here to Like Dislike

VCE Simulator for Microsoft 70-463 VCE files
Comments

* The most recent comments are at the top.

Note:

A+ player doesn't open 70-463 VCE files correctly. A+ Player tends to provide users with irrelevant files from its own repository when it's unable to open the user's 70-463 VCE file. Therefore, the file you view in A+ Player might not be the file you think you have opened. Use VCE Exam Simulator to play VCE files properly.


Certificat0r

  • Spain
  • Apr 01, 2013
  • Report Comment

Passed with 877/1000.


akapolko

  • Canada
  • Mar 19, 2013
  • Report Comment

Passed with 934
thanks a lot


roger daniel

  • India
  • Mar 09, 2013
  • Report Comment

Can someone please post the PDF version?


spidey's wife

  • United States
  • Feb 26, 2013
  • Report Comment

Thank you PeterPan. You are amazing! I am taking my exam this Sunday and hope the dump will solidify what I have studied. Mostly, I took the exam topics from www.microsoft.com/learning and have been looking each one up in the help menu on technet or msdn. They are very helpful, but now need to test my knowledge. Thank you!


Peterpan

  • United Kingdom
  • Feb 26, 2013
  • Report Comment

I've uploaded the latest dump and these were valid on the 20-02-2013.

The dump I uploaded is the original with a few minor changes + a load of new questions (well 20 odd). Exam was 50 questions all in dump


Spidey's Wife

  • United States
  • Feb 25, 2013
  • Report Comment

7th Freak and Peter Pan, thank you so much for the dump(s). I am a bit confused becuase it looks to me like you both took and cleared this exam, but all the questions you are talking about above, are they new questions or questions that have been revamped? Could you clarify if these are still valid dumps? Thank you!


Peterpan

  • United Kingdom
  • Feb 25, 2013
  • Report Comment

Its posted.. I got one of those questions which nilex was on about on exam.. still no idea what the answer was.

I'm hoping once I read that book and had a play, it will make more sense


nilex

  • Germany
  • Feb 24, 2013
  • Report Comment

Hello,

I'm have problem with to questions in exam A. The questions sound similar, but the answer is different.

Question 39:
You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. What should you do?

Answer:
Add an OnError event handler to the SSIS project.

Question 45:
Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. What should you do?

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

Both answers sound correct for me, but what is the correct answer for Microsoft?
Thank you for help!


peterpan

  • United Kingdom
  • Feb 24, 2013
  • Report Comment

Hi, MCITP

I bought the books, so going to have a work through them.

I went the other way and used the dump to pass.. have exam and then do course approach. Because exams passed, i'll settle down and be able to work through all the labs in 461-463 and learn something.

I've bought some servers and off to learn servers stuff for 2012 and once I've installed and configured network, i'll go back to learning sql.

It was always going to be an issue as we dont have sql2012 at work.

Anyways hit high 9xx on test using new dump (I've posted it).. but as you already were able to answer my questions below, you should pass without it as they were the hardest questions. The only thing that you really need extra is the required, supported, not supported and when to use them.


mcitp

  • Ukraine
  • Feb 23, 2013
  • Report Comment

to PeterPan
;) me to. I think you've decided to make right choice,
I recommend. you to take in your hand two very useful book
1. http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-448/dp/0735626367
2. http://www.amazon.com/Training-Kit-Exam-70-463-Implementing/dp/0735666091

Of course second book is much suitable, but 70-448 for having a bit widely vision i suggest 70-448 as well.

Do your best.
Good luck!


PeterPan

  • United Kingdom
  • Feb 22, 2013
  • Report Comment

Much appreciated.. I was going to use dumps to pass.. but I've realised how little I know, so I think I'll abandon it for a bit..wait for cbt nuggets and set up a server and have a play as all that will happen is i'll look silly if I have to do any ssis work.. and then people will wonder what else im useless at


mcitp

  • Ukraine
  • Feb 21, 2013
  • Report Comment

You are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS) package each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day.

The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table. You need to reduce the report processing time and minimize the growth of the database. What should you do?

Answer is
Change the granularity of the fact table to month.


mcitp

  • Ukraine
  • Feb 21, 2013
  • Report Comment

No problem.

I'm going to pass 70-463 in next few days without dumps. I think it's possible for me. Therefore I'll share my vision about answer. Some of them maybe incorrect, but as i see majority of questions are quite simple.

You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical changes to student attributes such as ParentOccupation. You need to redesign the dimension to enable the full historical reporting of changes to multiple student attributes including ParentOccupation. What should you do?

Answer is (modify to SCD2 )
> Add StartDate and EndDate columns to the student dimension


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. What should you do?

Create a reusable custom logging component.

Use the gacutil command.

Use the Integration Services Deployment Wizard.

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

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

Create an OnError event handler.

Use the dtutil /copy command.

Deploy the package by using an msi file.

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

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

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


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

bah..I had to change ip to post more

1) You are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS) package each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day.

This is hard to explain..but the question has a factsales, dimcalender, dimproduct and dimtime tables

The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table. You need to reduce the report processing time and minimize the growth of the database. What should you do?

Create an indexed view over the fact table to sum orderTotal by month.

Create a view over the fact table to sum orderTotal by month.

Change the granularity of the fact table to month.

Partition the fact table by productKey.




2) You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical changes to student attributes such as ParentOccupation. You need to redesign the dimension to enable the full historical reporting of changes to multiple student attributes including ParentOccupation. What should you do?

Add CurrentValue and PreviousValue columns to the student dimension.

Enable Snapshot Isolation on the data warehouse.

Add an IsCurrent column to the student dimension.

Add StartDate and EndDate columns to the student dimension


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

Much appreciated, I shall send some more :-)


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?

Create a time mapping table.

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

Merge the fact tables.

Create a view on the sales table.


mcitp

  • Ukraine
  • Feb 20, 2013
  • Report Comment

DRAG DROP
You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.
The package performs the following steps:
1. Download a sales transaction file by using FTP.
2. Truncate a staging table.
3. Load the contents of the file to the staging table.
4. Merge the data with another data source for loading to a data warehouse.


1. Open the SSIS Toolbox
2. Move the Truncate Staging Table and Load Sales to Staging tasks to add a new Sequence container and set their FailParentOnFailure properties to True
3 Set the FailPackageOnFailure property of the container to True


mcitp

  • Ukraine
  • Feb 20, 2013
  • Report Comment

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model. The project contains many packages. It is deployed on a server named SQLTest1. The project will be deployed to several servers that run SQL Server 2012. The project accepts one required parameter. The data type of the parameter is a string. A SQL Agent job is created that will call the Loading.dtsx package in the project. A job step is created for the SSIS package. The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter. You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the package. Which four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

1 In the SSIS catalog, create an Environment named EnvTest
2 In the EnvTest Environment, create an Environment Variable. Name the Environment variable EnvServer. Set the Environment Variable value to SQLTest1
3 In the project configuration, create an Environment reference to EnvTest. Assign the value of the EnvServer Environment Variable to the project parameter.
4 In the SQL Agent Job, choose the EnvTest Environment in the Configuration tab of the SQL Integration Services job step


mcitp

  • Ukraine
  • Feb 20, 2013
  • Report Comment

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a production server. The package contains sensitive information secured by using the EncryptSensitiveWithUserKey package protection level. You are preparing the package for deployment by the production operations team. You need to ensure that the production operations team can open and execute the package without re-entering the sensitive information. 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.)

1 Open the package in SQL Server Data Tools
2 Click the design surface of the Control Flow designer
3 In the Properties window, change the ProtectionLevel property to EncryptSensitiveWithPassword and enter the PackagePassword


mcitp

  • Ukraine
  • Feb 20, 2013
  • Report Comment

A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog. To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of the various task components that must be analyzed. You need to create these output files with the least amount of administrative and development effort. Which three stored procedures should you execute in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

1 Catalog.create_Execution
2 Catalog.add_data_tap
3 Catalog.Start_execution


mcitp

  • Ukraine
  • Feb 20, 2013
  • Report Comment

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?

Create a time mapping table.


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

And the last 1 ?

DRAG DROP
You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.
The package performs the following steps:
1. Download a sales transaction file by using FTP.
2. Truncate a staging table.
3. Load the contents of the file to the staging table.
4. Merge the data with another data source for loading to a data warehouse.

Flow
FTP Sales Data
Truncate Staging Table
Load Sales to Staging
Merge Sales

The checkpoints are currently working such that if any of the four steps fail, the package will restart from the failed step the next time it executes. You need to modify the package to ensure that if either the Truncate Staging Table or the Load Sales to Staging task fails, the package will always restart from the Truncate Staging Table task the next time the package runs. 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.)

Set the DelayValidation property of the container to true.

Set the ForceExecutionResult property of the Truncate Staging Table task to Success

Create a task to delete the checkpoint file if the Truncate Staging Table task Fails

Set the FailPackageOnFailure property of the container to True

Move the Truncate Staging Table and Load Sales to Staging tasks to add a new Sequence container and set their FailParentOnFailure properties to True

Set the ForceExecutionResult property of the Truncate Staging Table task to Completion

Open the Data Flow Page

Open the SSIS Toolbox


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

?

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model. The project contains many packages. It is deployed on a server named SQLTest1. The project will be deployed to several servers that run SQL Server 2012. The project accepts one required parameter. The data type of the parameter is a string. A SQL Agent job is created that will call the Loading.dtsx package in the project. A job step is created for the SSIS package. The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter. You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the package. Which four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

In the SSIS catalog, create an Environment named EnvTest

In the EnvTest Environment, create an Environment Variable. Name the Environment variable EnvServer. Set the Environment Variable value to SQLTest1

In the SQL Agent Job, choose the EnvTest Environment in the Configuration tab of the SQL Integration Services job step

In the SSIS catalog, create a folder name EnvTest

In the project configuration, create an Environment reference to EnvTest. Assign the value of the EnvServer Environment Variable to the project parameter.

In the project configuration, change the value of the project parameter to EnvTest


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

?

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?

Create a time mapping table.
Change the level of granularity in both fact tables to be the same
Merge the fact tables.
Create a view on the sales table.


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

And this 1

A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog. To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of the various task components that must be analyzed. You need to create these output files with the least amount of administrative and development effort. Which three stored procedures should you execute in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Catalog.create_folder
catalog.Create_Execution_dump
Catalog.add_data_tap
Catalog.configure_catalog
Catalog.add_data_tap_by_guid
Catalog.create_Execution
Catalog.Start_execution


PeterPan

  • United Kingdom
  • Feb 20, 2013
  • Report Comment

Anyone got any idea what the answer to this 1 is

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a production server. The package contains sensitive information secured by using the EncryptSensitiveWithUserKey package protection level. You are preparing the package for deployment by the production operations team. You need to ensure that the production operations team can open and execute the package without re-entering the sensitive information. 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.)

Open the package in SQL Server Data Tools

In the Properties window, change the ProtectionLevel property to EncryptSensitiveWithPassword and enter the PackagePassword

Use the [Encrypt] option with the required protection level and password

Run the dtexecUI command prompt utility

Click the task which contains the sensitive information

Click the design surface of the Control Flow designer

Run the dtexec command prompt utility

When prompted, reset the package protection level for production


Wahyu pret

  • Indonesia
  • Feb 14, 2013
  • Report Comment

Not valid, failed


J

  • Thailand
  • Feb 08, 2013
  • Report Comment

Passed with 908/1000

20 questions new from this collection

Thanks ! Anyway.


JamesBond

  • India
  • Jan 26, 2013
  • Report Comment

Awesome. Cleared with 891. Thanks.


7thfreak

  • India
  • Jan 21, 2013
  • Report Comment

Scored 921/1000.
55 Questions in exam. 43-45 from this collection.

Report Comment

Verify:

Add Comment

Name: *
E-mail: *

This e-mail will not be published.

Comment: *

Comment will be moderated and published within 1-4 hours.

Rate file: * Like!     Dislike
Verification: * Secure Code
Type the characters from the picture.  
VCE Exam Simulator Free DemoVCE Exam Simulator Free Demo
Read about VCE Exam Simulator
Download VCE Exam Simulator

Premium VCE File

70-463.vce

  • 193 questions & answers
  • Instant Download
  • $69.99

Get Unlimited Access to the all ExamCollection PREMIUM VCE files!
Prep4sure - Professional IT Certification Training
BrainDumps - Get Real Exam Questions
Actual Tests - Lifetime Access to IT Exams

Related Blog Posts

Site Search:

Close
Only Registered Members Can Download VCE Files

Please fill out your email address below in order to Download VCE files or view Online Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted By 1.2M IT Certification Candidates Every Month
  • VCE Files Simulate Real exam environment
  • Instant download After Registration.
Please provide a correct E-mail address
Email Address:

A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Close
Log into your ExamCollection Account

Please Log In to download VCE file or view Online Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

E-mail:
*  
Password:
* Forgot password?
 

Only registered Examcollection.com members can download vce files or view online courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Close
DO YOU HAVE A VCE PLAYER?
Play VCE files with Avanset VCE Simulator

Your file is being downloaded.

All tests on this site have been created with VCE Exam Simulator.

VCE Exam Simulator is interactive testing engine developed for certification exam preparation.

Files with VCE extension can be opened with this program.

Before you can open any file on this site you will need to download VCE Exam Simulator

Download VCE Player
I already have it
Close
Like this VCE file?

Log in to make your opinion count.

E-mail:
*  
Password:
* Forgot password?
 

Only registered Examcollection.com members can rate files.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Close

Close
Download Free Demo of VCE
Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.


Simply submit your e-mail address below to get started with our interactive software demo of your free trial.


Enter Your Email Address

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.