Microsoft Dynamics Expand and Test Your Skills Practice Test Set 2

Which two actions occur during the test-driven development (TDD) refactor phase? (Each correct
answer presents part of the solution. Choose two.)
A. New test code is written.
B. Production code is written to make the test code pass.
C. Test and production code is redesigned for improvement.
D. Duplication is removed from the test and production code.


Options are :

  • BD
  • AB
  • BC
  • CD

Answer : BD

You are designing a table with a Customer Name field that must not be stored. The table must
derive its contents from the Name field on the Customer table. The Customer Name field must
then be used in a C/AL function. How should you create the Customer Name field and then
access it using C/AL code?


Options are :

  • Create the Customer Name as a FlowFilter field. In the code, use the CALSUMS function to evaluate the value of Customer Name.
  • Create the Customer Name as a Normal text field. In the code, use the EVALUATE function to evaluate the value of Customer Name.
  • Create the Customer Name as a FlowField with a Method set to Lookup. In the code, use the CALCFIELDS function to evaluate the value of the Customer Name.
  • Create the Customer Name as a FlowFilter field. In the code, use the EVALUATE function to evaluate the value of Customer Name.

Answer : Create the Customer Name as a FlowFilter field. In the code, use the CALSUMS function to evaluate the value of Customer Name.

You create a Seminar Registration Line table. You need to ensure that the Line Discount Amount
is always calculated correctly.
You need to add the following code segment to the table:
"Line Discount Amount":= ROUND("Line Discount %" * Item. "Seminar
Price" * 0.01,GLSetup.
"Amount Rounding Precision");
On which trigger should you add the code segment?


Options are :

  • OnModify
  • Line Discount Amount - OnValidate
  • Quantity - OnValidate
  • Line Discount % - OnValidate

Answer : Line Discount % - OnValidate

Microsoft 70-647 Windows Enterprise Administrator Exam Set 2

What is a function trigger?


Options are :

  • A system flag (trigger) that is raised whenever a built-in function in Microsoft Dynamics is run
  • A set of C/AL statements run when called by other C/AL code
  • A system flag (trigger) to indicate to Microsoft Dynamics that a function has run successfully
  • A system indicator that is set when a new record is inserted into a table

Answer : A system flag (trigger) that is raised whenever a built-in function in Microsoft Dynamics is run

You create a new page in Microsoft Dynamics . You notice a table 2000000039 printer.
Which type of table is it?


Options are :

  • System table
  • Special table
  • Virtual table
  • Temporary table

Answer : Virtual table

You need to create a master table representing entities with whom business is conducted. Which
posting group must you include in the table?


Options are :

  • The Gen. Bus. Posting Group
  • The Gen. Prod. Posting Group
  • The VAT Prod. Posting Group
  • The VAT Bus. Posting Group

Answer : The Gen. Prod. Posting Group

Microsoft Dynamics Expand and Test Your Skills Practice Test Set 1

You need to add a new Text field to the Item table. What is the maximum length of Text fields in a
table?


Options are :

  • 80
  • 200
  • 250
  • 1024

Answer : 250

You need to develop a Microsoft Dynamics NAV solution in an environment where many users
use different languages on their computers. What should you do?


Options are :

  • Develop the solution in different databases (one for each language required).
  • Develop different objects with a different CaptionML for each language required.
  • Develop the solution in American English and provide language-specific names using CaptionML, OptionCaptionML and InstructionalTextML.
  • Develop the solution in American English and provide language-specific names by using the Tools menu and clicking Language.

Answer : Develop the solution in American English and provide language-specific names by using the Tools menu and clicking Language.

You need to get the list of indexes for a Microsoft Dynamics NAV table from the Microsoft SQL
Server Management Studio. Which command should you use?


Options are :

  • DBCC SHOW_STATISTICS [$< Table Name>]
  • sp_helpindex [S< Table Name>]
  • sp_helpindex ([$< Table Name>],[$])
  • DBCC SHOW_STATISTICS ([$< Table Name>],[$])

