MB-500 study plan
MB-500 · Give each week a clear focus.
8 weeks · About 6 hours per week
Apply developer tools & Plan the architecture and solution design
Set up a cloud-hosted development environment and provision a Tier-1 VM with an updated platform and application version.
Create a new model, project, and package inside a solution, then export the solution as a deployable file.
Trace a business requirement from a conceptual design note into a named AOT object list and an estimated build sequence.
Configure version control integration and demonstrate a check-out/check-in cycle with a code review request.
Your checkpoint
A one-page solution design brief plus a checked-in, deployable solution package that builds without errors.
Design and develop AOT elements
Build a table with a natural and surrogate key, an index, a relation, and a delete action, then validate it with a browser-based table record.
Extend an existing table and form through a table extension and a form extension without over-layering.
Create an enumeration, an extended data type, and a label file, and wire them into the new table.
Author a security role, duty, and privilege set that grants access to the new objects.
Your checkpoint
A fully buildable data-model package (table, EDT, enum, extensions, security artifacts) deployed to the dev environment with at least one record created through the UI.
Design and develop AOT elements & Develop and test code
Create a form with a grid, a details FastTab, and a button that calls an action menu item bound to a class.
Write a Chain of Command extension on an existing class method and on a form data source method, with a pre/post condition guard.
Implement a batch job class with SysOperation and run it end to end from the batch processing form.
Write a unit test class that exercises the new business logic with at least three assertions.
Your checkpoint
A working form-plus-batch-job feature with an accompanying runnable test class, all checked in with a build that passes.
Develop and test code
Write X++ that uses a transaction scope, a try/catch with an infolog, and a rollback on a validation failure.
Implement a set-based data operation and a record-by-record loop, then compare their execution plans using trace output.
Add an event handler subscriber for a standard table and a standard form event, and confirm it fires.
Refactor a duplicated method into a shared class and prove behavior is unchanged with the existing test suite.
Your checkpoint
A refactored code change with passing automated tests and a short written note on the performance impact of the set-based change.
Develop and test code & Implement security and optimize performance
Run the SysTest suite for the custom model and record any failures against the baseline.
Apply a performance tuning pass: fix a set-based query, add a covering index, and cache a repeated lookup.
Configure a role-based security model and verify field-level access with two test users of different roles.
Diagnose a slow form load using the trace parser and document the root cause.
Your checkpoint
A performance and security findings report containing at least one resolved bottleneck and a screenshot-free description of the security verification results.
Integrate and manage data solutions
Build a data entity over the custom table and expose it through an OData endpoint.
Implement a composite data entity and a staging table pattern for an import scenario.
Write a DIXF-style import that loads a CSV of test records and handles a duplicate-key error gracefully.
Create an integration using a service class and a JSON contract, and validate it with a simple console client or Postman-style call.
Your checkpoint
An import/export pipeline that round-trips 100 test records with a logged error-handling path for malformed rows.
Implement reporting & Integrate and manage data solutions
Modify an existing SSRS report by extending its data provider and controller class, and deploy it to the dev environment.
Design a financial or operational report with a parameter-driven query and a drill-through action.
Create a workspace or dashboard tile that surfaces the report data.
Publish a Power BI or embedded report consuming a data entity with row-level security honored.
Your checkpoint
A deployed report plus a dashboard element, with a one-page design document covering parameters, data source, and security.
Implement security and optimize performance & Plan the architecture and solution design
Complete a full-length timed practice assessment and score each domain separately.
Re-review every objective in the two lowest-scoring domains and close gaps with hands-on labs.
Rehearse the end-to-end lifecycle: build, deploy, test, and troubleshoot one custom feature from scratch.
Consolidate notes into a one-page architecture summary covering environments, ALM, and security model.
Your checkpoint
A scorecard from the timed practice run plus a remediation list showing all below-threshold domains brought to a passing score on a second attempt.
Milestones
Week 2: Deployable data-model package builds cleanly and is checked in; no over-layering used.
Week 4: Custom feature with form, batch job, and tests passes the full automated test suite.
Week 6: Import/export round-trip of 100 records succeeds with error handling demonstrated.
Week 8: Practice assessment score above 75 percent in every domain, with no domain below 70 percent.