Microsoft Azure Developer Certification Transition beta

Members of the finance department for a company review and make changes to a Microsoft Excel workbook that is hosted on OneDrive. The workbook contains projected costs and revenue for a project. You need to develop an Azure Function that ingests data from the modified workbook and places it into a Microsoft Word document. Which two objects should you implement? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A company uses Azure SQL Database to store data for an app. The data includes sensitive information. You need to implement measures that allow only members of the managers group to see sensitive information. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You develop a solution that uses an Azure SQL Database to store user information for a mobile app. The app stores sensitive information about users. You need to hide sensitive information from developers that query the data for the mobile app. Which three items must you identify when configuring dynamic data masking? Each correct answer presents a part of the solution. NOTE: Each correct selection is worth one point.

You need to troubleshoot the order workflow. What should you do? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You are developing a software solution for an autonomous transportation system. The solution uses large data sets and Azure Batch processing to simulate navigation sets for entire fleets of vehicles.
You need to create compute nodes for the solution on Azure Batch.
What should you do?

You maintain an Azure Web App that runs in a container. The container is using a DockerFile that is copied to numerous places and consumes a large amount of storage.
You need to optimize the Dockerfile.
What should you do?

You host an on-premises ASP.NET Web API at the company headquarters. The Web API is consumed by applications running at the company's branch offices using the Azure Relay service. All the users of the applications are on the same Azure Active Directory (Azure AD).
You need to ensure that the applications can consume the Web API.
What should you do?

You have implemented code that uses elastic transactions spanning across three different Azure SQL Database logical servers.
Database administration report that some transactions take longer to complete than expected.
You need to use the correct tool to monitor all the transactions originating from the elastic transaction implementation.
Which tool should you use?

A company is migrating an existing on-premises third-party website to Azure. The website is stateless.
The company does not have access to the source code for the website. They do have the original installer.
The number of visitors at the website varies throughout the year. The on-premises infrastructure was resized to accommodate peaks but the extra capacity was not used.
You need to implement a virtual machine scale set instance.
What should you do?

You are developing an Azure Batch solution to perform CPU intensive calculations. The calculations occur at a specific time each week and last for approximately one hour.
Before any changes are made, a timer must be created to measure the initial duration. The timer must start before the first calculation is queued to run on the computer node.
You need to implement the timer.
Before which line should the timer be created?