Practice Test
True or False: You can implement both common data service and SharePoint as data objects in cloud flows
- True
- False
Answer: True
Explanation: In cloud flows, both Common Data Service and SharePoint can be used as data objects. This gives users the flexibility to work with different data storage environments.
What are the necessary requirements for implementing data objects in cloud flows?
- a) Proper sign-in Authority
- b) Correct data service
- c) Adequate permissions
- d) All of the Above
Answer: d) All of the above
Explanation: To Implement data objects in cloud flows, you need a correct sign-in authority, appropriate data service, and the necessary permissions.
True or False: Only SQL Server is used to handle data objects in Microsoft Power Automate.
- True
- False
Answer: False
Explanation: Microsoft Power Automate supports the use of multiple data services, including SQL Server, SharePoint, and Common Data Service.
Which of the following connectors simplify working with data in Power Automate?
- a) SharePoint
- b) Common Data Service
- c) SQL Server
- d) Excel Online
- e) All of the above
Answer: e) All of the above
Explanation: All the mentioned connectors are available in Power Automate and can be used to simplify working with data.
True or False: You may use the ‘Excel Online Business’ connector to work with data objects in an Excel spreadsheet hosted in the cloud.
- True
- False
Answer: True
Explanation: The ‘Excel Online Business’ connector allows you to work with data objects in an Excel spreadsheet stored in the cloud, such as in OneDrive or SharePoint.
Which data connector is intended for use with business accounts?
- a) Excel Online (Business)
- b) Excel Online (Home)
- c) Excel Online (Individual)
- d) None of the above
Answer: a) Excel Online (Business)
Explanation: Excel Online (Business) is the data connector designed for use with business accounts in Power Automate.
Multiple selection: Which amongst the following can be used as data sources in the Power Automate?
- a) Common Data Service
- b) SharePoint
- c) Google Sheets
- d) SQL Server
Answer: a) Common Data Service, b) SharePoint, d) SQL Server
Explanation: Google Sheets is not supported as a data source in Power Automate.
True or False: You can use the Dataverse to store and manage data in Power Automate.
- True
- False
Answer: True
Explanation: In Power Automate, the Dataverse provides secure and scalable storage for data.
Single selection: ________________ may be used in Power Automate with the help of Advanced Find.
- a) SharePoint Lists
- b) Dataverse Records
- c) Google Sheets
- d) Outlook Mail
Answer: b) Dataverse Records
Explanation: Using Advanced Find, Dataverse Records can be located and used in Power Automate.
True or False: Without proper permissions, data objects cannot be manipulated in Power Automate Cloud flows.
- True
- False
Answer: True
Explanation: It is imperative to have the necessary permissions to be able to manipulate data objects within Cloud flows in Power Automate.
Single selection: In Power Automate, data from common data service can be extracted by using ________?
- a) Advanced Find
- b) Fetch XML
- c) SQL Server
- d) JSON
Answer: b) Fetch XML
Explanation: Fetch XML is used in Power Automate to extract data from the Common Data Service.
True or False: Users can manipulate data objects in Cloud flows using the REST API.
- True
- False
Answer: True
Explanation: Users can leverage REST API to manipulate data objects within Cloud flows, allowing to interact with data in more complex and flexible ways.
Multiple selection: Which of these objects can be used in a Cloud Flow?
- a) List records
- b) Create a new record
- c) Update a record
- d) Delete a record
Answer: a) List records, b) Create a new record, c) Update a record, d) Delete a record
Explanation: All these operations are possible when you are working with objects in Cloud Flow.
True or False: You can use the Get Items action to retrieve items from SharePoint lists.
- True
- False
Answer: True
Explanation: Get Items action is a SharePoint connector action that’s used in Power Automate for retrieving items from SharePoint lists.
Single selection: ____________ defines the structure of an entity in terms of fields and field types.
- a) Data object
- b) Access object
- c) Data model
- d) Data source
Answer: c) Data model
Explanation: A data model defines the structure of an entity (like a table, a view, or even a stored procedure) in terms of fields and field types.
Interview Questions
What are cloud flows in Power Automate?
In Power Automate, cloud flows are used to create automated workflows between your favorite apps and services to get notifications, synchronize files, collect data, and more.
How do data objects work in cloud flows?
Data objects in cloud flows are used to carry data from one action to another in the same cloud flow.
Can you provide an example of implementing a data object?
A simple implementation is to initialize a variable at the beginning of the workflow and then use it in subsequent actions. For example, you can start by initializing a string variable and then use it in an email action to hold the email body.
Can you modify a data object during workflow execution?
Yes, you can modify a data object during the execution of the workflow, using the ‘Set variable’ action, for instance.
How do you use a data object in multiple actions within a flow?
After initializing a data object, it can be used across the entire workflow just by using its name. For example, after initializing a variable with the name ‘MyVariable’, this can be used in other actions by selecting it from Dynamic Content.
What data types are supported in data objects?
Power Automate supports various data types for data objects including string, boolean, integer, float, array, and object.
Can you pass data between flows?
Yes, you can pass data between flows using the ‘Run a child flow’ action. Data passed to this action can be captured in the child flow as a trigger output.
Can you use expression when working with data objects?
Yes, expressions can be used to perform complex manipulation of the data objects in Power Automate.
What is an array data object?
An array data object is a type of data object that stores multiple values, which can be of different data types.
Is it possible to nest data objects?
Yes, it is possible to have data objects within data objects. This is particularly useful when working with JSON data in your flows.
extutorials.com