Refer to the Exhibit Practice Questions

Refer to the exhibit.

Power Fx formula:
If(
    IsEmpty(SortByColumns(Filter(Accounts, 'Account Name' = "Contoso"), "Created On", Descending)),
    "No records found",
    First(SortByColumns(Filter(Accounts, 'Account Name' = "Contoso"), "Created On", Descending)).'Account Name'
)

Refer to the exhibit.

{
  "knowledgeSources": [
    {
      "type": "sharepoint",
      "url": "https://contoso.sharepoint.com/sites/HRDocs",
      "refreshInterval": "weekly"
    },
    {
      "type": "publicWebsite",
      "url": "https://www.example.com/policies",
      "refreshInterval": "daily"
    }
  ],
  "generativeAI": {
    "enabled": true,
    "moderation": "medium"
  },
  "authentication": {
    "type": "azuread",
    "tenantId": "tenant123"
  }
}

Refer to the exhibit.

```
{
  "name": "Order Approval",
  "type": "canvas",
  "dataSources": [
    {
      "type": "Microsoft Dataverse",
      "entities": ["Orders", "OrderDetails"],
      "relationships": [
        {
          "fromEntity": "Orders",
          "toEntity": "OrderDetails",
          "relationshipType": "OneToMany",
          "fromKey": "OrderID",
          "toKey": "OrderID"
        }
      ]
    }
  ],
  "controls": [
    {
      "type": "Gallery",
      "name": "OrderGallery",
      "items": "Orders",
      "template": {
        "fields": ["OrderID", "OrderDate", "Total"],
        "controls": [
          {
            "type": "Button",
            "name": "DetailButton",
            "text": "View Details",
            "action": "Navigate(OrderDetailScreen)"
          }
        ]
      }
    }
  ]
}
```

Refer to the exhibit.

{
  "type": "Microsoft.PowerApps/apis",
  "apiVersion": "2020-10-01",
  "properties": {
    "displayName": "Salesforce Connector",
    "backendService": {
      "serviceUrl": "https://login.salesforce.com",
      "endpoint": "https://instance.salesforce.com/services/data/v52.0"
    },
    "connectionParameters": {
      "token": {
        "type": "oauthSetting",
        "oAuthSettings": {
          "flow": "accessCode",
          "clientId": "3MVG9lKcPoNINVB",
          "scopes": ["api", "refresh_token"]
        }
      }
    }
  }
}

Refer to the exhibit.

```
{
  "data": [
    {
      "table": "Sales",
      "columns": ["Date", "ProductID", "SalesAmount", "Region"],
      "rows": [
        ["2024-01-01", 101, 250.00, "North"],
        ["2024-01-01", 102, 150.00, "South"],
        ["2024-01-02", 101, 300.00, "North"]
      ],
      "relationships": [
        {"from": "Sales[ProductID]", "to": "Product[ProductID]"}
      ]
    },
    {
      "table": "Product",
      "columns": ["ProductID", "ProductName", "Category"],
      "rows": [
        [101, "Widget", "Tools"],
        [102, "Gadget", "Electronics"]
      ]
    }
  ]
}
```

Workflow: When a new lead is created in Dataverse, send an email to the sales team and create a task in Planner.

Refer to the exhibit.

Error: "The data source for the report has been removed or changed. Please refresh the report to get the latest data."

Refer to the exhibit.

Error log:
{
  "error": {
    "code": "0x80040220",
    "message": "Business Process Flow instance creation failed. The selected entity is not valid for the selected process.",
    "details": {
      "ActivityId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890"
    }
  }
}

Refer to the exhibit.

```
{
  "name": "SalesReport",
  "dataset": "SalesDB",
  "refreshSchedule": {
    "frequency": "Daily",
    "time": "02:00",
    "timeZone": "UTC",
    "days": ["Monday","Tuesday","Wednesday","Thursday","Friday"]
  },
  "dataSources": [
    {
      "type": "Sql",
      "connectionString": "Server=sqlsrv;Database=SalesDB;Integrated Security=SSPI;"
    }
  ]
}
```

Refer to the exhibit.

{
  "trigger": {
    "type": "Recurrence",
    "recurrence": {
      "frequency": "Day",
      "interval": 1
    }
  },
  "actions": {
    "Get_items": {
      "type": "OpenApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_commondataserviceforapps",
          "operationId": "GetItems"
        },
        "parameters": {
          "entityName": "opportunities",
          "$filter": "statecode eq 0"
        }
      }
    },
    "Send_email": {
      "type": "OpenApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_office365",
          "operationId": "SendEmail"
        },
        "parameters": {
          "To": "manager@contoso.com",
          "Subject": "Open Opportunities Report",
          "Body": "Please review the attached report."
        }
      },
      "runAfter": {
        "Get_items": ["Succeeded"]
      }
    }
  },
  "description": "Send daily report of open opportunities to manager."
}

{
  "resource": {
    "type": "Microsoft.PowerApps/apis",
    "name": "shared_commondataservice",
    "properties": {
      "displayName": "Microsoft Dataverse",
      "publisher": "Microsoft",
      "connectionParameters": {
        "serverUrl": {
          "type": "string",
          "uiDefinition": {
            "displayName": "Environment URL",
            "description": "Your Dataverse environment URL",
            "tooltip": "Provide the URL of your Dataverse environment"
          }
        }
      }
    }
  }
}

Error: The flow 'Send Approval' failed. Action 'Send_an_HTTP_request_to_SharePoint' returned an unsupported status code '403'. The caller does not have permission to perform the action.

Refer to the exhibit.

```
EXEC sp_who2
```

Output:
```
SPID  Status   Login    HostName  BlkBy  DBName   Command   CPUTime DiskIO  LastBatch
54    sleeping sa       SERVER1   .      SalesDB  AWAITING COMMAND  0       0       2023-03-15 10:00:00.000
55    runnable  user1    CLIENT1   54     SalesDB  SELECT    5000    1200    2023-03-15 10:05:00.000
```

{
  "type": "Microsoft.PowerApps/apps",
  "properties": {
    "appVersion": "1.0.0",
    "createdBy": {
      "displayName": "John Doe"
    },
    "lastModifiedBy": {
      "displayName": "Jane Smith"
    },
    "connections": [
      {
        "name": "shared_commondataservice",
        "id": "/providers/Microsoft.PowerApps/apis/shared_commondataservice"
      }
    ]
  }
}