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

Download Microsoft.Passguide.70-462.v2013-08-12.by.Raman.90q.vce

Exam: 70-462 - MCSA Administering Microsoft SQL Server 2012/2014 Databases
Size: 1.33 MB
# of downloads: 3215
Free Download:

Rating:

0 liked this dump 0 disliked
Click here to Like Dislike

Latest Braindumps for IT Exams
Comments

* The most recent comments are at the top.

Pages:  [<<]  [<]  1 2 3  [>]  [>>]

Note:

Use VCE Exam Simulator only to play VCE files properly.


Ax

  • Italy
  • Dec 17, 2013
  • Report Comment

VALIIIIIDDDDD!!!!
Passed today with 883 (and MCSA earned!)
50 questions.
all in this dump.
Just pay attention to the answer's order... it was shuffled!!

Best greetings to all from Italy!
Ax


Svetlio

  • Bulgaria
  • Dec 17, 2013
  • Report Comment

Still valid. No new questions.


suzie

  • United States
  • Dec 17, 2013
  • Report Comment

John, I agree with your changes. Q48 ... transactional replication is the only option that would allow adding indexes to the db. You can't make changes to AG, mirroring or log shipping secondaries.


Kumar

  • Canada
  • Dec 16, 2013
  • Report Comment

Is this valid in North America? Thanks.


Rafael (Brazil)

  • Brazil
  • Dec 16, 2013
  • Report Comment

A agree with John in question 60 (Exam A). "doesn't have any column that refers to anything to do with blocking" and don't exist sessionid in table sys.dm_exec_sessions. The column that exists is the session_id.


John

  • Switzerland
  • Dec 16, 2013
  • Report Comment

Svetla - I think Q37 is wrong and should be COPY ONLY but Q38 should be Bulk because it says to import data in the minimum amount of time.

As for my concerns:
Q60 Exam A should be A (EXEC sp_who 60) because that SP has a blocking column while the sys.dm_exec_sessions DMV doesn't have any column that refers to anything to do with blocking.
Q48 - Can anybody explain this?
Exam 2 Q2: Does anybody have an answer to this? My guess would be: Merge, Snapshot, Merge, Transactional. Can anybody confirm? They are pretty vaguely worded so I'm not surely.
Exam 2 Q16: I agree with all the answers except for "Generating Alerts" SQL Profiler can't Generate Alerts. So I would say System Monitor should be in this box instead.

Can anybody please confirm ASAP?


Peter

  • Singapore
  • Dec 16, 2013
  • Report Comment

Still valid...Around 10 new questions. Passed with 8xx


Ron

  • Singapore
  • Dec 14, 2013
  • Report Comment

This dump are still Valid in Singapore, 10++ new questions and passed with 760++


Jitesh

  • India
  • Dec 13, 2013
  • Report Comment

Few new Que but dump is still Valid. Passed Today 833...

Thx


Josh

  • Israel
  • Dec 12, 2013
  • Report Comment

In Exam A Q27 - I think it should be B. There is no specific reference to deadlocks (TRACEON 1222), just to taking a long time... I agree that the Profiler doesn't fit, as the question is for 'an extended period'. Any thoughts?


Andrei

  • Russian Federation
  • Dec 12, 2013
  • Report Comment

Yes, the dump is still generally valid, but there are some new questions represented in the exam. Besides, some questions in the dump look wrong (for example, the Hotspot question). Usually I score about 970-980 points across the whole dump (90q), but today at the exam only 883... Good luck guys.


Ric

  • South Africa
  • Dec 11, 2013
  • Report Comment

Dump is still Valid in South Africa, 1 new question - passed 850


pino

  • Netherlands
  • Dec 10, 2013
  • Report Comment

For those who can not open the .vce file. The PDF file of Sajid Wasim is definitely valid. Pass with 866. I think there was 5 or 6 esy new question. So....Thanks brother Sajid.


Svetla

  • Germany
  • Dec 10, 2013
  • Report Comment

Also I think Q37 is wrong. The answer should be COPY_ONLY - L, as opposed to Transaction Log. Can anybody confirm that Q37 and 38 are wrong? Please feel free to challenge me :-).


Jemi

  • Egypt
  • Dec 08, 2013
  • Report Comment