Answer : sp_helpindex [S< Table Name>]

Microsoft 70-642 Windows Server Network Infrastructure Exam Set 6

How many SumIndexFields can one key have?


Options are :

  • 8
  • 12
  • 20
  • 24

Answer : 20

Which statement about bulk inserts is true?


Options are :

  • Bulk inserts do not work when you issue any FIND statements on the table, and bulk inserts are performed when you issue a MODIFY or DELETE statement on the table.
  • In T-SQL, bulk inserts translate to BULK INSERT, and bulk inserts do not work when you issue any FIND statements on the table.
  • Bulk inserts are performed when you issue a MODIFY or DELETE statement on the table, and bulk inserts reduce the time that the table is locked.
  • In T-SQL, bulk inserts translate to BULK INSERT, and bulk inserts reduce the time that the table is locked.

Answer : Bulk inserts are performed when you issue a MODIFY or DELETE statement on the table, and bulk inserts reduce the time that the table is locked.

Which FlowField methods are SIFT Indexes used for?


Options are :

  • LOOKUP, MAX, and MIN
  • COUNT, AVERAGE, and SUM
  • SUM, AVERAGE, and LOOKUP
  • COUNT, MAX, and MIN

Answer : LOOKUP, MAX, and MIN

Microsoft Certified Solutions Developer (MCSD) For 2019 Set 2

In which two locations can you start the debugger? (Each correct answer presents a complete
solution. Choose two.)
A. Microsoft Dynamic NAV Development Environment client
B. Microsoft Dynamics NAV Server snap-in
C. The RoleTailored client
D. Internet Explorer by browsing to Dynamicsnav:////Runpage?Page=9506


Options are :

  • AD
  • AB
  • BC
  • CD

Answer : AD

You need to debug codeunit 80 - Sales Post on a sales order to validate whether the Invoice
variable changes status during the execution of the codeunit. How should you add the Invoice
field to the Watches list in the debugger?


Options are :

  • In the Watches section, click the Action menu item, and then click the Customize button.
  • Click the Variable button on the ribbon menu. Then find the variable and click the Add Watch button.
  • Find the Invoice variable in the code section, right-click it, and then click the Add Watch button.
  • Click the Set/Clear Condition button on the ribbon menu. Then find the variable and click the Add Watch button.

Answer : Click the Variable button on the ribbon menu. Then find the variable and click the Add Watch button.

Which three core codeunits does Journal Posting have? (Each correct answer presents part of
the solution. Choose three.)
A. Journal - Post Batch
B. Journal - Post Line
C. Journal - Post ± Print
D. Journal - Post
E. Journal - Check Line


Options are :

  • BCE
  • ABC
  • BCD
  • CDE

Answer : BCE

Which Dimension table contains dimension values that are linked to a Seminar Ledger Entry?


Options are :

  • 348 - Dimension
  • 349 - Dimension Value
  • 369 - Selected Dimension
  • 480 - Dimension Set Entry

Answer : 480 - Dimension Set Entry

Microsoft 70-642 Windows Server Network Infrastructure Exam Set 5

How many dimension columns must be created on a Seminar Journal Line Page?


Options are :

  • Two
  • Six
  • Eight
  • Ten

Answer : Eight

You validate that the Seminar Registration feature follows the standard journal posting process.
On which object did you implement the Emptyline function?


Options are :

  • Seminar Journal Line table
  • Seminar Jnl.-Check Line codeunit
  • Seminar table
  • Seminar Jnl.-Post Line codeunit

Answer : Seminar Journal Line table

You need to ensure that dimension values are updated when you change the global dimensions
in the master data table. Which function should you use?


Options are :

  • SaveDefaultflim
  • UpdateDefaultDirn
  • GetDefaultDimID
  • ValidateDimValueCode

Answer : SaveDefaultflim

Microsoft Certified Solutions Developer (MCSD) For 2019 Set 1

You see the following SQL statements run:

