Microsoft Power BI Data Analyst (PL-300)

1. A data analyst needs to connect Power BI Desktop to a static Excel workbook stored on their local drive. Which data source type should they select in the Get Data dialog?

2. A data analyst is setting up a connection to an Azure SQL Database in Power BI Desktop. During the connection setup, Power BI asks them to set a Privacy Level for the data source. Which Privacy Level should be assigned to an Azure SQL Database that contains confidential company financial data?

3. A data analyst connects Power BI to two data sources: an Azure SQL Database (Import mode) and an Azure Analysis Services model (Live Connection). They want to create calculated measures that combine data from both. What connectivity mode supports this scenario?

4. A retail company is designing a Power BI data model. The model includes a Sales fact table and separate dimension tables for Products, Customers, and Dates. Which schema pattern does this represent, and what is the primary benefit for Power BI performance?

5. A company's Power BI model contains a Sales table and a Products table. The Products table has a ProductID column that is unique, and the Sales table has a ProductID column that can repeat. What is the correct relationship cardinality, and which table should be on the 'one' side?