Microsoft Dynamics Expand and Test Your Skills Practice Test Set 1

In Microsoft Dynamics, for which two actions can you use a Microsoft SQL Server collation?
(Each correct answer presents part of the solution. Choose two.)
A. to specify the sort order to use for Unicode data types per company
B. as the code page that is used to store non-Unicode character data per company
C. as the code page that is used to store non-Unicode character data per database
D. to specify the sort order to use for Unicode data types per database


Options are :

  • BD
  • AB
  • BC
  • CD

Answer : BD

70-646 Pro Windows Server 2008 - Server Administrator Exam Set 1

You have the following C/AL code segment:
ItemLedgerEntry.SETCURRENTKEY("Item No.");
ItemLedgerEntry.FINDSET;

You have the following query, based on the C/AL code segment:

SELECT * FROM "CRONUS International Ltd_$Item Ledger Entry" ORDER BY
"Item No_", "Posting Date", "Entry No_"

Which two statements are true based on the query? (Each correct answer presents a complete
solution. Choose two.)

A. If the second key in the table is "Item No.", then it must be disabled. The key "Item No.", "Posting Date" will be used instead.
B. The key "Item No.", "Posting Date" is the first key in the list that starts with the field "Item No." in the Item Ledger Entry table.
C. The SQLIndex value of the key "Item No.", "Posting Date" has been entered with the value "Item No.".
D. The SQLIndex value of the key "Item No." has been entered with the value "Item No.", "Posting Date".


Options are :

  • AD
  • AB
  • BC
  • CD

Answer : AD

What does the Vendor.SETAUTOCALCFIELDS function call do?


Options are :

  • It removes the automatic calculation of all FlowFields on the vendor record variable when retrieving vendor records from the database.
  • It sets the automatic calculation of only the first FlowField on the vendor record variable when retrieving vendor records from the database.
  • It sets the automatic calculation of all FlowFields on the vendor record variable when retrieving vendor records from the database.
  • It removes the automatic calculation of only the first FlowField on the vendor record variable when retrieving vendor records from the database.

Answer : It sets the automatic calculation of only the first FlowField on the vendor record variable when retrieving vendor records from the database.

You have the following C/AL code:
You must modify code that loops through the purchase lines of a purchase order to sum up the total quantity of items on the order.
You need to select a method to replace the WHAT_FIND_METHOD.
Which method should you use?



Options are :

  • FINDLAST
  • READ
  • FINDFIRST
  • FINDSET

Answer : FINDSET

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

In SQL Server Profiler you view the following query from Microsoft Dynamics NAV:


