MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer
A new developer is joining the project team. You, as the project manager, must request a new environment for the developer to use. What kind of environment should you request? -A Tier 1 environment -A Tier 2 environment -A production environment
A Tier 1 environment -Tier 1 environments are for development.
What type of class supports constructing the business event, building the payload, and sending the business event? -A business events contract class -An event handler class -An event class -A business event class
A business event class -A business event class extends the BusinessEventsBase class and supports constructing the business event, building the payload, and sending the business event.
A base enumeration can be viewed in multiple ways in the user interface of finance and operations apps. Which of the following is not an example of how a base enum can be viewed in the user interface? -Option buttons -A slider bar -A date field -A drop-down menu
A date field -A date field is an EDT, not a base enum, that is used in the user interface.
What method is automatically added when you're creating a runnable class instead of a class? -A new method -A static method -A main method -A finalize method
A main method -A main method is automatically added to a runnable class. Therefore, you would add a runnable class instead of a class to your project.
How are base enums represented and stored in the database? -A literal string value -A numerical value -An alphabetical character -A series of numerical and alphabetical characters
A numerical value -Base enums are stored as numeric values (for example, 0, 1, 2) in the database.
Which method will allow the method to be called from anywhere that its class is accessible? -A public method -A private method -An access method -A protected method
A public method -Methods that are declared as public can be called from anywhere that the class is accessible.
You are working on a project that has undefined requirements and new requirements are expected to occur during the project. What methodology would best suit this type of project? -Waterfall -Agile -Spiral
Agile -Agile is useful when requirements are undefined and additional requirements are expected throughout the project life cycle.
What are the benefits of using a workspace? Users can create and edit workspaces through the user interface without the need of a developer. -Workspaces can be personalized and shared across users. -You can embed Power BI reports to generate data visualizations. -Workspaces let users work from one location to view required data in one location. -All of the above
All of the above -All of the above statements are benefits of a workspace.
What data source types can you use when creating a report? -Query -Business logic -RDP class -AX enum provider -All the above
All the above -Query, business logic, RDP class, and AX enum provider are the data source types that you can select.
You are implementing finance and operations apps and need to grant and deny user access to certain data and menu items. What tools are available that will allow you to do this? -Role-based security -Extensible data security framework -Table permissions framework -All the above
All the above -Role-based security, extensible data security framework, and table permissions framework are tools that allow you to grant and deny user access to certain data.
What types of reporting are available for finance and operations apps? -SQL Server Reporting Services -Power BI -Financial Reports -All the above
All the above All answers are correct. finance and operations apps reporting includes SSRS reporting, Power BI reports, and Financial Reports by using the Financial Report Designer.
An index is an important element that is added to a table. Which of the following statements is true regarding indices? -The order of columns in an index is not important. -A primary index should have the "Allow Duplicates" property set to "Yes." -A non-clustered index organizes data in a table according to the order of the index. -An index is used to improve the speed of data retrieval.
An index is used to improve the speed of data retrieval. -The main purpose of an index is to increase the speed of retrieving data.
You need to create a report that a power user can create to explore data. The creation of the report should only take a few minutes and needs to allow the user to create charts and dashboards. This report does not need to be printed, sent by email, or exported to a file. What reporting tool should you use? -Operational views -Business documents -Analytical tools and visualizations -Financial reporting
Analytical tools and visualizations -Analytical tools and visualizations are user-created and allow quick exploration of data.
When deploying a cloud-based solution of finance and operations apps, which source control process is available? -Azure DevOps Services -Azure DevOps Server -Visual Studio Team Foundation Server
Azure DevOps Services -Azure DevOps Services is the cloud-based offering for source control.
Which of the following options enables the exchange of documents or files between finance and operations apps and any external application or service? -Excel integration -Custom service -Batch data API
Batch data API -Batch data API with recurring integration enables the exchange of documents or files between finance and operations apps and any third-party application or service.
Which of the following types of integrations should you select when you need to asynchronously import data to finance and operations apps from a third-party system on an hourly basis? -OData integration -Batch data integration -Custom service integration
Batch data integration -You should select a batch data integration for asynchronous scenarios like this for batch-run integrations.
Creating extensions is the method used to make customizations in finance and operations apps. Which of the following is a benefit of using extensions instead of overlaying? -Extensions take less time to create. -Build times are reduced with extensions. -Updates are rolled out less frequently by using extensions. -Extensions cost more to maintain than overlaying.
Build times are reduced with extensions. -Build and compile times are reduced with extensions because you don't have to compile the model that is being extended.
You need to create an extension of the FMCustomer form. Which of the following tasks cannot be accomplished after you have created the form extension? -Change the form pattern from Details Master to Table of Contents. -Add another data source to the form. -Add an Action Pane Tab to the Action Pane control. -Select and drag a field from the Fields node of a data source to a Grid control.
Change the form pattern from Details Master to Table of Contents. -You cannot change the pattern of an existing form. If you need a different form pattern, you should create a new form.
You want to create an extension from an element in the AOT. What must you verify to create this extension? -Ensure that the Sync database on build property is set to True. -Check that you're referencing the model that houses the element that you want to extend. -Verify that the AOT is set to Model view instead of Classic view.
Check that you're referencing the model that houses the element that you want to extend. -To create an extension of an element, you must verify that you're referencing the model in which the element resides.
Suppose you have just used Get Latest Version to bring updated files from source control into Visual Studio, and you suspect that local changes you wanted to keep were removed during an auto-merge. Which of the following can you do to troubleshoot the issue? -Roll back the changesets that you pulled from source control. -Go to Pending Changes in Team Explorer for a list of differences between your workspace and source control. -Use the Undo button to restore the changes that you wanted to keep. -Check the Output window in Visual Studio for logs of which files were auto-merged.
Check the Output window in Visual Studio for logs of which files were auto-merged. -The Output window logs which files are affected by auto-merging, so you can use it to help determine if an auto-merge overwrote your local changes.
You need to see an individual user's activity on a specific environment. How would you accomplish this task? -Check the activity monitor in Lifecycle Services. -Use Visual Studio to run diagnostics. -Check the Full details page for an environment in Lifecycle Services. -View the System administration module in finance and operations apps.
Check the activity monitor in Lifecycle Services. -To see an individual user's activity for a specific environment, check the activity monitor in Lifecycle Services.
The Excel add-in for finance and operations apps lets you manipulate data in a data entity. Which task cannot be accomplished by using the Excel add-in? -Add a new record to your data entity. -Delete a record from your data entity. -Publish modified data back to finance and operations apps. -Create a new data entity.
Create a new data entity. -You cannot create a new data entity in the Excel add-in. That is done in Visual Studio.
Which of the following source control features is not accessible from Visual Studio? -Checking in your pending changes. -Submitting and responding to code review requests. -Rolling back changesets from source control. -Creating a new Azure DevOps project.
Creating a new Azure DevOps project. -You can connect to a new project from Visual Studio, but you must go to Azure DevOps to create one.
An energy company has field workers who schedule installation jobs for heaters. This company uses finance and operations apps for the back office and other software as a service (SaaS) to schedule appointments. When field workers schedule appointments, they must look up inventory availability to make sure that installation parts are available for the job. The real-time data is required. Peak data volume is 1,000 records per hour and the frequency is Ad hoc. Which one of the following integration patterns should you use? -External web services -Excel integration -Custom service
Custom service -In finance and operations apps, request that a developer create a custom service to calculate the physical on-hand inventory for a given item. In the scheduling application, make a real-time call to a custom service endpoint, through either SOAP or REST, to retrieve inventory information for the selected item.
Where can you enable change tracking for entities? -Visual Studio -Data entity parameters on the AOT object -Data management workspace -System administration module
Data management workspace -Change tracking is enabled by using the Data management workspace in finance and operations apps.
Where can you create a data export for a custom data source? -Visual Studio -Data management workspace -SQL Server Management Studio -System administration module
Data management workspace -You can create data export projects in the Data management workspace in finance and operations apps.
You have extended a table to add fields in Visual studio, you have performed a build, but you are not seeing the new fields you have added to the table. Which of the following actions should you perform to ensure your table extension updates, and displays on the table? -Debug the table code -Database synchronization -Run a code analysis on the solution -Create a deployable package
Database synchronization -If your table isn't syncing, you should perform a database synchronization.
We recommend that you use EDTs whenever possible in coding for finance and operations apps. Which of these statements is not a benefit of using EDTs? -EDTs are more easily compiled. -EDTs are reusable throughout the system. -The code is easy to read. -Properties can be inherited from parent EDTs.
EDTs are more easily compiled. -EDTs are compiled in the same way as any primitive data type.
Which of the following statements is true regarding extending enums in Visual Studio? -Enums, where the IsExtensible property is set to True, can be extended. -Any enum in Visual Studio can be extended. -Only enums that are contained in the Application Suite model can be extended. -Enums, where the IsExtensible property is set to False, can be extended.
Enums, where the IsExtensible property is set to True, can be extended. -The IsExtensible property of the enum must be set to True to be able to create an extension.
You need to change how the VendorInvoiceLineEntity functions. Which of the following actions should you take to start? -Create a new entity and copy all the properties from VendorInvoiceLineEntity. -Extend VendorInvoiceLineEntity. -Overlayer your changes on the existing VendorInvoiceLineEntity. -Edit VendorInvoiceLineEntity directly.
Extend VendorInvoiceLineEntity. -Most elements can be modified by extension.
What components come included with the Data Integrator templates? -Field mappings -Data management workspace -X++ code -SDK
Field mappings -Field mappings come with the out-of-the-box Data Integrator templates. Predefined entities come out of the box as well.
To retain a history of errors and remove a specific business event from a process, what status should the business event be changed to? -Inactive -Active -Delete
Inactive - The Inactive status means that the history of errors are retained along with the possibility of reactivation in the future as business requirements may change.
Why would a KPI need to be used by a business? -KPIs send alerts to users in their workspaces when a certain action occurs. -KPIs give users a task list that must be completed. -KPIs can be used to find errors in the system. -KPIs can be used to measure performance.
KPIs can be used to measure performance. -KPIs are measurable values that are used to measure performance.
What is a guiding principle in creating a branching structure for your implementation? -Make it complicated -Always keep it the same -Keep it simple
Keep it simple -Keep the branching structure simple without over complicating it, making sure your strategy is easy to navigate and will produce the correct code flow for your implementation.
With which of the following are you not required to register a service to connect it to finance and operations apps? -Azure Active Directory -finance and operations apps -Lifecycle Services
Lifecycle Services -Lifecycle Services does not dictate whether a service can communicate with finance and operations apps.
Which of the following actions isn't a best practice to consider when coding? -Comment code to communicate with other developers -Use a naming standard for an organization -Limit code comments to shorten text strings -Each element should have a label assigned in the Properties window
Limit code comments to shorten text strings -Limiting code comments to shorten text strings isn't a best practice because comments should be used liberally.
You are setting up Visual Studio to connect to Azure DevOps on a machine that hosts a finance and operations apps environment. Which of the following should you do? -Set the permissions of the workspace to Public Workspace (limited). -Map the folder for the branch in source control to the local Visual Studio documents Projects folder. -Map the Metadata folder for the branch in source control to the Packages Local Directory folder of the AOS drive. -Set the location of the workspace to Server.
Map the Metadata folder for the branch in source control to the Packages Local Directory folder of the AOS drive. -Mapping Metadata to the Packages Local Directory folder lets the locally hosted finance and operations apps environment run code that is built locally in Visual Studio.
To use OAuth 2.0 with finance and operations apps, you must first register the application. Where can you do this? -System administration module -Microsoft 365 Admin help center -Microsoft Azure portal -Power Apps portal
Microsoft Azure portal -To register finance and operations apps to use OAuth, register in the Microsoft Azure portal.
Which one of the following is used to enable the flow of data between finance and operations apps and other Dynamics 365 applications? -Power Automate -Microsoft Dataverse -Data entities -Data management workspace
Microsoft Dataverse -Dataverse is used to enable flow of data between Dynamics 365 applications.
Which feature of Lifecycle Services can be used to export a backup of a database to the Asset library for environments that are Tier 2 or above? -Move database -Apply updates -Reporting server -Environment changes
Move database -In a Tier 2 environment or above, under the Maintain menu there is the option to Move database, which can allow you to export the backup to the asset library.
When developing a new form for finance and operations apps, is it true that applying a form pattern is a mandatory step? -Yes -No
No -Applying a form pattern is highly recommended and considered best practice when you are developing a new form, but it is not mandatory.
Is it true that importing APIs is not supported for on-premises deployments? -Yes -No
No -Importing APIs is supported for on-premises deployments.
Is it true that most data entities will include just one table? -Yes -No
No -Most data entities should contain multiple related tables to represent the object. However, there might be cases where a single table is used.
You are writing a query to retrieve the customers that are not associated with a sales order. What join between the Customer table and the Sales table should you use? -Join -Outer join -Exists join -NotExists join
NotExists join -A notExists join would return customer data for customers who are not associated with a sales order.
Which of the following options enables broad integration between finance and operations apps and other products, systems, and applications? -Excel integration -Custom service -OData
OData -One of the benefits of OData is that it enables broad integration across products.
The Excel Data Connector app interacts with Microsoft Excel workbooks through which one of the following? -External web services -Custom service -OData
OData -The Excel Data Connector app interacts with Excel workbooks and OData services that are created for publicly exposed data entities.
What does the function Open in Excel do that Export to Excel does not? -There is no difference. -Open in Excel uses data entities that let you publish changes to the data back to finance and operations. -Open in Excel uses the grid data. -You can't filter data through Open in Excel, but you can with Export to Excel
Open in Excel uses data entities that let you publish changes to the data back to finance and operations. -Export to Excel uses the grid data and does not give you the option to publish data back to finance and operations.
You want to attach a report to a menu item so the report will display when a user selects the menu item. Which type of menu item should be used to perform the task? -Display menu item -Output menu item -Action menu item -Window menu item
Output menu item -An output menu item is used for showing and printing a result or report, such as an SSRS report.
Which of the following is not a function of the Task recorder? -Create task guides of a process that users can follow. -Generate unit tests in Visual Studio. -Periodically run to automatically complete a task. -Create on-rails playback that limits users to only be able to select elements within the task recording.
Periodically run to automatically complete a task. -The Task recorder does not automatically complete tasks.
Which of the following does not have a direct connector to finance and operations apps? -Power Automate -Azure Logic Apps -Power BI -Power Apps
Power BI -To connect to finance and operations apps from Power BI, use an OData connector.
Which one of the following is not a relevant business concept to consider before and during an implementation of finance and operations apps? -Number of users -Number of transactions per month -Seasonality -Printing checks
Printing checks -Printing checks is a detail of the implementation, but it is not a business concept to be considered that would change anything large about an implementation.
What methods can you extend to use Chain of Command? -Methods declared with the keyword final -Private methods -Protected and public methods -Methods tagged with the attribute hookable(false)
Protected and public methods -Protected and public methods can use Chain of Command.
You need to enable an exchange of documents between finance and operations apps and an external application at the end of each day. Which of the following would you implement? -Excel data connector app -Recurring integration -Synchronous integration
Recurring integration -You would set up a recurring integration for this scenario.
Which type of integration API supports both file and data package formats? -Data management framework -OData -Recurring integrations
Recurring integrations -Recurring integrations support both files and data packages.
A report is taking a long time to run. When looking at the query, you notice that several fields are not being used in the report. To optimize this report, how should these unused fields be handled to increase performance? -Remove the unused fields from the report. -Keep the unused fields. -Use a data slicer to filter the data. -Delete the unused fields from the table.
Remove the unused fields from the report. -Removing any unused fields from the report can help the performance of the report.
Which of the following processes cannot be performed from Lifecycle Services? -Deploy a new environment -Update the code on an existing environment -Restore an image of an environment. -Upgrade an environment to a new platform version.
Restore an image of an environment. -You cannot restore an image of an environment in Lifecycle Services.
You are running the debugger. The breakpoint comes to a line saying custTable.insert(). How can you descend into the Insert method? -Select the Step Into button. -Select the Step Over button. -Select the Step Out button.
Select the Step Into button. -The Step Into button will go into the Insert method to continue debugging.
When all requirements for a form pattern have been satisfied, what must be done before you can build and preview the form in a browser window? -Run the forms pattern report. -Check the form statistics add-in. -Set the form that you want to preview as the startup object for the project. -Perform a rebuild of the form.
Set the form that you want to preview as the startup object for the project. -You must first set the form you want to preview as the startup object for the project by right clicking the form in the Solution Explorer window and selecting that option.
To manage the Asset libraries, there are different file types that serve various functions. Which asset type contains multiple models in a prepackaged extension file that can be used to deploy code and application changes to an environment? -Database backup -Software deployable package -BPM artifact -Solution
Solution -A solution contains multiple models in a prepackaged extension file that can be used to deploy code and application changes to an environment.
Which of the following does a deployable package not contain? -Source code -Metadata -Binaries -Application models
Source code -Deployable packages do not include source code. They include metadata, binaries, and models
Which of the following is not a response message that you can receive when using GetExecutionSummaryStatus for monitoring the status of an API? -NotRun -Failed -Canceled -Starting
Starting -Starting is not a status that can be returned when you are using GetExecutionSummaryStatus.
You need a conditional statement that checks if a variable equals "In progress," "Completed," or "Canceled." Different code needs to run, depending on what the variable equals. A default block of code needs to run if the variable does not equal any of the values. What conditional statement is most appropriate? -Error handling -A ternary operation -If statement -Switch statement
Switch statement -The switch statement allows you to use cases. If the case matches the value of the switch expression, then a specific code block can run. A default case can also be used when no other cases match.
Which part of the user interface is used to create business process diagrams? -Navigation Pane -Business Process Modeler -Task Recorder -User Options
Task Recorder -The Task Recorder is used to create task recordings that generate the business process documentation.
Which of the following features is used with the Regression Suite Automation (RSAT) Tool? -Task recorder -Data migration framework -Software deployable packages
Task recorder -You can use Task recorder, that records to the Business process modeler (BPM), to create user acceptance test libraries.
You want to better track your organization's data validation processes for an upgrade of finance and operations apps. Which tool will best suit your needs? -JSON web tokens -Embedded Power Apps -The Data validation checklist workspace
The Data validation checklist workspace -The Data validation checklist workspace is used to track data validation processes during a new implementation, after an upgrade, or after a migration.
A child table inherits properties from a parent table. Which two properties work together to control table inheritance? -The Support Inheritance and Table Type properties -The Table Type and Extends properties -The Extends and Supports Inheritance properties -The Allow Inheritance and Extends properties
The Extends and Supports Inheritance properties -The Supports Inheritance property can be selected as "Yes" or "No" to determine if a table supports inheritance. The Extends property is used to determine which table will be inherited from or extended.
You need to create and assign a data type to a variable. The variable should only have access to a defined list of values "Invent," "Sale," and "Purchase." Which data type should you use? -The string data type should be used. -The enum data type should be used. -The integer data type should be used. -The container composite data type should be used.
The enum data type should be used. -The enum type allows you to use a defined list of values.
An error is sometimes thrown in a certain try...catch block. You know that the issue can be fixed within the code during the error handling code block. What statement could you use when the error is found to run the code again? -The throw statement should be used in the catch statement to rerun the try block. -The finally statement should be used in the catch statement to rerun the try block. -The retry statement could be used in the catch statement to rerun the try block. -A business system function should be used in the catch statement to rerun the try block.
The retry statement could be used in the catch statement to rerun the try block. -The retry statement will rerun the try block to give the code another opportunity to succeed.
You want to add an element to your workspace to quickly see sales orders that have been marked as Pending confirmation. Normally, you filter the Sales order list page to find if you have any orders that are waiting for confirmation. What workspace element would help you quickly identify the pending confirmation orders that you must process? -Power BI line chart -Power BI pie chart -Link -Tile
Tile -A tile would give you a record count of all the orders that are pending confirmation. You can then select the tile to take you to a filtered view of the pending confirmation orders.
You need to run a process in parallel. There are around 1,000 work items that would need to run with a bundle size of 100. You know that the run time for each work item will vary. What approach should you take to run this process? -Individual task modeling -Batch bundling -Top picking
Top picking -The top picking approach handles multiple records and handles uneven workloads well.
What is the performance tool that can consume traces and analyze performance? -Performance SDK -Health monitor -SQL Insights -Trace parser
Trace parser -Trace parser is a performance tool that consumes traces and analyzes environment performance.
Which of the following cannot be automated by using Logic Apps? -Send email notifications with Microsoft 365 when events happen in various systems, apps, and services. -Move uploaded files from an SFTP or FTP server to Azure Storage. -Monitor tweets for a specific subject, analyze the sentiment, and create alerts or tasks for items that need review. -Update tables in Power BI when data changes in finance and operations apps.
Update tables in Power BI when data changes in finance and operations apps. -A connected Power BI table will already be updated without the help of Logic Apps.
You are a developer for Contoso Electronics and need to create a Power App app that will use data within the CustTable. You have defined the instance, and now you need to specify the table that you will be using for the data source within the app. When you try to find the CustTable, you are unable to find it in the Choose a table list in Power Apps. What can you check to diagnose why the table is not displaying? -Ensure that the data entity is enabled in the Data management workspace. -Verify that the IsPublic property on the data entity is set to No. -Verify that the IsPublic property on the data entity is set to Yes.
Verify that the IsPublic property on the data entity is set to Yes. -You need to verify that the data entity is public; if it is not public, you will not be able to access it outside of finance and operations apps.
When does your code become available locally in finance and operations apps? -When you save it -When you shelve your changes -When you check in your changes to source control. -When you build it.
When you build it. -Building is what creates the metadata to reflect your code, and the metadata is what finance and operations apps uses to define its behaviors.
Which of the following business actions is a finance and operations user able to perform for their organization to handle daily tasks? -Inactive or active business events -External system tasks -Workflow or non-workflow actions
Workflow or non-workflow actions - Business events can be either workflow or non-workflow actions and can be set to an Active status for them to be used as a part of a business requirement.
Is it true that both recurring integrations and the data management framework support REST protocols? -Yes -No
Yes -Both recurring integrations and the data management framework support REST protocols.
Is it correct that if a modification is made to a field group, such as the addition of a new field, any forms that contain that field group will automatically update to reflect that addition. -Yes -No
Yes -Field groups store logical groupings of fields, such as different fields relating to an address. If fields are added to a field group, and that field group is used on a form, the form will automatically update to reflect the new fields that were added to the field group on the table.
Is it true that some diagnostics from Health metrics in Lifecycle Services are sent directly to the Microsoft Service Engineering team? -Yes -No
Yes -Some diagnostics are sent directly to Microsoft from the Health metrics interface in Lifecycle Services to be reviewed by the engineering team.
Which of the following statements is NOT true about variable declarations? -You can use var to declare local variables for declarations of for loop counters -You can declare a variable wherever statements can be provided. -You can declare a variable after the variable is used. -You can declare variables in smaller scopes, outside which the variables can't be referenced.
You can declare a variable after the variable is used. -This statement is NOT true. You cannot declare a variable after it is used in code.
What are some reasons to deploy a report from the PowerShell? -You can deploy all the reports at once, and you can deploy reports in environments that are not Production and do not have Visual Studio. -There is no reason to deploy reports from PowerShell. They should always be deployed from Visual Studio. -PowerShell can be used to deploy reports in the Production environment. -If you want to deploy reports to finance and operations apps, you must use PowerShell.
You can deploy all the reports at once, and you can deploy reports in environments that are not Production and do not have Visual Studio. -These are reasons you might need to use the PowerShell command to deploy a report.
Which of the following statements is true regarding table extensions? -The Properties window is used to edit any property for a table. -While a new field can be added to a table extension, it is not possible to create a new index. -You can use an event handler to add business logic to a table. -Table extensions are used when the desired behavior of the element cannot be achieved through overlaying.
You can use an event handler to add business logic to a table. -Event handlers are added to a table by using extensions. You can create a new class that extends the desired table and enables access to its fields and methods.
Which of the following statements is true about configuring dual-write in finance and operations apps? -Dual-write is configured in the Feature management workspace. -You must be an administrator of the Microsoft Dataverse environment to create the link between the applications. -The link between finance and operations apps and the model-driven app is made in Microsoft Azure. -The link between finance and operations apps and the model-driven app is made in Microsoft Dynamics Lifecycle Services.
You must be an administrator of the Microsoft Dataverse environment to create the link between the applications. -When creating the link between the two applications, you will only see Dataverse environments you are an administrator in.
You notice some performance issues where certain tasks are taking longer than they should. While investigating the performance issue, you find that there is a While select statement on a form that can be optimized. You suspect there might be other While select statements on forms that could be optimized as well. How can you use the metadata search to find the forms with While select statements? -code:"while" -code:"while" type:form,method -type:form,method while -name:while
code:"while" type:form,method -code:"while" type:form,method will return form methods that use While select in the code.
You need to update the unit price of multiple sales orders. What method would be best to use? -Update() -doUpdate() -update_recordSet -insert_recordSet
update_recordSet -The update_recordSet method updates multiple records with one call to the database and is the best method to use.
You want to update a record in your SampleTable table that contains the account number 1234 by using the update method. Before you call the update method, which clause is used at the beginning of this statement to locate the record sampleTable.AccountNum == "1234"? -where sampleTable.AccountNum == "1234" -locate sampleTable.AccountNum == "1234" -join sampleTable.AccountNum == "1234" -forUpdate sampleTable.AccountNum == "1234"
where sampleTable.AccountNum == "1234" -A where clause is used to specify a condition that the update method will test as it processes each row of the SampleTable table.