Which command(s) have been used to read the data in Microsoft Dynamics?



Options are :

  • FINDSET(TRUE, TRUE)
  • FINDSET(FALSE)
  • FINDSET(TRUE)
  • LOCKTABLE and FINDSET

Answer : FINDSET(FALSE)

You add a new key with a number of SumIndexFields to an existing custom table. Users report
that creating, modifying, and deleting records in the table takes more time than expected. Which
change will diminish the time it takes to create, modify, and delete records?


Options are :

  • Set the CalcFields property of the table to point to the SumIndexFields.
  • Set the FieldClass property of each SumIndexField to FlowField.
  • Change the order of the SumIndexFields.
  • Set the MaintainSIFTlndex property of the key to No.

Answer : Set the MaintainSIFTlndex property of the key to No.

When browsing through the tables of a Microsoft Dynamics NAV database, you see a table that is
named CRONUS International Ltd_$17 $1. Which two statements about the CRONUS
International Ltd_$17$1 table are true? (Each correct answer presents a complete solution.
Choose two.)
A. The table is related to a table with an ID of 17.
B. It is in a database with a version number older than Microsoft Dynamics NAV Version 5 Service Pack 1.
C. The table contains total values represented by the first key from the related table with SumIndexFields.
D. The related table contains one key with SumIndexFields.


Options are :

  • AB
  • BC
  • CD
  • AD

Answer : AB

Microsoft 70-642 Windows Server Network Infrastructure Exam Set 3

Which group of C/AL functions uses caching on the Microsoft Dynamics Server?


Options are :

  • SETRANGE, GET, NEXT, COUNT
  • CALCSUMS, COUNT, FINDSET, SELECTLATESTVERSION
  • ISEMPTY, SELECTLATESTVERSION, COUNT, SETRANGE
  • GET, COUNT, FINDSET, ISEMPTY

Answer : GET, COUNT, FINDSET, ISEMPTY

