Microsoft 70-767, Implementing a Data Warehouse using SQL FAQ
What is Microsoft 70-767, Implementing a Data Warehouse using SQL exam?
The Microsoft 70-767, Implementing a SQL Data Warehouse exam is all about creating a data warehouse using ETLs (Extract, Transform and Load), implementing a data warehouse design, interacting with Azure technologies and maintaining the data with Data Quality Service (DQS). The 70-767 exam consists of 75% of SQL Server 2016 on-premises. 25% is about Azure Big Data, Azure SQL Data Warehouse and related topics. Also, Through this exam, you will understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package
Who is the Microsoft 70-767 exam intended for?
- If you are a business intelligence developer, ETL developer or an administrator, this exam is definitely intended for you. It also targets developers who perform the functions of data cleansing in addition to ETL and data warehouse implementation
What are the Prerequisites for the Microsoft 70-767 exam?
For the 70-767 exam, you should have experience about installing and implementing a Master Data Services (MDS) model, using MDS tools and creating a Master Data Manager database and web application.
The Microsoft 70-767 exam is definitely a way to open new heights in your professional career. It always better to know the exam details and be thorough with the syllabus before beginning with your preparations.
What is the course outline for the Microsoft 70-767 Exam?
- Designing, and implementing, and maintaining a data warehouse
- Extracting, transform, and load data
- Building data quality solutions
What number of questions will there be in the exam?
There will be around 40 to 60 questions in the exam.
What are the major question types covered in the Microsoft 70-767 exam?
Speaking of the exam pattern, here is a list of few types of questions you may encounter-
- Scenario-based single answer question
- Multiple-choice questions
- Arrange in the correct sequence type questions
- Drag & drop questions
- One case study with 5 questions
What is the time duration for the exam?
The exam needs to be completed in 120 minutes.
How much the Microsoft 70-767, Implementing a Data Warehouse using SQL exam will cost?
This exam will cost you $165 USD including the additional charges.
In how many languages you can give this exam?
The exam is only available in the English language.
What is the passing score for Microsoft 70-767, Implementing a Data Warehouse using SQL exam?
You need to get 700 marks on a scale of 1-1000 to pass the exam.
What does the score report look like?
A numeric score for overall exam performance is provided in the score report, status of pass/fail, and a bar chart showing performance in each skill area assessed in the exam. Using this information, the areas of strength and weakness of the candidates can be determined.
How the exam scores are calculated?
After the completion of your exam, the points you earned on each question are totaled and then compared with the cut score to determine whether the result is pass or fail.
How to schedule the exam?
There are two options to schedule the exam-
Firstly, for non-students interested in technology at Pearson Vue
Secondly, for students or instructors at Certiport
What is the exam cancellation policy?
If you want to cancel the exam then you have to do it at least 6 days prior to your appointment. In case you are not able to do it 24 hours prior to the exam then it may result in loss of the entire fee.
What is Microsoft 70-767 exam retake policy?
Microsoft allows 5 attempts per year for a specific exam. If you are not able to clear the exam in the first attempt, then you must wait at least 24 hours before retaking the exam. For the second reattempt, a waiting period of 14 days is required. All subsequent reattempts can be taken after 14 days waiting period.
After I complete a case study, will I be able to review the questions?
Until you move to another case or section, you can review the questions. However, once you’ve left that particular case study, you will be unable to review the associated questions. After completing a case study and answering its associated questions, a review screen will appear. This screen allows you to review your answers and to make necessary changes if you want, before jumping to another case study.
What is the process for determining if an exam has been updated when a new feature or function is added or when something has changed in the associated technology?
Microsoft reviews its cloud-based exams every two months. Any changes in the objective domain and the already existing questions are directly incorporated into the exam.
How will I know if the exam has been updated when a new feature or function is added or when something has changed in the associated technology?
Microsoft notifies about any such change or update, via the exam details page. Microsoft recommends you sign up for such communications to keep yourself informed about any updates.
How and when will I get my Microsoft 70-767 exam results?
Right after successfully completing your exam, you will be notified of your pass or fail status within a few minutes of
completing your exam. Also, printed reports providing your exam score and feedback on your performance will also be provided to you. Your score will be forwarded to Microsoft within five business days.
Beta Exam Result – Result will be visible on your Microsoft transcript. However, you will see your result only if you’ve achieved a passing score. Also, this result will be published on Pearson VUE’s site within 14 business days, after the live exam is published.
Who should I contact if I have questions concerning beta exam results?
If you have not received any report within two weeks after the final exam got published, then you must contact the exam delivery provider. Contact Certification Support, for any query related to your transcript.
Who should I contact if I do not receive my 25% voucher for taking a beta exam?
If you have not received your discount voucher within 4 weeks of the live exam, then you must contact the customer service support team of the exam delivery provider.
Can I find out whether I answered a specific question correctly or whether how I answered a specific question affected my pass/fail status?
No, you cannot get such a detailed report. Microsoft aims to measure candidates’ skills for a given job role, and not their ability to memorize questions. Microsoft does not share such information to protect the integrity of its certification process.
How are questions scored? How many points is each question worth? Will I be penalized for answering a question incorrectly?
- Most of the questions are one point questions
- No negative marking
- Some questions are unscored – Microsoft will not provide information about such questions
How are exam scores calculated?
After completing the exam, the earned points are summed up and compared with the cut score to determine your exam status.
What score do I need to pass Microsoft 70-767 exam?
A passing score of 700 and above is required to receive your Microsoft Certification.
I passed my first Microsoft Certification exam. Now, what do I do?
Congratulations! See your benefits and exams dashboard, and explore the benefits you have at hand.
Can I request a re-evaluation of my score?
In case Microsoft encounters and error in the questions given in the exam, then it provides candidates to retake the exam free of charge. We recommend you to submit an online request, if you have any query related to the technical accuracy of any specific item. After submitting your request, an Item Challenge form will be sent to you.
How can I challenge an exam question?
You can request an evaluation of that particular question via the Exam Item Challenge process. You can submit the challenge within 30 calendar days of taking the exam.
