Power Platform Interview Experience

Dynamics CRM CE Consultant Hands-on Interview Experience for Microsoft

This blog post is purely based on my personal experience and only intedended to provide information on what to be expected from the candidate when you are preparing for Dynamics CRM CE Hands-on interview round for Consultant role at Microsoft.

It started with my introduction and then some basic questions on Dynamics CRM Customer Engagement which I listed below –

  1. What is Parent Context in plugin?
  2. When do we use Pre-validation plugin?
  3. What is parrarel processing?
  4. Explain Change Tracking feature

Once I have explained answers to all the above questions, interviewer asked couple of scenario based questions which are listed below –

  1. Design a system for Two Way data sync in Dynamics CRM. Let’s say we have a legacy system and Dynamics CRM system, business wants to slowly migrate users from Legacy system to CRM Dynamics system. Records should be synced between these two systems in near real time. I was given 15 minutes to come up with the design solution and explain it to interviewer.
  2. Apple has many stores and each stores will have employees in it. Design a system in such a way that when Admin move user from one store to another, records assigned to that user will be assigned to Area Manager after 2 days of user movement and user should not have access to those records.

After explaining design solutons to above questions/requirements, I was told to implement full working demo solution in Dynamics CRM for below requirements –

Employee Management System Create a Entity Employee with following fields
Employee ID – Single line of text
Company – Account Lookup
Emergency Contact – Contact lookup
Mobile – Single line of text
Language known – Multi Select (Add any five language)
Department – Option set(HR, IT, Operations)
Is Full Time employee – Two Option
Date of Birth – Date
Salary – Currency
Age – whole Number
Consider following scenario Implement sequential auto number for Employee ID. Employee ID Should be unique. Auto Number implementation should be custom and not OOB
Create a console application to import the data from excel sheet. Excel sheet has the column of the employee record in dynamics.
Read data from excel sheet in console application
Create/update record in dynamics based on employee ID
If any new column added to the employee entity, there is no need to change the code. Console application should automatically do the mapping based on the column in excel sheet.
If there is any failure while creating the record, application should retry
There should be robust retry mechanism & error handling

I was asked by interviewer to come up with efforts in hours to complete full working demo, I told it will take 3 hours to complete and given only 2.5 hours including Data Model changes.

The key point in the requirement is to create a generic solution which will cover below requirement from original requirement.

If any new column added to the employee entity, there is no need to change the code. Console application should automatically do the mapping based on the column in excel sheet.

I am not going to provide solution for the above requirement in this blog post. If you want to know how can we achieve this requirement, please feel free to reach out to me on Linkedin/Twitter.

To implement Sequence Auto numbe, please check out below blog post for detailed walkthrough.

Note

  1. Make sure you follow proper coding standard when writting C# code while implementing the solution. This was the primary reason for my rejection, so please follow coding guideline which is explained here
  2. Even if you are not able to complete any of the requirement, make sure you convey your thought process and design solution to an interviewer
  3. You can use google during your interview process when you were asked to implement the requirements
  4. Code should be simple and concise. Do not try to complicate things in your logic, keep it simple and short

Hope this helps to anyone who is appearing for Dynamics CRM CE interview at Microsoft.

Happy Blogging!

Advertisement

2 thoughts on “Dynamics CRM CE Consultant Hands-on Interview Experience for Microsoft

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s