MB7-702 Microsoft Dynamics NAV 2013 C/Side Development
Published: 18 January 2013
Languages: English, French, German, Spanish
Audiences: IT professionals
Technology: Microsoft Dynamics NAV 2013
Credit towards certification: MCP, MCTS
Skills measured
This exam measures your ability to accomplish the technical tasks listed
below. The percentages indicate the relative weight of each major topic area in
the exam. The higher the percentage, the more questions you are likely to see on
that content area in the exam.
Please note that the questions may test on, but will not be limited to, the
topics described in the bulleted text.
Describe the data and process models (10-15%)
Explain the table types and characteristics
Explain the characteristics of master tables, supplemental tables, subsidiary
tables, ledger tables, register tables, journal tables, document tables,
document history tables and setup tables
Describe the standard data model and process model
Describe the data model diagram, describe standard data flow and typical
data triggers
Preparation resources
Tables
Triggers
Design the data model
Implement master tables, pages and documents (10-15%)
Track participants
Develop participant tracking solutions, describe triggers and multi-language
support
Manage seminars, instructors and rooms
Describe seminar management; explain a setup table, master tables and pages;
design seminar management solutions; develop solutions to manage instructors and
rooms; create seminar tables and pages
Implement documents
Describe registrations; design a solution for registrations; develop
registrations; use objects as text files; describe multi-language functionality
in text messages; explain document pages, page functions, virtual tables,
temporary tables and system tables
Describe the table code
Describe seminar registration line table code, the seminar charge table, the
seminar comment line table and pages
Preparation resources
How Do I: Work with the Payment Registration for incoming payments in
Microsoft Dynamics NAV 2013 R2
Page Designer walkthroughs
Implement posting and dimensions (10-15%)
Explain posting and develop a posting solution
Describe the journal, ledger, register, tables and pages; identify journal
posting codeunits; explain the journal and document posting processes; describe
the example posting routine, existing objects, and code comments; diagnose
performance issues; create journal and document posting routines; create and
modify codeunits, tables, and pages for a posting solution; complete the journal
and ledger tables registration posting; create codeunits and pages for seminar
journal posting; create tables and pages for posted registration information;
modify tables, pages, and codeunits for resource posting; create codeunits for
document posting
Integrate seminar management with dimensions
Choose dimension types, set up dimensions, describe the dimensions data model,
design and develop integration of seminar management with dimensions
Preparation resources
Set up posting groups
Codeunits
Set up dimensions to mark transactions
Implement feature integration and role tailoring (10-15%)
Integrate seminar-management features
Modify tables that contain data, design and develop seminar feature integration
Enable the Navigate feature
Describe Navigate feature architecture, develop solutions for the Navigate
feature, integrate objects with the Navigate feature
Explain role tailoring
Describe the RoleTailored user interface, Role Centre, actions, ribbon,
activities, lists, charts and profiles
Develop the seminar manager Role Centre and department page
Design seminar manager Role Centre solutions, develop seminar management
department pages
Create and design MenuSuite objects
Describe the fundamentals of the MenuSuite object type, explain the design
levels, create and design MenuSuite objects, explain how searching functions by
using the Microsoft Dynamics NAV 2013 Windows client
Preparation resources
Navigation pane
Learn about the RoleTailored design
Walkthrough: Creating MenuSuites for the Microsoft Dynamics NAV Windows client
Create reports and manage statistics (10-15%)
Design and create a participant list report
Design and analyse solutions; differentiate between GUI design, functional
design and table design; create seminar participant lists
Develop invoice posting batch jobs
Design and analyse solutions, create invoice posting batch jobs
Manage seminar statistics
Design and analyse solutions, add statistics to the Seminar Management
module, create FlowFields of the Sum type, create seminar statistics pages
Preparation resources
Report design guidelines
Batch post purchase invoices batch job
SumIndexField Technology (SIFT)
Implement interfaces and Web Services (10-15%)
Automate email communication with participants
Explain how to implement automation and OCX controls to perform tasks by
using other applications, describe file handling functions to import or export
data, design and implement email capability
Explain Web Services
Explain Web Services architecture, SOAP Web Services, page operations with
SOAP Web Services, extension codeunits and OData Web Services; handle user
interface interactions
Develop a Web Service
Design, develop and test registration Web Services; create Web Services;
create Windows form applications to test Web Services
Preparation resources
How to: Send email messages
Overview of Microsoft Dynamics NAV Web Services
Web Service walkthroughs
Test and debug code (10-15%)
Test the seminar management solution
Describe test-driven development fundamentals; test features, codeunits and
functions; explain transaction models for test functions; describe the use of
ASSERTERROR in test functions; use handler functions; test pages; create and run
a test runner codeunit; design and develop seminar management test solutions;
create seminar management unit tests
Debug code
Activate the Microsoft Dynamics NAV Debugger, use breakpoints, run and track
code
Preparation resources
Testing the application
Walkthrough: Debugging the Microsoft Dynamics NAV Windows client
How do I: Use the Debugger in Microsoft Dynamics NAV 2013 R2
Optimise for SQL Server (10-15%)
Explain SQL Server integration and database tasks with Microsoft Dynamics
NAV
Explain the advantages of using SQL Server for Microsoft Dynamics NAV 2013,
describe Microsoft Dynamics NAV tables and indexes in SQL Server, explain how to
share data across companies, obtain a list of indexes and their definitions
Use collation, the SQL Server Profiler and the SQL Server query optimiser
Describe collation, order by sort, describe the value of the SQL Server
query optimiser, gather SQL Server statistics, explain SQL Server Profiler
terminology
Optimise a Microsoft Dynamics NAV application
Optimise SumIndexField Technology (SIFT) tables and indexes, describe the
index usage query, define keys to improve performance, describe implicit and
explicit locking, identify problems with NEXT, define suboptimal coding and
other performance penalties, analyse index usage, optimise C/AL code
Explain data access redesign
Describe simplified deployment, explain decreased resource consumption, identify
caching, describe performance improvements
Describe C/AL database functions and performance on SQL Server
Describe the GET, FIND, NEXT, CALCFIELDS, CALCSUMS, COUNT, SETAUTOCALCFIELDS,
INSERT, MODIFY, DELETE and LOCKTABLE functions; explain dynamic result sets
Describe bulk inserts, locking, blocking and deadlocks
Describe bulk inserts; identify bulk insert constraints; describe locking,
blocking and deadlocks; explain the benefits of avoiding deadlocks
Describe SIFT data storage in SQL Server
Identify SIFT data storage in SQL Server
Preparation resources
Optimising SQL Server performance with Microsoft Dynamics NAV
C/AL database functions and performance on SQL Server
SIFT and SQL Server
QUESTION 1
Which of the following options best describe the core aim of utilizing a function trigger?
A. It forms an indicator which is set upon a record pending modifications in the table
B. It forms an indicator to alert you upon the page being opened and the record being recaptured
from the required table
C. It forms an indicator to bring to your attention that the page has been loaded yet the controls
are still unavailable
D. It forms an indicator which is set upon a new record being added to a table
Answer: D
Explanation:
QUESTION 2
Which of the following posting groups will need to be included in a table if you are assigned the
task of creating a master table which represents entities with business associates?
A. Customer Posting Group
B. The Gen. Prod. Posting Group
C. VAT Business Posting Group
D. VAT Posting Setup
Answer: B
Explanation:
QUESTION 3
Which of the following statements regarding Text fields is true?
A. The Item table can have a Text field of up to 256 characters.
B. The Item table can have a Text field with a minimum of 156 characters.
C. The Item table can have a Text field of up to 250 characters.
D. The Item table can have a Text field of exactly to 186 characters.
Answer: C
Explanation:
QUESTION 4
Which of the following options states the correct amount of SumIndexFields one key is capable of
possessing in a FlowField?
A. A minimum of 10
B. Exactly 18
C. A maximum of 20.
D. A maximum of 22
Answer: C
Explanation:
QUESTION 5
Which of the following statements regarding bulk inserts is accurate?
A. Bulk inserts on the tables increase the capacity for server calls thus greatly advancing
performance capabilities.
B. Bulk inserts would be implemented upon needing to find statements therefore greatly lessens
the period in which the table is unlocked.
C. Bulk inserts would be implemented upon needing to alter or remove statements on the table as
this greatly lessens the period in which the table is locked.
D. The bulk inserts enhance the scalability by accelerating the insert in the transaction therefore
this greatly lessens the period in which the table is locked
Answer: C
Explanation: