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:
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:
