PL-300 practice questions 11–20

1. Question 11 · 358 in bank

   You attempt to connect Power BI Desktop to a Cassandra database. From the Get Data connector list, you discover that there is no specific connector for the Cassandra database. You need to select an alternate data connector that will connect to the database. Which type of connector should you choose?

   • AMicrosoft SQL Server database
   • BODBC
   • COLE DB
   • DOData

   Show answer

   Answer: B

   Explanation

   B is Correct because, B´cause it allows you to connect to data sources that aren't identified in the Get Data lists. The ODBC connector lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver. List details a few examples of data sources to which Power BI Desktop can connect by using the generic ODBC interface: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces

   Source: Adapted from community discussion — GuerreiroJunior

   References

   • Microsoft Learn

   Next question

2. Question 12 · 358 in bank

   You have a semantic model named Model1. You need to ensure that users can verify that the data in Model1 meets corporate standards. What should you do?

   • ACreate an image of Model1.
   • BPromote Model1.
   • CCertify Model1.
   • DApply a sensitivity label to Model1.

   Show answer

   Answer: C

   Next question

3. Question 13 · 358 in bank

   DRAG DROP - You receive annual sales data that must be included in Power BI reports. From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

   

   You need to create a report that meets the following requirements: • Visualizes the Sales value over a period of years and months • Adds a slicer for the month • Adds a slicer for the year Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Here are the correct three actions should be performed in sequence: Action 1: Select the Month and MonthNumber Columns. These columns will be used for the slicers to filter the data by month. Action 2: Select unpivot other columns. This action will transform the 2019, 2020, and 2021 columns into rows, creating a column called "Attribute" that contains the years and a column called "Value" that contains the sales data. This step makes the data more suitable for visualization and filtering by year. Action 3: Rename the Attribute column as Year and the value column as sales. Renaming the columns provides a more descriptive and meaningful structure for your data. After performing these actions, your data will be in a format that allows you to create visuals and add slicers for the month and year in Power BI.

   Source: Adapted from community discussion — Igetmyrole

   

   Next question

4. Question 14 · 358 in bank

   You attempt to open a PBIX file in Microsoft Power BI Desktop and receive the following error message in Power Query Editor. DataSource.Error: Could not find file D:\Data.txt. How should you resolve the issue?

   • AUpdate the Microsoft OLE DB Provider client libraries on your client computer.
   • BChange the file path of Data.txt.
   • CChange the file format to CSV.
   • DUse an on-premises data gateway.

   Show answer

   Answer: B

   Next question

5. Question 15 · 358 in bank

   You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?

   • AMicrosoft Teams Personal Analytics
   • BSQL Server database
   • CDataverse
   • DDataflows

   Show answer

   Answer: C

   Explanation

   You can use the Microsoft Power BI template to import data into Power BI from Project for the web and Project Online. When you're using the template, you're connected to your Microsoft Dataverse instance, where your Microsoft Project web app data is stored.

   Source: Adapted from community discussion — Abasifreke

   Next question

6. Question 16 · 358 in bank

   You have a Fabric workspace named Workspace1 that contains two Power BI reports named Report1 and Report2. You create a workspace app that contains both reports. You need to ensure that the app meets the following requirements: • Report1 must be visible to all the users in your organization. • Report2 must be visible to only a security group named Group1. What should you do next?

   • AAssign Group1 the Viewer role for Workspace1.
   • BCreate an audience and assign Group1 to the audience.
   • CAllow access to the hidden content of the app.
   • DShare Report1 with the built-in All users security group.

   Show answer

   Answer: B

   Next question

7. Question 17 · 358 in bank

   HOTSPOT - You are using Power BI Desktop to connect to an Azure SQL database. The connection is configured as shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct solution is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   10min Only tables with data If navigate using full hierarchy is unchecked you can see only tables(rows n columns) with data. Otherwise you can see all tables

   Source: Adapted from community discussion — Sushvij

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

8. Question 18 · 358 in bank

   HOTSPOT - You have the Azure SQL databases shown in the following table.

   

   You plan to build a single PBIX file to meet the following requirements: • Data must be consumed from the database that corresponds to each stage of the development lifecycle. • Power BI deployment pipelines must NOT be used. • The solution must minimize administrative effort. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Given answer is correct To meet the requirements specified, we can use a single parameter in the PBIX file that controls which database is used for data consumption based on the stage of the development lifecycle. We can use a Text parameter type in Power BI to achieve this. The parameter can be used to switch between the different database connections when a user interacts with the report. The text parameter could include values such as "Development", "Staging", and "Production", which correspond to the different databases shown in the table. The parameter can then be used in the queries to dynamically filter the data based on the selected stage of the development lifecycle. By using a single parameter, we can minimize administrative effort and ensure that the report works with each stage of the development lifecycle. No confusion, and no need to discuss further

   Source: Adapted from community discussion — SanaCanada

   

   Next question

9. Question 19 · 358 in bank

   You have a PBIX file that contains sensitive information. You need to secure the information to meet the following requirements: • Only internal users must be able to open the file if the file is shared via email. • Once the file is published, only internal users must be able to open the semantic model and the report downloaded from the Power BI service. What should you do?

   • AFrom Microsoft Power BI Desktop, apply a sensitivity label.
   • BCertify the semantic model and the report.
   • CUse a live connection for the file.
   • DFrom the Power BI service, apply a sensitivity label.

   Show answer

   Answer: A

   Next question

10. Question 20 · 358 in bank

    Select 2

    You are creating a query to be used as a Country dimension in a star schema. A snapshot of the source data is shown in the following table.

    

    You need to create the dimension. The dimension must contain a list of unique countries. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    • ADelete the Country column.
    • BRemove duplicates from the table.
    • CRemove duplicates from the City column.
    • DDelete the City column.
    • ERemove duplicates from the Country column.

    Show answer

    Answer: DE

    Explanation

    Agree The table has tocontain unique values for "Country" column, so - delete the city column --> in fact this column is not requested - Remove dupicates from the Country column

    Source: Adapted from community discussion — AnnaBi

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 11. 358 questions available.