A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table. The transaction ID includes the store number. You need to show the store name for all retail transactions in all Power BI reports. Which tool should you use?

You test a business process flow in a sandbox environment. When you complete testing, you must copy the business process flow to a production environment without bringing any data or other modifications with it. You must meet the requirements. What should you do? 

You create a canvas app that uses a Microsoft Excel spreadsheet as a data source. The spreadsheet contains a list of pets. Each column in the spreadsheet is a different attribute about a pet. You need to create an interface to allow users to save a new pet record to the spreadsheet. What is the minimum number of controls you need to implement to create the interface?

A company is creating a canvas app to display data from a legacy system that is located on the company’s internal network. You need to connect to the data. What should you use? 

You are creating a Power Automate flow. The flow must read each item in a Microsoft SharePoint list that details sales opportunities and set the value for a field named Status to Overdue if the value of a field named Follow up is less than or equal to the current date. You need to select the appropriate component to cycle through the entire list. Which component should you use?