SELECT SUM("Amount") FROM "CRONUS International Ltd_$Sales Line" WHERE
"Document No_" = `ORD-980001'


Which two statements are true? (Each correct answer presents a complete solution. Choose two.)


A. There is no SumIndexField amount on the Sales Line table for a key that includes the Document No. field.
B. The MaintainSIFTIndex property is set to FALSE for a key that includes the Document No. field and the Amount field set as SumIndexField.
C. All keys that include the Document No. field and the Amount field set as SumIndexField are disabled.
D. There is no SumIndexField Technology (SIFT) bucket enabled in the property SIFTLevelsToMaintain for the Amount field for a key that includes the Document No. field and the Amount field set as SumIndexField.


Options are :

  • AB
  • AC
  • BC
  • CD

Answer : AB

When is the OnAfterGetRecord trigger run in a report object?


Options are :

  • After each individual Data Item record is updated.
  • After each individual DataItem record is retrieved.
  • Only after the last DataItem record is updated.
  • Only after the last DataItem record is retrieved.

Answer : After each individual DataItem record is retrieved.

You plan to create a Statistics page based on a table with information of training courses sold
over time. You need to create a calculated field with the number of training courses sold and a
date filter to make it possible to get figures based on day, week, month, or year. Which two fields
should you create?


Options are :

  • Sold Training Courses field with the FieldClass=FlowFilter property and Date field with the FieldClassFlowFilter property
  • Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClass=FlowFilter property
  • Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClassFlowField property
  • Sold Training Courses field with the FieldClass=FlowFilter property and Date field with the FieldClassFlowField property

Answer : Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClass=FlowFilter property

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

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 :

  • Select the Include Caption check box on the Column row for the Status field.
  • Add a Column row for the Status field to the Seminar Registration Header data item.
  • 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.

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

You build a simple sales document list report with the following dataset structure in the Report
Dataset Designer:

You design the report layout by using Visual Studio. After saving and compiling the report, you
run it to check the result and notice that the Company Name is not shown in the Page Header.
When you inspect the text box in the report layout you see that the value equals = Fields'
Name_CompInfo.Value.



Options are :

  • Add an appropriate filter to the page header.
  • Change the value of the text box to Last(Fields!Name_CompInfo.Value, "DataSet_Result").
  • Change the value of the text box to = First (Fields!Name_CompInfo.Value, "SataSet_Result").
  • Add an appropriate filter to the text box.

Answer : Change the value of the text box to Last(Fields!Name_CompInfo.Value, "DataSet_Result").

You need to create a Seminar Statistics page that shows a decimal field by using SumlndexField
Technology (SIFT). Which calculation of the CalcFormula method should you use?


Options are :

  • LOCKUP
  • EXIST
  • SUM
  • COUNT

Answer : SUM

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

For each ledger entry table, you have the following table search code segment in the
FindRecords function on the Navigate page:



Options are :

  • LedgerEntryTable. READPERMISSION
  • LedgerEntryTable.FINDLAST
  • LedgerEntryTable.FINDFIRST
  • NOT LedgerEntryTable.ISEMPTY

Answer : LedgerEntryTable. READPERMISSION

What are the characteristics of a Cue table?


Options are :

  • It contains a single record, with each cue being a field with a FieldClass of FlowField and with a DataType of Integer.
  • It contains many records, one for each cue. The table is defined with a single field with a FieldClass of FlowField and with a DataType of BigInteger.
  • It contains a single record, with each cue being a field with a FieldClass of Normal and with a DataType of BigInteger.
  • It contains many records, one for each cue. The table is defined with a single field with a FieldCIass of Normal and with a DataType of BigInteger.

Answer : It contains a single record, with each cue being a field with a FieldClass of FlowField and with a DataType of Integer.

You need to develop an enhancement for a regional customer that will be reused for several
future enhancements. Which menu ID and level should you use to meet the requirements?


Options are :

  • 1020, Dept - Region
  • 1030, Dept - Country
  • 1080, Dept - Partner
  • 1090, Dept - Company

Answer : 1080, Dept - Partner

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

Which three actions can be found on master pages? (Each correct answer presents a complete
solution. Choose three.)
A. Release open documents
B. Access navigation
C. Access statistics
D. Create new documents
E. Reverse ledger entries
F. Access ledger entries


Options are :

  • ACE
  • ABC
  • BCD
  • CDE
  • DEF

Answer : ACE

Which two items are prerequisites to integrate a ledger entry table with the Navigate feature?
(Each correct answer presents part of the solution. Choose two.)
A. A LookupPageID set to the appropriate page
B. A FindRecords function containing appropriate code
C. A DrillDownPageID set to the appropriate page
D. A secondary key containing Document No. and Posting Date fields


Options are :

  • BD
  • AB
  • BC
  • CD

Answer : BD

You need to create a Role Center page containing a stack of documents. How should you create
the activities page?


Options are :

  • Create a CardPart with a number of FlowFields that contains filtering of the documents as stacks in a cue group.
  • Create a ListPart with a number of FlowFields that contains filtering of the documents as stacks in a cue group.
  • Create a table of FlowFields that contains the documents as stacks. Then create a ListPart with a cue group.
  • Create a table of FlowFields that contains the documents as stacks. Then create a CardPage with a cue group.

Answer : Create a table of FlowFields that contains the documents as stacks. Then create a CardPage with a cue group.

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

When does the OnInsert trigger run on a table?


Options are :

  • The trigger code is run before the record is inserted into the database.
  • The trigger code is run after the record is inserted into the database.
  • The trigger code is run after the user enters data in every field.
  • The trigger code is run before the user enters data in every field.

Answer : The trigger code is run before the record is inserted into the database.

After a new master record is inserted, you notice that many of the fields are populated from other
tables. From which tables are the fields populated?


Options are :

  • A combination of setup tables and subsidiary tables
  • Subsidiary tables
  • Supplemental tables
  • A combination of subsidiary and register tables

Answer : Supplemental tables

Which three table types belong to the group of configuration tables? (Each correct answer
presents a complete solution. (Choose three)
A. Subsidiary
B. Setup
C. Register
D. Document
E. Ledger
F. Master


Options are :

  • CEF
  • ABC
  • BCD
  • CDE
  • DEF

Answer : CEF

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

Which two tables are considered master tables? (Each correct answer presents part of the
solution.
Choose two.)
A. Purchase Journal
B. Currency
C. Resource
D. Item
E. Sales Setup


Options are :

  • AE
  • AB
  • BC
  • CD
  • DE

Answer : AE

Which three object types can be created as a Web service? (Each correct answer presents part
of solution. Choose three)
A. Table
B. Page
C. XMLport
D. Report
E. Query
F. Codeunit


Options are :

  • BDE
  • ABC
  • BCD
  • DEF
  • CDE

Answer : BDE

When published, which page and table triggers can be run by a user who accesses Microsoft
Dynamics NAV from a web service?


Options are :

  • All the page and table triggers
  • Triggers cannot be performed
  • Only the OnModifyRecord trigger on pages
  • Only the OnModify trigger on tables

Answer : All the page and table triggers

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

You must design an interface that sends email messages automatically during the night. The
design needs to minimize future development and maintenance. Which elements should you
include in your design?


Options are :

  • Microsoft Outlook automation library
  • codeunit 397, Mail
  • Microsoft.Dynamics.Nav.SMTP .NET
  • codeunit 400, SMTP Mail

Answer : codeunit 400, SMTP Mail

You need to ensure that code is not run when a process runs from a Web service environment.
Which C/AL command should you use?


Options are :

  • SHELL
  • ISNULLGUID
  • GUIALLOWED
  • ISSERVICETIER

Answer : GUIALLOWED

You need to create an extension codeunit. What does an extension codeunit consist of and how
do you use it? (Each correct answer presents a part of the solution. Choose two.)
A. It is used as a part of a web service and must not be published.
B. It is used with a page.
C. It is used as a part of a web service and must be published.
D. It is used with a report.
E. It is used with a query.


Options are :

  • CD
  • AB
  • BC
  • DE

Answer : CD

Microsoft 70-642 Windows Server Network Infrastructure Exam Set 8

You need to create a visual interface with Microsoft Dynamics NAV that is embedded on a page.
Which interface technology should you use?


Options are :

  • OCX
  • Web services
  • Automation controller
  • Control add-in

Answer : Control add-in

70-642 Windows Server 2008 Network Infrastructure Exam Set 1

Which three object types can be created as web service? (Each correct answer presents part of
the solution. Choose two)
A. Page
B. Query
C. Table
D. Report
E. Codeunit
F. XMLport


Options are :

  • BDE
  • ABC
  • BCD
  • CDE
  • DEF

Answer : BDE

What purpose does the code in the OnDelete trigger of a standard master table and a standard
supplemental table have in common?


Options are :

  • To update the Last Date Modified field of the master/supplemental record that is being deleted
  • To delete all subsidiary information that is linked to the master/supplemental record that is being deleted
  • To delete all line records that are linked to the master/supplemental record that is being deleted
  • To block deletion of the master/supplemental record when there are uncompleted transactions related to the record

Answer : To update the Last Date Modified field of the master/supplemental record that is being deleted

You create a new table with information about DVDs. It is the master table of a Loan add-on.
Which name should you give to the table that contains data about the DVDs?


Options are :

  • DVD
  • DVDs
  • DVD Page
  • DVD List

Answer : DVD

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

Which statement accurately describes the journal posting routine?


Options are :

  • Single codeunit scanning a single set of journal tables, always creating records in a single ledger entry table
  • A single codeunit scanning many journal tables, creating records in a single ledger entry table
  • A group of codeunits scanning a single set of journal tables, always creating records in a single ledger entry table
  • A group of codeunits scanning a single set of journal tables, creating records in many ledger entry tables

Answer : A group of codeunits scanning a single set of journal tables, creating records in many ledger entry tables

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions