Question 1mediummultiple choice
Read the full Manage and secure Power BI explanation →PL-300 Manage and secure Power BI • Complete Question Bank
Complete PL-300 Manage and secure Power BI question bank — all 0 questions with answers and detailed explanations.
{
"properties": {
"encryption": "ServiceManaged",
"dataClassification": "Confidential",
"defaultDatasetStorageFormat": "ABFSSmall",
"allowedDataSources": [
"SQLServer",
"AzureSQL",
"OData"
]
}
}{
"caller": "user@contoso.com",
"operation": "CreateReport",
"itemName": "SalesReport",
"workspaceId": "12345678-1234-1234-1234-123456789012",
"dataset": "SalesDataset",
"sensitivityLabel": "Confidential"
}{
"dataSources": [
{
"name": "SalesDB",
"connectionString": "Data Source=sqlserver.contoso.com;Initial Catalog=Sales;Integrated Security=SSPI;"
}
],
"datasets": [
{
"name": "SalesDataset",
"tables": [
{
"name": "Orders",
"columns": [
{"name": "OrderID", "dataType": "int"},
{"name": "CustomerID", "dataType": "int"},
{"name": "Amount", "dataType": "decimal"}
]
}
]
}
]
}{
"capacity": "Premium",
"workspaces": [
{
"name": "Sales",
"type": "Premium",
"datasets": [
{
"name": "SalesDataset",
"size": "1.5 GB",
"refreshTime": "00:45:00"
}
]
},
{
"name": "Marketing",
"type": "Shared",
"datasets": [
{
"name": "CampaignAnalysis",
"size": "200 MB",
"refreshTime": "00:10:00"
}
]
}
]
}{
"policies": [
{
"name": "SalesRLS",
"roles": [
{
"name": "SalesManager",
"filterExpression": "[SalesAmount] > 10000"
},
{
"name": "SalesRep",
"filterExpression": "[SalesAmount] > 0"
}
]
}
]
}{
"workspaces": [
{
"name": "Sales",
"type": "Group",
"state": "Active",
"users": [
{"email": "sales@contoso.com", "accessRight": "Admin", "groupUser": true},
{"email": "user1@contoso.com", "accessRight": "Member", "groupUser": false},
{"email": "user2@contoso.com", "accessRight": "Contributor", "groupUser": false}
]
},
{
"name": "Marketing",
"type": "Group",
"state": "Deleted",
"users": []
}
]
}{
"datasets": [
{
"name": "SalesDataset",
"effectiveIdentity": "user@contoso.com",
"RLS": true,
"roles": [
{
"name": "SalesRole",
"users": [
{"identity": "sales@contoso.com"},
{"identity": "manager@contoso.com"}
]
}
]
}
]
}{
"adminSettings": {
"workspaceCreationEnabled": true,
"externalSharingEnabled": false,
"publishToWebEnabled": true,
"exportDataEnabled": true,
"createEmailSubscriptionsEnabled": true,
"allowDatasetExecutionByGuestUsers": false
}
}Refer to the exhibit.
{
"version": "1.0",
"dataset": {
"name": "SalesDataset",
"tables": [
{
"name": "Sales",
"columns": [
{ "name": "SalesAmount", "dataType": "decimal" },
{ "name": "Region", "dataType": "string" },
{ "name": "SalesPerson", "dataType": "string" }
],
"roles": [
{
"name": "RegionManager",
"filter": "[Region] = LOOKUPVALUE(EmployeeRegion[Region], EmployeeRegion[UserPrincipalName], USERPRINCIPALNAME())"
}
]
},
{
"name": "EmployeeRegion",
"columns": [
{ "name": "UserPrincipalName", "dataType": "string" },
{ "name": "Region", "dataType": "string" }
]
}
]
}
}Refer to the exhibit. PowerShell Output: C:\> Get-PowerBIAccessToken Token: eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Im5PbzNaRHJPRFhFSzFqS1doWHNsSFJfS1hFZyIsImtpZCI6Im5PbzNaRHJPRFhFSzFqS1doWHNsSFJfS1hFZyJ9.eyJhdWQiOiJodHRwczovL2FuYWx5c2lzLndpbmRvd3MubmV0L3Bvd2VyYmkkL2FwaSIsImlzcyI6Imh0dHBzOi8vc3RzLndpbmRvd3MubmV0LzkwYzNlOTJhLTFhMzctNDUxYi1hM2Q5LTRiMjgzYjI0MjQ0NS8iLCJpYXQiOjE3MTIzNDU2NzgsIm5iZiI6MTcxMjM0NTY3OCwiZXhwIjoxNzEyMzQ5Mjc4LCJhY3IiOiIxIiwiYWlvIjoiQVZRQXEvOFMAAAAiLCJhbXIiOlsicHdkIl0sImFwcGlkIjoiODc4OTc2NDYtNmE4My00ZTk2LWIzNGUtZmJmZjA3YjA3YzQwIiwiYXBwaWRhY3IiOiIxIiwiZ3JvdXBzIjpbIjEwMDAwMDAwLTAwMDAtMDAwMC0wMDAwLTAwMDAwMDAwMDAwMCJdLCJpZHAiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC85MGMzZTkyYS0xYTM3LTQ1MWItYTNkOS00YjI4M2IyNDI0NDUvIiwib2lkIjoiMTIzNDU2NzgtYWJjZC1lZmdoLWlqa2wtbW5vcHFyc3R1dnd4Iiwic3ViIjoiMTIzNDU2NzgtYWJjZC1lZmdoLWlqa2wtbW5vcHFyc3R1dnd4IiwidGlkIjoiOTBjM2U5MmEtMWEzNy00NTFiLWEzZDktNGIyODNiMjQyNDQ1IiwidXRpIjoicFhYLVpHNVUyRVN1Z2hPM3R4Z0FBQSIsInZlciI6IjEuMCJ9.fake_signature
Refer to the exhibit.
DAX Expression:
= CALCULATE(
SUM(Sales[Amount]),
Sales[Region] = "West"
){
"version": "1.0",
"dataSources": [
{
"name": "SalesDB",
"connectionDetails": {
"server": "sql-company.database.windows.net",
"database": "SalesDW",
"authenticationKind": "ServicePrincipal",
"servicePrincipalId": "f47ac10b-58cc-4372-a567-0e02b2c3d479"
}
}
]
}{
"dataset": {
"name": "HRData",
"mode": "DirectQuery",
"roles": [
{
"name": "HRManager",
"table": "Employees",
"filterExpression": "[Department] = \"HR\""
},
{
"name": "Executive",
"table": "Employees",
"filterExpression": "[Department] = \"Executive\""
}
]
}
}{
"capacity": {
"type": "Premium",
"sku": "P1",
"workloads": {
"dataflows": "On",
"paginatedReports": "On",
"ai": "On"
}
},
"workspace": {
"name": "Finance",
"capacityId": "12345",
"users": [
{"user": "user1@contoso.com", "role": "Admin"},
{"user": "user2@contoso.com", "role": "Member"},
{"user": "user3@contoso.com", "role": "Contributor"}
]
}
}{
"dataset": {
"name": "SalesAnalysis",
"tables": [
{
"name": "Sales",
"columns": [
{"name": "SalesAmount", "dataType": "decimal"},
{"name": "Region", "dataType": "string"},
{"name": "Salesperson", "dataType": "string"}
]
}
],
"roles": [
{
"name": "RegionManager",
"modelPermission": "Read",
"tablePermissions": [
{
"name": "Sales",
"filterExpression": "[Region] = \"North\""
}
]
}
]
}
}{
"version": "1.0",
"dataset": {
"name": "Sales",
"tables": [
{
"name": "Orders",
"columns": [
{"name": "OrderDate", "dataType": "datetime"},
{"name": "Amount", "dataType": "decimal"}
]
}
],
"roles": [
{
"name": "SalesManager",
"modelPermission": "Read",
"tablePermissions": [
{
"name": "Orders",
"filterExpression": "USERPRINCIPALNAME() = \"salesmanager@contoso.com\""
}
]
}
]
}
}{
"policyRule": {
"if": {
"allOf": [
{
"field": "type",
"equals": "Microsoft.PowerBI/workspaces"
},
{
"field": "Microsoft.PowerBI/workspaces/sku",
"equals": "Premium"
}
]
},
"then": {
"effect": "deny"
}
}
}{
"dataset": {
"name": "SalesDataset",
"refreshSchedule": {
"frequency": "Daily",
"time": "03:00",
"timeZone": "UTC",
"days": ["Monday","Tuesday","Wednesday","Thursday","Friday"]
},
"dataSources": [
{
"type": "Sql",
"connectionString": "Server=tcp:myserver.database.windows.net,1433;Database=SalesDB;Authentication=ActiveDirectoryServicePrincipal"
}
]
}
}{
"policy": {
"Version": "1.0",
"Rules": [
{
"Name": "BlockExport",
"Action": "Block",
"Condition": {
"User": { "Group": "SalesTeam" },
"Activity": "ExportReportToPDF",
"SensitivityLabel": { "Equals": "Confidential" }
}
}
]
}
}{
"role": {
"name": "RegionalManagers",
"tables": [
{
"table": "Sales",
"filterExpression": "[Region] = \"North\""
}
]
}
}{
"policyRule": {
"target": "datasets",
"condition": {
"sensitivityLabel": "Confidential",
"dataSource": ["SharePoint", "SQL Server"]
},
"action": "blockDownload"
}
}"scheduledRefresh": {
"enabled": true,
"startTime": "2026-03-01T06:00:00Z",
"days": ["Monday", "Wednesday", "Friday"],
"notifyOption": "MailOnFailure"
}You are a Power BI administrator for a large enterprise. The company has a Premium capacity (P3) that hosts over 200 datasets and 500 reports. Recently, users have reported that some reports take a long time to load, and the capacity metrics show high CPU usage during business hours. You need to optimize the capacity performance without adding additional capacity. The business requires that all reports remain available during business hours (9 AM to 5 PM). You have the following options:
A. Enable 'Autoscale' on the Premium capacity to automatically add additional v-cores during peak times. B. Implement a 'Query caching' policy for frequently used datasets. C. Move all datasets to shared capacity to reduce Premium load. D. Schedule dataset refreshes to occur only during business hours.
Which option should you choose?
You are a Power BI administrator for a small business. The company uses Power BI Pro licenses for all users. You need to ensure that all data sources used in Power BI reports are documented and that sensitive data is classified. You have been asked to set up a process that automatically scans Power BI datasets for sensitive data and adds classification labels. You have the following options:
A. Use Microsoft Purview to scan Power BI datasets and apply sensitivity labels. B. Use Power BI's built-in data classification feature to manually label datasets. C. Use Microsoft Sentinel to monitor data access and apply labels. D. Use Azure Policy to enforce labeling on Power BI datasets.
Which option should you choose?
{
"dataset": "SalesDataset",
"tables": [
{
"name": "Sales",
"columns": [
{"name": "SalesAmount", "dataType": "decimal"},
{"name": "Region", "dataType": "string"}
],
"roles": [
{
"name": "USOnly",
"filter": "[Region] = \"US\""
}
]
}
]
}