Still Valid , got 9xx score , 4 new questions .


Turek

  • United States
  • Dec 07, 2013
  • Report Comment

None of the "Build List and Reorder" items will show up on VCE mobile for iPad or iPhone. I'm not sure about any other devices. So if you exclusively use VCE Mobile like me, make sure you study those on a PC or other platform where VCE will display them, there are 17 of them, all in exam B.


Dennis

  • United States
  • Dec 06, 2013
  • Report Comment

Passed Today - Test was back down to 50 questions, No Azure questions. Make sure you know the Answers because they were moved around a bit, but most of the questions were from this practice test.


Svetla

  • Netherlands
  • Dec 06, 2013
  • Report Comment

How come the answer for Q38 is L (Bulk Logged). Shouldn't it be FULL since you're guaranteed that no data is lost?


umi

  • Turkey
  • Dec 04, 2013
  • Report Comment

It is still valid. I saw a few new question. I got 8xx on 4th dec.


Alex

  • New Zealand
  • Dec 03, 2013
  • Report Comment

Dump is valid in NZ. I got 8XX on 3nd Dec,There are 50 questions,No questions from Azure.


Rafael Assis

  • Brazil
  • Dec 03, 2013
  • Report Comment

I think that question 17 in the exam B is wrong.

I maked the lab in home and only possible unable the created by sp_% procedure with option down:

Policy condition: '@Name NOT LIKE 'sp[_]%''


kamlesh

  • United States
  • Dec 03, 2013
  • Report Comment

Dump is valid in india. I got 9XX on 2nd Dec


Niana

  • United States
  • Dec 02, 2013
  • Report Comment

Still valid in US. Few tips..
1. Just choose level of knowledge as moderate in survey. I'm not sure if that's y I got all questions from this dumps.
2. No questions from Azure.
3. Focus on security - HA question, Deny & Revoke - Repl, AG..
4. Practice more on Exam B - Drag and drop
Good Luck !!


Niana

  • United States
  • Dec 02, 2013
  • Report Comment

Still valid in US. Few tips..
1. Just choose level of knowledge as moderate in survey. I'm not sure if that's y I got all questions from this dumps.
2. No questions from Azure.
3. Focus on security - HA question, Deny & Revoke - Repl, AG..
4. Practice more on Exam B - Drag and drop
Good Luck !!


Merican

  • United States
  • Dec 02, 2013
  • Report Comment

Dump Still valid, but expect 8 to 10 questions not on dump. got an 8xx, My test still had 70 questions, in USA on 11/30


Sajid Wasim

  • Bangladesh
  • Nov 30, 2013
  • Report Comment

Guys, I got some good dump. You can check this. Download from here:
https://dl.dropboxusercontent.com/u/14425563/70-462%20Exam%20Questions%20%26%20Answers.docx


Scotty from Czech republic

  • Czech Republic
  • Nov 30, 2013
  • Report Comment

Hi everybody, It looks like that Microsoft changed strategy. 50 q instead of 70q. No questions about Azure I think based on students complain in survey on the end of exam. 5 changed q and 5 new q. I passed exam 883 score Yesterday. Dump is still valid.


Hazem

  • Kuwait
  • Nov 28, 2013
  • Report Comment

dumb valid, passed today with score 800, total 50 questions in Kuwait, about 8 new questions out of 50


PULE

  • South Africa
  • Nov 28, 2013
  • Report Comment

This is dump 96% valid,i just passed with 9XX, there is only 2 new question.


Gopinath Ragothaman

  • Singapore
  • Nov 28, 2013
  • Report Comment

Hi took the test on Nov 28 2013 in Singapore, 48 out of 70 questions was from this .22 questions were new question.Passed with 887 marks.


karteina.d

  • South Africa
  • Nov 27, 2013
  • Report Comment

Hey guys, please direct me to the latest questions. thx.


Pass

  • Pakistan
  • Nov 27, 2013
  • Report Comment

Passed using this Dumps and got 887 marks, how ever almost 20 new question were there.


tip

  • United Kingdom
  • Nov 26, 2013
  • Report Comment

Passed. As others mentioned approx 20 new questions.
New questions included three mentioned from below comments
1)getting "error 5" (access denied) on pull partner
2.You plan to migrate the db to azure. you verify that all objects are valid for azure sql database.
You need to ensure that users and logins are migrated to azure.
what should u do?
A Use the Copy Database wizard
B Use the Database Transfer wizard
C Use the SQL Management Studio to deploy the db to azure
D Back up the database from the local server and restore it to azure
3) You need to ensure that users and logins are migrated to azure.
what should u do?
A Use the Copy Database wizard
B Use the Database Transfer wizard
C Use the SQL Management Studio to deploy the db to azure
D Back up the database from the local server and restore it to azure
4) A single instance of SQL Server is installed on the cluster.
An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster. What should you do?
No Run the Add Node to SQL Server Failover Cluster Wizard on Node C option. There was use config file from Node B option.
5)One question had different punch line ,You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data centre that hosts your production database. You need to ensure that the database remains available
If there is a power outage at the site, the Secondary is configured and ready for use without further user configuring.

6) database fails at 22:10, restore of tail log fail, need to restore transactional database with minimum data lost, which option.

7) restore the database using SSMS, check/drop down the correct options from the UI screen.
8)You need to minimize memory used by processes , two option, check the correct box. config min memory or config max memory.
9)Two questions on moving files to disks, you have three disk (different types (raid 1, raid 10), sizes) which files should be stored of which. 1 question had files types option of database data files,database log files,tempdb log files, tempdb data files.
10) You need to diagnose deadlocks over long period of time, must not effect performance,many options but included Extended Events and SQL Profiler. Went with X Events.
11) Question on roles. Stored procedure, All users must be able to run procedure and must be able to read all tables, minimum permissions,
12)Which features should be installed with SQL Server to do certain tasks, UI question (checking the correct options)

Sorry about the lack of info and wording on questions but just can't remember.
Hope it helps you out some what.

Thanks for all the help guys. Good luck.


DBAtadzislaw

  • Poland
  • Nov 26, 2013
  • Report Comment

Failed today. Only 10% of questions from this dump appeared on my exam. Please create new dump.

Not valid in Poland.


anon

  • United Kingdom
  • Nov 26, 2013
  • Report Comment

This dump still largely valid, passed today with 8** in UK. Thanks for the dump and the comments.
As others have said, approx 20 to 25 unseen questions out of 70, a few on migrating to Azure and existing questions reworded slightly.

As always with Microsoft there's often more than 1 correct answer, look for the subtle clue 'with minimum permissions' or 'minimum administrative effort' - normally tells you which of the correct answers they're looking for.

Emphasis on:
-Backup and restore - know differences between backup type/backup options/recovery models (also exam includes tail logs which dump does not)
-Backup/restore DB vs detach/attach DB (1 question asks about moving from 2005 to 2012, with scheduled downtime to test, how to do this as quick as possible - detach/attach is quicker and acceptable due to scheduled downtime).
-Clustered/Non Clustered Indexes
-Contained databases (full vs partial?)
-Azure (what tools to administer, query & data)

Good luck all.


Umar

  • Pakistan
  • Nov 26, 2013
  • Report Comment

Dumps are still valid, passed with 887. but 20+ question were new.


John

  • South Africa
  • Nov 26, 2013
  • Report Comment

Took exam on Thursday, had about 50% new questions..
Know your work!


Leda

  • Albania
  • Nov 25, 2013
  • Report Comment

Could anyone help with new 20 questions? Why it is so long, no one updates with a new dump,hope someone will do soon. Thanks


Avi

  • United States
  • Nov 25, 2013
  • Report Comment

Passes exam on 11/25, 780 Only 50% valid.


Muhammad Umar Saleem

  • Pakistan
  • Nov 25, 2013
  • Report Comment

These dumps are valid, Just passed 70-462 with 887, but Exam had total 70 Questions and to be very exact, 23 Questions were new(not in this Dumps)


x2x

  • Poland
  • Nov 25, 2013
  • Report Comment

I passed today with score 831. Dump still valid. New questions from: migration to azure,new server roles on azure,locating mdf,log,tempdb files on storage (raid10,raid5). Good luck


Mike

  • Sweden
  • Nov 24, 2013
  • Report Comment

Any updates on this exam? Going to take it on tuesday.