Which two statements about the C/AL LOCKTABLE command are true? (Each correct answer
presents a complete solution.


Options are :

  • All records in the table read by SQL Server are locked to ensure database integrity.
  • The command is valid for all subsequent instances of record variables based on the table within the transaction.
  • Only records in the table within the filter are locked by SQL Server to ensure database integrity.
  • The command locks the table in SQL Server to ensure database integrity.

Answer : Only records in the table within the filter are locked by SQL Server to ensure database integrity.

What is the Microsoft Dynamics NAV name for a Microsoft SQL Server index key?


Options are :

  • Secondary key
  • Primary key
  • Field in a key definition
  • Heap

Answer : Primary key

Microsoft 70-647 Windows Enterprise Administrator Exam Set 7

You see the following consecutive SQL statements while profiling:

When looking up the C/AL code you see following code:
Cust.FINDFIRST;
Which C/AL statement on the Cust variable generates the second SQL statement?



Options are :

  • FINDSET
  • NEXT
  • FINDLAST
  • REPEAT

Answer : NEXT

You write the following C/AL code segment:
GLSetup.LOCKTABLE;
GLSetup.GET;
Which statement is true about the caching of data from the GLSetup table?


Options are :

  • The data will be cached in the private cache of the Microsoft Dynamics Server.
  • The data is not cached because only results from query objects are cached.
  • The data will be cached in the global cache of the Microsoft Dynamics Server.
  • The data is not cached because this is a locking transaction.

Answer : The data will be cached in the private cache of the Microsoft Dynamics Server.

You design a new table in Microsoft Dynamics NAV named Circuit. You set the DataPerCompany
property to No. You do not change the default keys. What is the name of the clustered index that
is created in Microsoft SQL Server for a company named "CRONUS International Ltd."?


Options are :

  • CRONUS International Ltd_$Circuits0
  • CRONUS International Ltd_$Circuit
  • Circuit$0
  • Circuit

Answer : Circuit$0

Microsoft Windows Server 2016 Certification: Exam 70-741 Set 6

You have developed new functionality and need to show a message by using a dialog box in
several languages. How should you create the dialog message?


Options are :

  • Add a Text Constant and use the ConstvalueML property.
  • Add a new variable as text and add the languages using the OptionCaptionML property.
  • Add a new variable as text and add the languages using the CaptionML property.
  • Create a variable with the Dialog datatype and then add the languages.

Answer : Add a Text Constant and use the ConstvalueML property.

An application has been multilanguage-enabled. Users report that a number of field names are
displayed in English and not in their local language. Which three property misconfigurations can
apply? (Each correct answer presents a complete solution. Choose three.)
A. The CaptionML property of the associated page controls contains only an ENU value.
B. The CaptionML property of the fields contains only an ENU value.
C. The CaptionML property of the fields is empty.
D. The Name property of the fields is empty.
E. The CaptionML property of the associated page controls is empty.


Options are :

  • BCE
  • ABC
  • BCD
  • CDE

Answer : BCE

You create a Seminar Charge table with a Type field and a No. field. You need to ensure that
lookups always go to the GIL Account table, the Resource table, or the Item table based on a
respective type of GIL, Resource, or Item. What should you do?


Options are :

  • Only create an OptionString property on the Type field with the G/L Account, Resource, and Item values.
  • On the Type field, use the TableRelation property with a link to the No. field.
  • Create an OptionString property on the Type field with the G/L Account, Resource, and Item values. Then, on the No. field, use the TableRelation property with a link to the Type field.
  • Add code to the Type - OnLookup trigger on the Seminar Charge List page to run a GIL Account, Resource, or Item-List page.

Answer : Only create an OptionString property on the Type field with the G/L Account, Resource, and Item values.

Microsoft 98-367 & 98-368 Certification Practical Exam Set 1

Which statement is true of a setup table for an application area?


Options are :

  • There must only be a single setup record per application area, with the primary key field named Primary Key in the Table Designer.
  • Setup records may not be modified by users. Setup data is populated by developers to ensure the correct behavior of the application area.
  • There can be several setup records per application area, with the primary key field named Primary Key in the Table Designer.
  • There can be several setup records per application area, with the primary key field named Setup in the Table Designer.

Answer : There can be several setup records per application area, with the primary key field named Primary Key in the Table Designer.

You need to create a new transaction document in Microsoft Dynamics NAV. The data structure
consists of a header with associated line items. Which pages do you need to create?


Options are :

  • One page with a Type set to Document for the header and a page with a Type set to ListPart for the line items.
  • One page with a Type set to Document for the header and a page with a Type set to List for the line items.
  • One page with a Type set to Card for the header and a page with a Type set to ListPart for the line items.
  • One page with a Type set to Card for the header and a page with a Type set to List for the line items.

Answer : One page with a Type set to Document for the header and a page with a Type set to ListPart for the line items.

You need to add a new field to the Resource table. The field is named LocationType and must
have a value of Internal or External. Which data type should you use?


Options are :

  • Option
  • Code
  • Selection
  • Option String

Answer : Option

Microsoft Certified Solutions Developer (MCSD) For 2019 Set 2

You create a Statistics page based on the Seminar table. You need to calculate the Number of
Participants that have registered for the seminar during the first 14 days of January, 2013. Which
C/AL code segment should you use?



Options are :

  • Option A
  • Option B
  • Option C
  • Option D

Answer : Option B

70-646 Pro Windows Server 2008,Server Administrator Test Set 3

You have a setup table and page.
You must insert the following code segment into a page trigger:
RESET;
IF NOT GET THEN BEGIN
INIT;
INSERT;
END;
Which trigger should you select?


Options are :

  • OnInit
  • OnOpenPage
  • OnClosePage
  • OnQueryClosePage
  • OnFindRecord

Answer : OnOpenPage

You open a report in the Report Dataset Designer. You notice that the Report Dataset Designer
shows only one DataItem row and no Columns rows, even after you try to expand the data item
row. Why does the Report Dataset Designer show only one DataItem row and no Columns rows?


Options are :

  • The report is a processing-only report.
  • The UseRequestPage property of the report is set to Yes.
  • The table assigned to the data item row does not contain any fields.
  • The PrintOnlyIfDetail property of the data item is set to Yes.

Answer : The report is a processing-only report.

You need to write code in a Report object that performs posting logic. In which trigger do you
write the code so that it is performed just before the first record of the data item is read?


Options are :

  • OnPostDataltem
  • QnPreDatatern
  • OnPreReport
  • OnInitReport

Answer : QnPreDatatern

70-247 Configuring and Deploying a Private Cloud Exam Set 4

You need to update the Seminar Reg.-Participant List report so that it includes the option field
named Status. Which action should you perform in the Report Designer?


Options are :

  • On the DataltemTableView property of the Seminar Registration Header data item, select a key that contains the Status field.
  • Add a text box for the Status field to the Seminar Registration Header data item.
  • Add a Column row for the Status field to the Seminar Registration Header data item.
  • Select the Include Caption check box on the Column row for the Status field.

Answer : Add a Column row for the Status field to the Seminar Registration Header data item.

You are designing a system that allows users to see a list of posted documents from a menu. The
list must open from within the menu window, not a separate window. When users double-click
one of the records in the list, the document page must open. You need to set the properties of the
menu item to meet the requirements. Which properties should you use?


Options are :

  • Object Type = Query and Department = History
  • Object Type = Page and Department = History
  • Object Type = Query and Department = Tasks
  • Object Type = Page and Department = Documents

Answer : Object Type = Page and Department = History

You need to create a new Role Center. Which two settings are mandatory on a Role Center?
(Each correct answer presents part of the solution. Choose two.)
A. The Layout property must be set to Columns.
B. The Editable property must be set to NO.
C. The RunPaqeMode property must be set to View.
D. The first line of each page must have a Type=Container and a subtype=RoleCenterArea.
E. The PageType property must be set to RoleCenter.
F. The first line of each page must have a Type=ActionContainer and a second line with a Type=Container
and a subtype= RoleCenterArea.


Options are :

  • BE
  • AB
  • BC
  • CD
  • DE
  • EF

Answer : BE

Microsoft 70-243 Administering Deploying System Manager Exam Set 2

You are designing an Activities page for a company's purchasing department. You need to
ensure that users are able to create a new purchase order from this Activities page. On which
part of the Activities page do you define the action of creating a new purchase order?


Options are :

  • Type = Field and no Sub Type
  • Type = Container and SubType = ContentArea
  • Type = Group and SubType = CueGroup
  • Type = Container and SubType = RoleCenterArea

Answer : Type = Group and SubType = CueGroup

Which three changes can always be made to table fields? (Each correct answer presents a
complete solution. Choose three.)
A. Modify the Field No. property.
B. Change the FieldClass property from FlowField to Normal.
C. Modify the Caption property.
D. Change the Enabled property to No.
E. Decrease the length of a text or a code field.
F. Modify the InitValue property.


Options are :

  • BDE
  • ABC
  • BCD
  • CDE
  • DEF

Answer : BDE

You need to debug codeunit 80 - Sales Post on a sales order to ensure that a certain set of lines
are performed. How should you debug it?


Options are :

  • Start the debugger and select a session that is ready to post a sales order. The debugger starts when you choose Post (F9) on the ribbon menu.
  • Only start the debugger and select a session that is ready to post a sales order.
  • Set a breakpoint trigger in codeunit 80, and then select a session that is ready to post a sales order. The debugger starts when you press Post (F9) on the ribbon menu.
  • Start the debugger and select a session that is ready to post a sales order. Then click the Set/Clear Condition button on the ribbon menu to mark codeunit 80 to be debugged.

Answer : Set a breakpoint trigger in codeunit 80, and then select a session that is ready to post a sales order. The debugger starts when you press Post (F9) on the ribbon menu.

Microsoft 98-367 & 98-368 Certification Practical Exam Set 1

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions