PL-900 Demonstrate the capabilities of Power BI — All Questions With Answers

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.

```
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
```

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"]
      ]
    }
  ]
}
```