Anny

  • Sweden
  • Nov 21, 2013
  • Report Comment

Check out this link: http://msdn.microsoft.com/en-us/library/windowsazure/ff394116.aspx

Good Azure info


jb

  • United Kingdom
  • Nov 20, 2013
  • Report Comment

Still valid. Passed with 8xx.
Some Azure Q's but relating to Contained DB environments. Make sure you know the Azure owners (dbmanager, loginmanager)

Also got a question something about a web site environment and you need to make sure that the SQL installation allowed Basic Integration Services, Backup Compression, Low overhead costs. What installation version would you choose
A: SQL Express with Advanced Services
B: SQL Standard
C: Web Edition
D: SQL Express with Tools

Answer is B: Standard, as this is the only version from the list that allows Compression Backups.


Damian

  • United States
  • Nov 19, 2013
  • Report Comment

Around 30 new questions. Passed today but was quite hard. Good luck!


jim

  • United Kingdom
  • Nov 19, 2013
  • Report Comment

Dump is still valid. Passed with 8xx
There were about 12-15 new questions. There were 4 Azure questions but these were either what Azure roles (dbmanager, loginmanager) then match the other ones to SQL Database Roles. Or related to contained databases, which is covered in the MS Training Kit.
Also a question about what version of SQL server version to install to meet requirements for a web application that
Allow for basic Integration features. Allow Compression and keep costs down. Choose from
A. Standard Edition
B. Express With Tools
C: Express with Advanced Services
D. Web Edition


mili

  • United States
  • Nov 18, 2013
  • Report Comment

Passed with 775.this dump is still valid. i had 13-15 new questions ,mostly on Azure. some of the questions from the dump was the same but the answers(options) were different.


fry

  • Germany
  • Nov 18, 2013
  • Report Comment

Got nearly 800 pts. and 23 new questions (3 with azure).


pzerounoc

  • Italy
  • Nov 17, 2013
  • Report Comment

Please post the latest version of this dump i have this exam in few days. ty


GuyVer

  • South Africa
  • Nov 15, 2013
  • Report Comment

Passed today. Thanks a lot guys. But it was hectic. Got a total of 70 questions.

Two Azure questions. Three questions with relation to tempdb, userdb and raid. Clustering questions.

I would say the dump is about 60% valid for the exam that i wrote today. Just glad that i passed. Once again thanks for the dump.


ololo

  • Germany
  • Nov 15, 2013
  • Report Comment

This dump is valid. Passed yesterday in Europe with 8xx. However 20 new questions, but not actually hard. So do the reading!


ololo

  • Germany
  • Nov 15, 2013
  • Report Comment

This dump is valid. Passed yesterday in Europe with 8xx. However 20 new questions, but not actually hard. So do the reading!


an

  • Vietnam
  • Nov 15, 2013
  • Report Comment

this dump is still valid, exam has ~20 new question. I got 8xx today.


mili

  • United States
  • Nov 14, 2013
  • Report Comment

@Sajid Wasim .thank you for the pdf. so all the answers in the pdf are right answers ,right?


anon

  • United Kingdom
  • Nov 14, 2013
  • Report Comment

Can anyone confirm if answer for Exam D Q16 is wrong?
It says to use the ExtendedEvents tool to Troubleshoot the cause of high page_io latch. Would it not be System Monitor? As you can use SQLServer:Wait Statistics performance object in system monitor to find information about wait status for Page IO latch waits.

Can anyone confirm if the answer for this should be System Monitor instead of Xevents?


Sajid Wasim

  • Bangladesh
  • Nov 14, 2013
  • Report Comment

Download the pdf version from here:
https://dl.dropboxusercontent.com/u/14425563/Microsoft.Braindump2go.70-462.v2013-08-12.by.Raman.90q.pdf


KKK

  • Hong Kong
  • Nov 14, 2013
  • Report Comment

Took the exam yesterday on 13/Nov. Passed with 850 score
about 10 new question (4 of them are azure)
about 5 questions change from multiple select to Drap and Drop questions


mili

  • United States
  • Nov 13, 2013
  • Report Comment

hi everyone,
I am taking this exam in 2 days. Does anyone have the list of newly added questions-answers.

