PL-300 practice questions 31–40

1. Question 31 · 358 in bank

   HOTSPOT - You have a Power BI semantic model that contains the data sources shown in the following table.

   

   You need to configure the privacy level s of the data sources. What should you configure for each data source? To answer, select the appropriate options in the answer area. NOTE: Each correct answer 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

   Answer is correct. Employee review data seems to be private since it contains sensitive information. And sales opportunities is organizational since it contains less informative information but still internal

   Source: Adapted from community discussion — rcaliandro

   

   Next question

2. Question 32 · 358 in bank

   You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps. From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements: • Use Analytics views. • Filter data from the cloud. Which connector should you use?

   • AOData queries
   • BAzure DevOps (Boards only)
   • CAzure DevOps Server (Boards only)
   • DOData Feed

   Show answer

   Answer: D

   Explanation

   I think it is B because this link - has this point - Select Get Data > Online Services, Azure DevOps (Boards only) for cloud services or select Azure DevOps Server (Boards only) for on-premises. Then select Connect. Analytics views only support queries against work items and test cases. I am assuming this is about DevOps on the cloud

   Source: Adapted from community discussion — Tex02

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 33 · 358 in bank

   HOTSPOT - You use Power Query Editor to preview the data shown in the following exhibit.

   

   You confirm that the data will always start on row 3, and row 3 will always contain the column names. How should you shape the query? 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

   

   Next question

4. Question 34 · 358 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You implicitly convert the values into the required type. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   No, this solution does not meet the goal. Implicitly converting values into a required type would not resolve issues related to case sensitivity in DirectQuery mode. This solution might actually cause more problems or errors because: - Case sensitivity issues are related to text comparison and matching, not data type conversion - In DirectQuery mode, operations are pushed to the source database, and implicit conversions might not handle case sensitivity correctly - Implicit conversions could potentially create more undefined values or errors if the conversion fails

   Source: Adapted from community discussion — 7Veritas

   Next question

5. Question 35 · 358 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You change the semantic model mode. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   B. No Changing the semantic model mode (e.g., from DirectQuery to Import) won't fix case sensitivity issues or errors in the data. You need to transform or clean the data to resolve these issues.

   Source: Adapted from community discussion — Fatima300

   Next question

6. Question 36 · 358 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You normalize casing in the source query or Power Query Editor. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Explanation

   I review my post Answer is A see the not below from note https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types Note Because the engine that stores and queries data in Power BI is case insensitive, take special care when you work in DirectQuery mode with a case-sensitive source. Power BI assumes that the source has eliminated duplicate rows. Because Power BI is case insensitive, it treats two values that differ only by case as duplicate, whereas the source might not treat them as such. In such cases, the final result is undefined. To avoid this situation, if you use DirectQuery mode with a case-sensitive data source, normalize casing in the source query or in Power Query Editor.

   Source: Adapted from community discussion — fgo

   References

   • Microsoft Learn

   Next question

7. Question 37 · 358 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You add an index key and normalize casing in the data source. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Explanation

   I think the answer is A. adding the index key won't fix the problem by itself but you are also normalising the case which will resolve it.

   Source: Adapted from community discussion — Tex02

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

8. Question 38 · 358 in bank

   You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: ✑ Customer ID ✑ Customer Name ✑ Phone ✑ Email Address ✑ Address ID Address contains the following columns: ✑ Address ID ✑ Address Line 1 ✑ Address Line 2 ✑ City ✑ State/Region ✑ Country ✑ Postal Code Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table. You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?

   • AMerge the Customer and Address tables.
   • BGroup the Customer and Address tables by the Address ID column.
   • CTranspose the Customer and Address tables.
   • DAppend the Customer and Address tables.

   Show answer

   Answer: A

   Explanation

   A is correct, transposing just re-orients the data; and appending will stack the tables not create the combined records you need

   Source: Adapted from community discussion — ns_guy

   Next question

9. Question 39 · 358 in bank

   Select 2

   You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI semantic model. You need to ensure that the semantic model can be refreshed in PowerBi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AWeb
   • BExcel Workbook
   • CFolder
   • DText/CSV
   • ESharePoint folder

   Show answer

   Answer: AE

   Explanation

   A and E are the correct answers. Just tested it now end to end and it works. Refreshing is performed as well. For B/C to be refreshed online, you'd need a Gateway which is not mentioned here.

   Source: Adapted from community discussion — VladStan

   Next question

10. Question 40 · 358 in bank

    You use Power Query Editor to preview a column named Date as shown in the following exhibit.

    

    You need to change the Date column to contain only the year. The solution must minimize administrative effort. What should you do?

    • ASplit the column by delimiter.
    • BSplit the column by number of characters.
    • CExtract the text after the delimiter.
    • DTransform the column to contain only the year.

    Show answer

    Answer: D

    Explanation

    D is the correct answer - Transform the column to contain only the year. This approach directly modifies the column to display only the year, without the need for additional steps like splitting or extracting text.

    Source: Adapted from community discussion — Davery

    Next question

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

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