You are configuring a Power BI report that uses a data model with multiple tables. What happens when you don't define relationships between these tables?
AData cannot be aggregated
BThe report loads faster
CCross-filtering in visuals is disabled
DOnly one table can display data
Explanation
Without defined relationships, cross-filtering is disabled in visuals, making it harder to analyze related data.
Q142
Which service provides low-code app development in Azure?
APower Apps
BAzure Functions
CPower Automate
DAzure DevOps
Explanation
Power Apps specifically enables low-code app development; the others serve different functionalities.
Q143
A company needs to automate their email approvals. What should they use?
APower Apps
BAzure Logic Apps
CPower Virtual Agents
DMicrosoft Teams
Explanation
Azure Logic Apps is designed for automating workflows, including email approvals; the other options do not serve this specific purpose.
Q144
You are configuring a canvas app. What happens if you disconnect a data source?
AData source is permanently removed
BApp continues with cached data
CApp immediately loses all functionality
DData source remains in the interface
Explanation
The app retains cached data until it is refreshed or modified; the other options incorrectly state the effects of disconnection.
Q145
Which service is best for automating workflows in Microsoft Power Platform?
APower Automate
BPower Apps
CPower BI
DDataverse
Explanation
Power Automate is specifically designed for automating workflows; the others serve different purposes.
Q146
A company needs to track customer feedback across multiple channels. Which tool should they use to consolidate this data in Microsoft Power Platform?
APower Apps
BPower Automate
CPower BI
DDataverse
Explanation
Dataverse consolidates data from various sources; the others are tools for building applications or analyzing data.
Q147
What happens when a Power BI dataset is refreshed?
AOld data is deleted
BNew data is imported into the dataset
CReports are automatically shared
DData queries are reset
Explanation
Refreshing a dataset imports new data from data sources; the other options do not accurately describe the refresh process.
Q148
A company needs to connect its on-premises SQL Server database to Power Apps. Which service should be used?
AOn-Premises Data Gateway
BAzure Logic Apps
CAzure Functions
DPower Automate
Explanation
The On-Premises Data Gateway securely connects services in Azure with on-premises data sources. Azure Logic Apps and Power Automate don't directly connect to databases, and Azure Functions is not meant for data connectivity in this context.
Q149
You are configuring a Power Automate flow that triggers when a new item is added to a SharePoint list. What happens if the list exceeds 2000 items?
AFlow fails to execute
BFlow executes for the first 2000
CFlow processes all items
DFlow ignores the limit
Explanation
The flow will only process the first 2000 items due to SharePoint list view thresholds. It won't fail, ignore, or process all items automatically.
Q150
Which of the following is NOT a valid data type for a Microsoft Dataverse column?
AText
BImage
CHyperlink
DGeolocation
Explanation
Hyperlink is not a native data type in Dataverse; other options like Text, Image, and Geolocation are valid data types. Text is for strings, Image for binary data, and Geolocation represents geographical data.