Thanks in advance!!!!


SanFran1122

  • United Kingdom
  • Nov 13, 2013
  • Report Comment

Took today, This is not valid, hardly any of the 70 questions were from this dump. Lots of new ones.


Anny

  • Sweden
  • Nov 12, 2013
  • Report Comment

Got 5XX today (only used the training kit and youtube videos) and found the test to be quite difficult. Many drag and drops (around 10), 4 azure related questions(!!).


jim

  • United Kingdom
  • Nov 12, 2013
  • Report Comment

I took that from a Transcender dump if the option was Transaction_Log not Transaction Log. Sorry for the confusion. Still think it will be COPY_ONLY answer.


jim

  • United Kingdom
  • Nov 12, 2013
  • Report Comment

@Albert @Jerzy
COPY_ONLY is correct.

Transaction_log - is no longer used with the BACKUP statement. To back up a transaction log, you must use the BACKUP LOG statement, not BACKUP TRANSACTION_LOG. So answer J is wrong in the VCE


Anon

  • United Kingdom
  • Nov 10, 2013
  • Report Comment

Passed 9xx, 1 azure question related to contained databases. About 15 new questions. Many existing ones have had answers shifted around.


jim

  • United Kingdom
  • Nov 10, 2013
  • Report Comment

Reply to Mike's question relating to improving query performance. I would choose
1. Cost Threshold for Parallelism
2. Max degree of Parrallelism

Anyone agree/disagree?


jim

  • United Kingdom
  • Nov 10, 2013
  • Report Comment

reply to mikes replication error 5 question. According to MS you should do the following:
1. Create a local Windows account on both the Publisher and Subscriber that has the same username and password.
2. Use this account for the Merge Agent process account and have the connections to the publisher and distributor impersonate the agent process account.
3. Ensure the account has the permissions required in Replication Agent Security Model.

This approach is covered in the section Use Windows Authentication to Set Up Replication Between Two Computers Running SQL Server in Non-Trusted Domains


Sean-MCT

  • South Africa
  • Nov 10, 2013
  • Report Comment

Best VCE of the bunch. Others have more errors.


mike

  • Canada
  • Nov 09, 2013
  • Report Comment

Came across the following question - I already passed, so someone else can research the answer. This is not the exact phrasing, but as long as you understand the options, I am sure you will be able to answer the question.

Question about slow performance of queries. If you right-click the instance and select properties, and then click the Advanced section, what options can be used to improve the performance of queries? (one or more selections)

Choose among:
1. blocked process threshold (currently set to 0)
2. Optimize for ad-hoc workload (currently set to True)
3. Parallelism Cost Threshold
4. Parallelism Max Degree
5. May have been other options as well?


Emile

  • Netherlands
  • Nov 07, 2013
  • Report Comment

Hi, is anyone familiar with the questions of measureUp.com ? These questions are much harder than this dump.


Frank

  • Poland
  • Nov 06, 2013
  • Report Comment

I pass the exam with 9XX. This dump is valid. Exactly 23 new questions.


Jerzy

  • Netherlands
  • Nov 06, 2013
  • Report Comment

Hi there, I haven't done a exam for a few years and I have a question. If there is a question that says "choose all that apply", will there be a number how much to apply like in "visual certexam manager" ?
In "visual certexam manager" in the lower left corner there is a hint "select x choices".


mike

  • Canada
  • Nov 05, 2013
  • Report Comment

New replication question - getting "error 5" (access denied) on pull partner. SQL services using virtual or local accounts. How to fix? Cannot remember options for answer - but I'm sure someone can research the error.


mike

  • Canada
  • Nov 05, 2013
  • Report Comment

Update on question: alternate valid answer for the following question is "DatabaseMailUserRole".

====
You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser.
Stored procedures in the database will use sp_send_dbmail to send email messages.
You create a user account in the msdb database for the AgentPortalUser login.
You use the Database Mail Configuration Wizard to create a Database Mail profile.
Security has not been configured for the Database Mail profile.
You need to ensure that AgentPortalUser can send email messages.
What should you do?


Mike

  • Canada
  • Nov 05, 2013
  • Report Comment

Regarding the following question, the list of choices are incorrect - the answer in the VCE uses a selection that is not on the exam . "Restore the full backup on SQL 2012". The only restore options are either "Restore the VSS backup on SQL 2012" or "Restore the database backup and transaction log backup on SQL 2012".

This will change the answer listed in the VCE, which currently includes the step "Restore the full database backup on SQL 2012".

===
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012.

The development team develops a new application that uses the SQL Server 2012 functionality.

You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application.

You need to migrate the database without affecting the production environment.

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


CK

  • New Zealand
  • Nov 05, 2013
  • Report Comment

Passed today with 904, hard exam! took a while and was cautious from the comments. Read the questions! some of mine sounded similar to the dump questions but had different answers

But with the dump i think i might have passed anyway. had about 15-20 new questions. Cant remember any though

Definitely wouldnt have passed without this, do your reading! It will help you answer the new questions and any thing MS have changed


MwendwaJK

  • Kenya
  • Nov 04, 2013
  • Report Comment

passed with 850. dump valid but there some new questions on azure


SuGu

  • Poland
  • Nov 01, 2013
  • Report Comment

Still valid - passed this week with 9xx. Many new questions (~20).


nav

  • India
  • Nov 01, 2013
  • Report Comment

Still valid dump. passed with 8xx on 31st oct from india.

Q) How to transfer all the logins from sql 2005 to 2012 ?
A) Using Transfer Login Task in ssis

Q 18) You use a contained database named ContosoDb within a domain.

You need to create a user who can log on to the ContosoDb database.

You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.

Which type of user should you create?


A.User mapped to a certificate
B.SQL user without login
C.Domain user
D.SQL user with login

Think c. Coz as per dump option B is not der in exam paper.

Concentrate on high data availablilty features and SQL Azure. With this dump we can easily score 700.


Albert

  • Belgium
  • Oct 31, 2013
  • Report Comment

@Jerzy:
Wrong answer. The good one is L. COPY_ONLY
cf Kat from Macau post
Others, Am I right?


Jerzy

  • Netherlands
  • Oct 31, 2013
  • Report Comment

Can anyone explane this question 56:
These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours.
Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.

On Wednesday at 10:00 hours, the development team requests you to refresh the database on a development server by using the most recent version.

You need to perform a full database backup that will be restored on the development server.
Which backup option should you use? A. NORECOVERY
B. FULL
C. NO_CHECKSUM
D. CHECKSUM
E. Differential
F. 8ULK_LOGGED
G. STANDBY
H. RESTART I. SKIP
J. Transaction log
K. DBO ONLY
L. COPY_ONLY M. SIMPLE
N. CONTINUE AFTER ERROR

Correct Answer: J
They ask "which backup OPTION should you use"
Transaction log is not an otion but a backup type.
I would say a "copy only backup".


cc

  • South Africa
  • Oct 30, 2013
  • Report Comment

Any one know if these answers are correct below?

You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL Server Agent jobs. To which role should you add UserA?

A. Securityadmin
B. RSExecRole
C. SQLAgentUserRole
D. DatabaseMailUserRole

think C
---
You administer a database that has User A, B and C
User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data, User C must be albe to provide windows logins to the database

db_accessadmin
db_ddladmin
db_datawriter
db_datareader
db_owner

To which role or roles should you add the users?

A = ddladmin
B=datawriter, datareader
C=accessadmin


cc

  • South Africa
  • Oct 30, 2013
  • Report Comment

Any one know if these answers are correct below?

1. u need to install the Power View Components on a stand alone server. Which three actions should you perform (and sorting)?
Possible choices:
A Install SQL 2012 Analyse Services
B Install SQL 2012 Reporting Services
C Install SQL 2012 Database Engine and PowerPivot for Sharepoint
D Configure SQL Server Reporting Services and Addin in sharepoint mode
E Configure SQL Server reporting services in native mode

my choice was: CBD

2.u plan to migrate the db to azure. you verify that all objects are valid for azure sql database.

u need to ensure that users and logins are migrated to azure.
what should u do?
A Use the Copy Database wizard
B Use the Database Transfer wizard
C Use the SQL Management Studio to deploy the db to azure
D Back up the databasae from the local server and restore it to azure

my guess: C

3 u maintain several dbs on a 64 bit ms sql 2005 instance
u need to migrate the dbs to sql 2012 on the same server. you also need to ensure functionality in sql 2012 can be used in the db after migration.
what should u do? (each correct answer presents part of the solution)
A Perform an in-place upgrade to 64-bit in sql 2012
B Perform a side by side installation of a 64 bit sql 2012
C Perform a side by side installation of a 32 bit sql 2012
D Detach the old instance and attach it to the new one
E Change the compatibility level of the db
my choices: BDE


Albert

  • Belgium
  • Oct 30, 2013
  • Report Comment

Exam B , Q3 :
I was wrong . The answer is correct.
cf. training kit book chapter 7 page 283

Sorry for the bad post


Albert

  • Belgium
  • Oct 30, 2013
  • Report Comment

Other question:
Exam B , Q3 : I'm not sure the dump is right .
When restoring the transaction log backup. I think that you have to do it WITH RECOVERY .if NORECOVERY (dump response), the db stays unavailable.

What is your opinion???


Albert

  • Belgium
  • Oct 30, 2013
  • Report Comment

@John,
For question Exam B Q18 :
In my opinion
1 ) execute BCP tool
2 ) Perform full backup
3 ) perform a database log backup
4 ) configure database to use full recovery model
5 ) configure database to use bulk log recovery model

3-5-1 dump is right.
The database has FULL and log backups.
So, if you want to rollback before the bulk insert:
-Recover the full backup
-Recover all backup logs done after full backup + the log backup done in (3)

The bulk-logged recovery model is set to follow the requirement :
The database transaction log is minimally affected.



Guys, am I wrong?


Albert

  • Belgium
  • Oct 30, 2013
  • Report Comment

@John:
I tested both on my server.
The dump is wrong. the good answer is NOT LIKE.
When I configured with LIKE, I can only create stored procedures with sp_% in the name. So, the opposite of what I need to do


Avi

  • Israel
  • Oct 30, 2013
  • Report Comment

Around 45-50 questions are from this dump.
Had a drag and drop question about configuring max memory, had a hard time to rememember if show adv. options is needed(it is).
Had a question that looked like - "create a private mail" answer question in this dump but without that option, I've answered - add to MailSomething role.
Had a similar question about transfering from 2005 to 2012 -full backup at 2005 -but then there was only full and log(? from where) restore at 2012 option.
There was a multiple choise question about sql (mirror ?) deployment with minimum security problems, d&d question what are azure and what are sql roles I've chose dbmanager and another dbSomething for azure all others for sql.
D&D audit question similar to question in the dump but with 2 similar "create audit specification" options only difference is execute as dbo/public, had no clue there.
Got 800+, bottom line is that this dump+little knowledge is still enough to pass, thanks to everyone who is posting questions here ang GL to everyone else!


John

  • Hong Kong
  • Oct 30, 2013
  • Report Comment

Another is Bulk Insert

http://social.technet.microsoft.com/Forums/sqlserver/en-US/c3eb3fbf-578e-4e64-a33d-e27632455b14/070462-bulk-insert?forum=sqldocumentation

You need to ensure that the following requirements are met during the bulk operation:
The database transaction log is minimally affected.
The database is online and all user transactions are recoverable. All transactions are fully recoverable prior to the import.

1 ) execute BCP tool
2 ) Perform full backup
3 ) perform a database log backup
4 ) configure database to use full recovery model
5 ) configure database to use bulk log recovery model

3->4->1 or 3->5->1 ??

or just "forget reality and just answer the question the way MS wants you too."


John

  • Hong Kong
  • Oct 30, 2013
  • Report Comment

About the condition is "Like" or "NOT Like"

http://social.technet.microsoft.com/Forums/sqlserver/en-US/6222b41a-fd51-47bf-ad4c-ccf06aa39b8e/070462-enable-condition?forum=sqldocumentation

In the real world is "NOT Like" ?
In the exam is "Like" ?

No idea.


Capoeira

  • Canada
  • Oct 29, 2013
  • Report Comment

Guys, Albert is right. I tested both conditions. The correct condition is "NOT Like".


John

  • Canada
  • Oct 29, 2013
  • Report Comment

