This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
You need to update the unit price of multiple sales orders. What method would be best to use?
Update()
doUpdate()
update_recordSet
insert_recordSet
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
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
What is the best method to link data between two table instances of a ´TempDB´ table?
Use the setTempData method.
setTempData
Use a while select method and copy data records individually to the other table instance.
while select
Use the linkPhysicalTableInstance method.
linkPhysicalTableInstance
You must answer all questions before checking your work.
Continue
Was this page helpful?