MCTS (70-448) and MCITP (70-452)

Who is online?  0 guests and 0 members
Home  »  Blogs  »  marcoadf  »  MCTS (70-448) and MCITP (70-452)

MCTS (70-448) and MCITP (70-452)

change text size: A A A

posted 12/26/2011  by marcoadf -  Views: [4557] 

In the last September 28th I've passed my 1st microsoft certification. In fact, I've passed 2 microsoft certifications!! Yes, I was able to do both certification exams in the same day. It was my very first experience in certification exams.

I've got 1000/1000 pts in 70-452 and more than 900 pts in 70-448 (I think I missed 1 question). I believe 70-452 is easier, but this is my opinion.

My study/training was based in Testking and I had 3 weeks to be prepared. Not that I wanted, but because my company said so. Smile

3 weeks were enough in my case, considering that I only trained at night, after got home from working. But I will suggest you to take 3 weeks for each one of them. Embarassed

Good luck for those you who are willing to get certifications.

 

Skills Being Measured (70-448)

  1. Implementing an SSIS Solution (17%)
  2. Configuring, Deploying, and Maintaining SSIS (15%)
  3. Implementing an SSAS Solution (21%)
  4. Configuring, Deploying, and Maintaining SSAS (17%)
  5. Implementing an SSRS Solution (17%)
  6. Configuring, Deploying, and Maintaining SSRS (13%)

Skills Being Measured (70-452)

  1. Designing and Managing Reports (20%)
  2. Designing Data Mining Models (10%)
  3. Administering a BI Solution (15%)
  4. Designing the BI Architecture (21%)
  5. Designing and Deploying SSIS Packages (16%)
  6. Designing an Analysis Services Database (18%)
tags : Certification, Marco, training, microsoft, MCITP, marcoadf, 70-448, 70-452, exams, MCTS, study, testking, being, measured, skill
 
3.35
/5
Avg: 3.35/5: (2 votes)

Comments (9)

Reichglass5234
Reichglass5234 said:
Hello A couple of things. I am looking to to the MCITP 70-452 Exam in March, 2012. Based on your expeirience with this exam, how intensive is the focus on SSAS, data mining and MDX queries? So far, it is my experience that before getting your head completely around the SSAS usage and features it is critical to have at least an intermediate understanding or SSRS and SSIS usage and best practices. It's almost as if the SSAS skill set is built upon a certain mastery of data integration and reporting techniques. Would you agree? I am seeing more and more in recent weeks a higher demand for SSAS/MDX "experts" that have a deep understanding of those features. I have also seen a couple of cases where an IT/BI shop tried to hire someone with a good bit of SSRS/SSIS/SQL Dev Experience and ramp them up on SSAS/MDX. That experiment failed for both shops and both individuals involved. Would your assessment of SSAS/MDX skills be similar? Looking forward to hearing back from you. Take Care and great Blog!! Will
1/19/2012
 · 
Comment
 
by
marcoadf
marcoadf said:
Hi Will. As you can see in skills being measured, SSAS+Mining+MDX takes the most percentage in both exams. So in both exams there is an intensive focus and you will need a strong knowledge on them. About the second question, I disagree with you. There were questions about mdx that you do not need to know anything about ssis. I remember a question where you needed to get the parallel period of a certain member. This can be answered without no knowledge in SSIS. Same for mining, I remeber some questions about properties and mining models. I disagree on that, but to pass in this exam you will always need strong knowledge in BI stack in order you to pass both exams.
1/19/2012
 · 
Comment
 
by
Reichglass5234
Reichglass5234 said:
Thanks for the feedback. Was also looking at the Testking offerings and they have the 70-448 prep material marked as the MCITP prep material. I'm thinking this is not correct. If this is the case I already have that material. How did you prep for MCITP 70-452. I also have the book for "Delivering Business Intelligence with Microsoft SQL Server 2008" ISBN: 9780071549448, which seems to cover a good bit of material in the Skills being measured on 70-452. Any thoughts?
1/19/2012
 · 
Comment
 
by
marcoadf
marcoadf said:
No, 70-448 helps you get MCITP, I think that's what they want to say. Take a look to what you need http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2 70-448 + 70-452 = MCITP: Business Intelligence
1/20/2012
 · 
Comment
 
by
indupriya
indupriya said:
Congratulations Well Done!
1/19/2012
 · 
Comment
 
by
marcoadf
marcoadf said:
Thank you. I really appreciate that.
1/20/2012
 · 
Comment
 
by
Reichglass5234
Reichglass5234 said:
So I finally took the plunge and took 70-452. Did not pass. Needed a 700 and got a 656. So the strange thing is, I walked into the exam thinking that "Designing Data Mining Models" and "Designing Analysis Services Databases" would be the places where I where I would potentially get killed. Partly because I haven't really had any hands on where I currently work. Just the tutorials and the literature. But in reality, I got killed in "Designing and Deploying SSIS Packages" and "Administering a BI Solution". I work with SSIS nearly every day but the scenarios that were presented I was just simply stumped. So back to the drawing board to see if I can't fill in the gaps and improve that score to 1000.
7/22/2012
 · 
Comment
 
by
marcoadf
marcoadf said:
Well, sometimes this things happens. There are a lot of tricky questions, indeed. Some times we believe 2 answers are right, but you need to choose the best. In my case Data Mining were my problem. inspite of working with datamining and statistics in SAS and other software, I've never had the change to use that in my professional activity. So I downloaded some adventureworks so I could get better in this field. Wish you best luck for next time. Let us know from you soon.
7/23/2012
 · 
Comment
 
by
Nimesh
Nimesh said:
Hi All . I cleared 70-448 , on 29th Sept, 2012 . i put 733 out of 700. I used below books for preparation 1.) 70-448_Training_Kit_SQL_Server_2008_Business_Intelligence Development & mainitnance 2.) Guy Fouche, Lynn Langit - Foundations of SQL Server 2008 R2 Business Intelligence
10/1/2012
 · 
Comment
 
by
Kanagamanikandan
Kanagamanikandan said:
Hi all.Can anyone tell me which is easier Exam 70-448 or 70-452.Thanks.
10/26/2012
 · 
Comment
 
by
marcoadf
marcoadf said:
As I mentioned, I believe 70-452 was easier. But all depends on how ready you are and if you already experienced any of the skills being measured.
10/26/2012
 · 
Comment
 
by
Kanagamanikandan
Kanagamanikandan said:
Thank you very much for your kind response....
10/30/2012
 · 
Comment
 
by
anilmylavarapu
anilmylavarapu said:
Hi All. Today i've cleared 70-448 exam. i've used Microsoft Training material for cracking the exam. I was comfortable with SSIS and SSRS and was bit worried on SSAS. But at the end of the day have cracked the exam..Will take a break and will start working on SSAS. Best of luck for the people who are preparing for 70-448.
12/27/2012
 · 
Comment
 
by
Add a new comment
  • Name:*
  • Email:*
  • Website:
Type the characters you see in the image: *
Blogs RSS Feed

marcoadf's latest blog posts

Blogs RSS Feed

Latest community blog posts