Correction: I may be wrong. My assumption was that the "On Change: Prevent" would prevent a condition that matches the filter, but maybe it prevents any changes that do not match the filter. Trying to research, but not finding a definitive answer .


John

  • Canada
  • Oct 29, 2013
  • Report Comment

Albert, "Operator to LIKE" is correct.

You have to consider the evaluation mode.

"On Demand" evaluates the policy when directly specified by the user.

"On Change: Prevent" is an automated mode that uses DDL triggers to prevent policy violations.


Albert

  • Belgium
  • Oct 29, 2013
  • Report Comment

Error on exam B ( drag and drop) question 8 :
users are UNABLE to create sp with sp_ %
==>for the condition : operator NOT LIKE ! (wrong answer says LIKE)
It must be LIKE if users are only able to create sp with sp_%


Tony

  • United States
  • Oct 29, 2013
  • Report Comment

check the below link, its have the correct answers

http://www.mcseanswers.com/category/70-462-dumps


Chung L

  • Australia
  • Oct 28, 2013
  • Report Comment

Thanks guys! Passed it last week with 887 and most is still valid.
A bunch, +/-15 of new questions. Some questions only look the same but you need to read carefully as the answers are different.Some questions are completely different.
big thanks to b from Germany - Oct 09 2013, post, test from Austria, anon from United Kingdom - Oct 22 2013 and Baloght from Unknown - Oct 24 2013, for putting the different questions and outlining the difference.
Have a careful read on Azure management and security, user security rights, upgrading 2005 and 2008R2 servers and dbs to 2012 and you will pass it.
Good luck!


Paulina

  • Oct 28, 2013
  • Report Comment

Guys, I am planning to write an exam this Friday, please update the new staff. I'd appreciate it.


Avi

  • Israel
  • Oct 28, 2013
  • Report Comment

Is there a place where I can find the most recent dump?
There is no information about SQL-Azure in 70-462 Training Kit.


Baloght

  • Hungary
  • Oct 24, 2013
  • Report Comment

Passed exam with 850.
Thanks the help and questions. Help me a lot.
There was appr. 20-25 New questions:
You know Azure login,
you Plan to deploy Database to Azure, which components have to install the user, if he want to managed some queris and others in database
You have to know the index (clustered, non-clustered)
Drag and Drop question that which embedded users exists in Azure and which Sql local
There was a question that the table has some non-clustered index, and the query performance slow, you have to managed the index (Drop index, create index, rebuild index, .)
You have to know the SQL login settings, set default Database to user, set enforce password policy, .
You have to put 2008 32bit Database to same server 2012 64bit instance ( dettach, attach, set comp. level)

Good luck!!!


Zoubi

  • Jordan
  • Oct 24, 2013
  • Report Comment

Passed today with 793,More than 28 new questions out of 70 questions.
Good look


Diya

  • Jordan
  • Oct 23, 2013
  • Report Comment

Passed today with 868, round 30 new question.


anon

  • United Kingdom
  • Oct 22, 2013
  • Report Comment

Passed. Tough exam!
About 40% new questions, some rearranged, inverted questions (e.g same scenario or answers as dump but with different punch line/question line),
New questions nearly all of the drag and drop or UI type
Couple of UI based questions, it shows you a screenshot, you select the correct item in a drop down and/or check the correct options to achieve an outcome

Revise SQL and scenarios for using:
Filtered Indexes
Contained databases (configuration, permissions, full/partial)
Migration to Azure (standard DBSQL , switch to contained DB including users, migrate to Azure)
Azure roles (dbmanager, loginmanager)
Server/database roles, differences between them, SQL to create them
Server/database auditing including writing the SQL to create and alter them
Backup and restore, including tail logs
Side-by-side installation and when to use backup/restore over detach/attach

I used 70-462 self paced training kit MeaureUp tests, dumps from here (some have different q's so make sure you go through all dumps not just this one), and some random stuff I found online. I normally also use Transcender and am definitely thinking about getting it for 70-463.

Could I have passed without these dumps? No, even if the questions don't appear (and some of the answers are wrong) they guide you in the right direction and definitely prepare you for the test, so keep them coming please!

Pages:  [<<]  [<]  1 2 3  [>]  [>>]

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

Training Products

Premium File

  • 316 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 Training 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 Training 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 training 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.