PL-300 Microsoft Exam Dumps PDF

9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics - Expert Verified, Online, Free.  Custom View Setting...

9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics - Expert Verified, Online, Free.  Custom View Settings Topic 1 - Question Set 1 https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 1/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #1 Topic 1 HOTSPOT - You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements: ✑ Customer must be refreshed daily. ✑ Date must be refreshed once every three years. ✑ Sales must be refreshed in near real time. ✑ SalesAggregate must be refreshed once per week. You need to select the storage modes for the tables. The solution must meet the following requirements: ✑ Minimize the load times of visuals. ✑ Ensure that the data is loaded to the model based on the refresh requirements. Which storage mode should you select for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 2/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Correct Answer: Box 1: Dual - Customer should use the dual storage mode. Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source. Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual. Box 2: Dual - You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the dataset, and improve performance. Box 3: DirectQuery - Sales should use the DirectQuery storage mode. DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI dataset‫ג‬€"for example, DAX queries‫ג‬€"and that return data from DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the data source use the query language for that data source, for example, SQL. Box 4: Import - Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be fulfilled only from cached data. Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode   _Jay_ Highly Voted  2 weeks, 2 days ago Technically Yes, Correct Dual (Composite) Mode: The dual storage mode is between Import and DirectQuery. it is a hybrid approach, Like importing data, the dual storage mode caches the data in the table. However, it leaves it up to Power BI to determine the best way to query the table depending on the query context. 1) Sales Must be Refreshed in Near real time so "Direct Query" 2) Sales Aggregate is once per week so "Import" (performance also required) 3) Both Date and Customer has relationship with both Sales and SalesAggregate tables so "Dual" because to support performance for DirectQuery(Sales) and Import(SalesAggregate) upvoted 14 times   Elena3061 1 day, 9 hours ago thanks https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 3/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics upvoted 1 times   zerone72 Most Recent  6 days, 20 hours ago @Elena3061 I guess you should dual instead of DirectQuery because of their relationship with both import mode table and directQuery mode table. Take a look at _Jay_'s post and at the "Limited Relationship" paragraph in this article https://learn.microsoft.com/en-us/power-bi/transform- model/desktop-relationships-understand upvoted 2 times   Elena3061 1 day, 9 hours ago thank you! upvoted 1 times   Krish_456 1 week ago can anyone help me how to get all the question and answers. I will pay for contributor access and i need help how to get contributor access that process and all upvoted 1 times   GGrace 1 week, 3 days ago find more: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode upvoted 2 times   Elena3061 2 weeks, 2 days ago Can someone explain for me why should we use Dual instead of DirectQuiry for Date and Customer tables? Thank you upvoted 1 times   gabrysr1997 2 weeks, 6 days ago is the answer correct? upvoted 2 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 4/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #2 Topic 1 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? A. Microsoft Teams Personal Analytics B. SQL Server database C. Dataverse D. Dataflows Correct Answer: C Data sources in Power BI Desktop. The Power Platform category provides the following data connections: Power BI datasets - Power BI dataflows - Common Data Service (Legacy) Dataverse - Dataflows - Other data sources include Microsoft Teams Personal Analytics (Beta). Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources Community vote distribution C (100%)   eckip 2 weeks ago Selected Answer: C correct upvoted 2 times   Abasifreke 2 weeks, 6 days ago 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. https://support.microsoft.com/en-us/office/use-power-bi-desktop-to-connect-with-your-project-data-df4ccca1-68e9-418c-9d0f-022ac05249a2 upvoted 2 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 5/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #3 Topic 1 For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort. Which type of data source should you use? A. Power BI dataset B. a SharePoint folder C. Power BI dataflows D. an Excel workbook Correct Answer: B Connect to a SharePoint folder from Power Query Desktop To connect to a SharePoint folder: 1. From Get Data, select SharePoint folder. 2. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL text box in the SharePoint folder dialog box. In this example, the site URL is https://contoso.sharepoint.com/marketing/data. If the site URL you enter is invalid, a warning icon. warning icon will appear next to the URL text box. Select OK to continue. 3. If this is the first time you've visited this site address, select the appropriate authentication method. Enter your credentials and choose which level to apply these settings to. Then select Connect. 4. When you select the SharePoint folder you want to use, the file information about all of the files in that SharePoint folder are displayed. In addition, file information about any files in any subfolders is also displayed. 5. Etc. Reference: https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder Community vote distribution A (64%) B (36%)   RichardOgoma 20 hours, 45 minutes ago https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 6/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Selected Answer: B I looked at the data lineage view in my workspace, and you're correct. If the question was dataset, then the existing Power BI dataset should be reused. In this case, you connect to the data source which is the share point folder. upvoted 1 times   saurinkhamar 3 days, 5 hours ago B. a SharePoint folder as a datasource. Dataset is not a datasource. Dataset supports multiple datasources. upvoted 2 times   RichardOgoma 20 hours, 46 minutes ago I looked at the data lineage view in my workspace, and you're correct. If the question was dataset, then the existing Power BI dataset should be reused. In this case, you connect to the data source which is the share point folder. upvoted 1 times   rashjan 1 week ago Selected Answer: A reuse the existing dataset. upvoted 4 times   alosh 1 week, 2 days ago Selected Answer: A A : is The Correct Ansower (Dataset) the data is already Existing upvoted 3 times   alosh 1 week, 2 days ago A : is The Correct Ansower (Dataset) the data is already Existing upvoted 1 times   jawa98 1 week, 3 days ago dataset is correct upvoted 3 times   GGrace 1 week, 3 days ago A is the correct answer, we just reuse the existing PBI report dataset upvoted 2 times   Nomios 1 week, 4 days ago It should be dataset, because the case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder. upvoted 4 times   blito123 1 week, 4 days ago Dataset is correct, no? upvoted 1 times   d94949999 2 weeks, 4 days ago Power BI Dataflow is the right answer? upvoted 1 times   d94949999 2 weeks, 4 days ago Selected Answer: B I think B is the right answer upvoted 3 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 7/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #4 Topic 1 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? A. Merge the Customer and Address tables. B. Group the Customer and Address tables by the Address ID column. C. Transpose the Customer and Address tables. D. Append the Customer and Address tables. Correct Answer: A A merge queries operation joins two existing tables together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you want. Reference: https://docs.microsoft.com/en-us/power-query/merge-queries-overview Community vote distribution A (100%)   OGESSIUSER 1 week, 6 days ago Selected Answer: A A. Merge the Customer and Address tables upvoted 2 times   eckip 2 weeks ago Selected Answer: A a is correct upvoted 1 times   mrspeket 2 weeks, 2 days ago https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 8/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics A. Merge the Customer and Address tables Merge Queries by AddressID Expand and choose City, State/Region, and Country. upvoted 1 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 9/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #5 Topic 1 HOTSPOT - You have two Azure SQL databases that contain the same tables and columns. For each database, you create a query that retrieves data from a table named Customer. You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: Correct Answer: Box 1: Append Queries as New - When you have additional rows of data that you'd like to add to an existing query, you append the query. There are two append options: * Append queries as new displays the Append dialog box to create a new query by appending multiple tables. * Append queries displays the Append dialog box to add additional tables to the current query. Incorrect: When you have one or more columns that you'd like to add to another query, you merge the queries. Box 2: Disable loading the query to the data model By default, all queries from Query Editor will be loaded into the memory of Power BI Model. You can disable the load for some queries, especially queries that used as intermediate transformation to produce the final query for the model. Disabling Load doesn't mean the query won't be refreshed, it only means the query won't be loaded into the memory. When you click on Refresh model in Power BI, or when a scheduled refresh happens even queries marked as Disable Load will be refreshed, but their data will be used as intermediate source for other queries instead of loading directly into the model. This is a very basic performance tuning tip, but very important when your Power BI model grows bigger and bigger. Reference: https://docs.microsoft.com/en-us/power-query/append-queries https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up   Namenick10 2 days, 21 hours ago https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 10/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Correct - Append Queries as New - Disable loading the query to the data model upvoted 2 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 11/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #6 Topic 1 DRAG DROP - In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product. Every Product has a ProductSubCategory. Not every ProductsubCategory has a parent ProductCategory. You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query. How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: Correct Answer: Box 1: Inner - Every Product has a ProductSubCategory. A standard join is needed. One of the join kinds available in the Merge dialog box in Power Query is an inner join, which brings in only matching rows from both the left and right tables. Box 2: Left outer - Not every ProductsubCategory has a parent ProductCategory. One of the join kinds available in the Merge dialog box in Power Query is a left outer join, which keeps all the rows from the left table and brings https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 12/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics in any matching rows from the right table. Reference: https://docs.microsoft.com/en-us/power-query/merge-queries-inner https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer   learnazureportal 1 week, 4 days ago Answer is correct upvoted 2 times Question #7 Topic 1 You are building a Power BI report that uses data from an Azure SQL database named erp1. You import the following tables. You need to perform the following analyses: ✑ Orders sold over time that include a measure of the total order value Orders by attributes of products sold The solution must minimize update times when interacting with visuals in the report. What should you do first? A. From Power Query, merge the Order Line Items query and the Products query. B. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function. C. Calculate the count of orders per product by using a DAX function. D. From Power Query, merge the Orders query and the Order Line Items query. Correct Answer: D A merge queries operation joins two existing tables together based on matching values from one or multiple columns. Join the Orders and the Order Line Items tables. Reference: https://docs.microsoft.com/en-us/power-query/merge-queries-overview Community vote distribution A (100%)   rikarikarika888 20 hours, 10 minutes ago It is definitely A upvoted 1 times   saurinkhamar 3 days, 5 hours ago A. All fields are covered with OrderLine and product query. upvoted 1 times   susunz 6 days, 6 hours ago Selected Answer: A by attributes of products sold upvoted 3 times   David_Zed 1 week, 3 days ago Selected Answer: A Should be A, because we need to get " Orders sold over time that include a measure of the total order value Orders by attributes of products sold" Order line detail for quantities ordered, and product for product's attribute upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 13/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #8 Topic 1 You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis. What should you do? A. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library. B. Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library. C. Get data from a SharePoint folder, enter the site URL, and then select Combine & Load. D. Get data from a SharePoint list, enter the site URL, and then select Combine & Load. Correct Answer: A Get Data from SharePoint folder + select Combine & Load to load the data from all of the files in the SharePoint folder directly into your app. Note: Connect to a SharePoint folder from Power Query Desktop To connect to a SharePoint folder: 1. From Get Data, select SharePoint folder. 2. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL text box in the SharePoint folder dialog box. In this example, the site URL is https://contoso.sharepoint.com/marketing/data. If the site URL you enter is invalid, a warning icon. warning icon will appear next to the URL text box. SharePoint folder selection. 3. Select OK to continue. 4. If this is the first time you've visited this site address, select the appropriate authentication method. Enter your credentials and choose which level to apply these settings to. Then select Connect. 5. When you select the SharePoint folder you want to use, the file information about all of the files in that SharePoint folder are displayed. In addition, file information about any files in any subfolders is also displayed. 6. Select Combine & Transform Data to combine the data in the files of the selected SharePoint folder and load the data into the Power Query Editor for editing. Or select Combine & Load to load the data from all of the files in the SharePoint folder directly into your app. Reference: https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder Community vote distribution A (60%) C (40%)   fdsdfgxcvbdsfhshfg 1 week ago Selected Answer: A We need to access the subfolders; we have to filter using Folder Path column upvoted 2 times   Manikom 1 week, 1 day ago Selected Answer: A I think A is correct. SharepointFolder 'combine&load' should load all files and not only Manufacturing ones so this should exclude answer C. Sharepointlist doesn't have 'Combine&Tranform', 'Combine&Load' options so this excludes answers B and D (https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist) upvoted 1 times   alosh 1 week, 2 days ago Selected Answer: A A is correct upvoted 1 times   Nomios 1 week, 4 days ago See for more information: https://docs.microsoft.com/nl-nl/power-query/connectors/sharepointonlinelist upvoted 1 times   Nomios 1 week, 4 days ago Answer: None are correct! From Get Data in PowerBI desktop the only options are: https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 14/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics From Get Data in PowerBI desktop the only options are: - SharePoint folder - SharePoint Online List - SharePoint List So this excludes answers A & C From the navigator screen you only have the options 'Load' or 'Transform Data'. 'Combine' is not an available option. So this excludes answers B, C & D upvoted 1 times   Pushliang 1 week, 4 days ago A IS RIGHT. upvoted 1 times   eckip 2 weeks ago Selected Answer: A I tried it out. For me all answers are not completely correct. C & D: Are wrong because you have to filter somehow, otherwise you will get all files also from other document libraries. A: Sounds correct until you also have to combine the files after filtering. This is missing here. Otherwise it works exactly like this. B: SharePoint List connector needs many more steps. After entering the site URL, you have to do many transformation steps and I did not manage to come until the combine step. So the answer as it is here seems to be wrong for me. I would go with A. upvoted 2 times   Avnin 2 weeks, 1 day ago The description of the answer is the content from B upvoted 2 times   MilouSluijter 2 weeks, 4 days ago B Also in examtopics DA-100, topic 3 question 12 upvoted 2 times   Muffinshow 3 weeks ago Selected Answer: C C The explanation is correct but the answer i wrong upvoted 4 times   June15 2 weeks ago I think you are correct, the ms docs explains the steps. https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder upvoted 1 times   d94949999 2 weeks, 3 days ago I think option A itself is right upvoted 1 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 15/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #9 Topic 1 DRAG DROP - You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1. Sheet2 contains the following table named Table2. You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values. 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. Select and Place: Correct Answer: Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data   Muffinshow Highly Voted  3 weeks ago https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 16/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Import From Excel Append Table 2 to Table 1 Remove Duplicates upvoted 28 times   Sjefen 2 weeks, 1 day ago Agreed upvoted 2 times   alosh 2 weeks, 6 days ago Correct upvoted 4 times   emmanuelkech Highly Voted  2 weeks, 5 days ago Import From Excel since it has not been loaded to Powerbi initially Append Table 2 to Table 1 Remove Duplicates from the table appended to (Table1) upvoted 9 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 17/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #10 Topic 1 You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do? A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date. B. Change the data type of the Logged column to Date. C. Split the Logged column by using at as the delimiter. D. Apply a transformation to extract the first 11 characters of the Logged column. Correct Answer: D Extract the date, which is the first 11 characters. CSV files have no data types. Note: A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a. csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets. Reference: https://www.bigcommerce.com/ecommerce-answers/what-csv-file-and-what-does-it-mean-my-ecommerce-business/ Community vote distribution C (91%) 9%   _Jay_ Highly Voted  2 weeks, 2 days ago Selected Answer: C Answer C is best approach Split the Logged column by using "at" as the delimiter. upvoted 7 times   Sjefen 2 weeks, 1 day ago Correct! upvoted 2 times   Manikom Most Recent  3 days, 3 hours ago Selected Answer: C A is wrong since you extract last 11 B is wrong cause it retrieves an error when changing type without transformation C and D achieve same results but with one difference: if you split through a delimiter the resulting columns have data type automatically updated (date type and time type) If you extract first 11 characters from a text type column you will still have a text type column as a result. I would go with C as you also need to build hierarchy upvoted 1 times   saurinkhamar 3 days, 4 hours ago C seems to be correct answer. For, date we need First 10, but option is First 11. upvoted 1 times   blito123 3 days, 18 hours ago D is correct, Hour is not necessary in the question. upvoted 1 times   zerone72 6 days, 19 hours ago I believe that both C and D are correct as you don't need to keep the hour for your analysis. You just need to analyse the complaints by logged date. However, in both C and D, you'd need to convert the new column to date in order to build a date hierarchy (the "Auto-DateTime" setting allows automatically creating a date-hierarchy on a date column) upvoted 1 times   alosh 1 week, 2 days ago Selected Answer: C c is correct upvoted 1 times   elma_qhor_19 1 week, 2 days ago Answer C is the right answer upvoted 1 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 18/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics   ThariCD 1 week, 3 days ago Selected Answer: C Should split the column by delimiter "at" into a Date and Time and then set the column type to Date upvoted 1 times   _Jay_ 2 weeks, 2 days ago Answer C is best approach Split the Logged column by using at as the delimiter. upvoted 1 times   ThariCD 2 weeks, 3 days ago Selected Answer: A In Power BI you can add a new column with only the first 11 characters and then you do have the option to set the type to Date on that column, maybe the question is just unclear but it does seem to be possible to set the type on a.csv in the Power Query Editor... upvoted 1 times   June15 2 weeks ago A is talking about the last 11 characters. That wouldn’t extract the date into a new column. upvoted 2 times   ThariCD 1 week, 3 days ago You're right, I think it should be C indeed, splitting the column by at as the delimiter. upvoted 1 times   emmanuelkech 2 weeks, 4 days ago C is the best approach Split with "at" Using Custom delimiter upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 19/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #11 Topic 1 You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI dataset. You need to ensure that the dataset 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. A. Excel Workbook B. Text/CSV C. Folder D. SharePoint folder E. Web Correct Answer: AC A: Connect to an Excel workbook from Power Query Desktop To make the connection from Power Query Desktop: 1. Select the Excel option in the connector selection. 2. Browse for and select the Excel workbook you want to load. Then select Open. 3. Etc. C: Folder connector capabilities supported Folder path - Combine - Combine and load - Combine and transform - Connect to a folder from Power Query Online To connect to a folder from Power Query Online: 1. Select the Folder option in the connector selection. 2. Enter the path to the folder you want to load. Note: https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 20/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Reference: https://docs.microsoft.com/en-us/power-query/connectors/excel https://docs.microsoft.com/en-us/power-query/connectors/folder Community vote distribution AC (100%)   nucleus21 18 hours, 19 minutes ago A.Excel workbook with web path to the file D.Sharepoint Folder with web path to OneDrive (sharepoint) root domain >navigation to file since it needs to be refreshed online option C will fail as it calls the folder from local path upvoted 1 times   Snow_28 1 day, 21 hours ago A. Excel workbook C. Folder upvoted 1 times   bjornopjemic 4 days, 22 hours ago Isn't Web an option as well? https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links upvoted 2 times   OGESSIUSER 1 week, 5 days ago Selected Answer: AC A. Excel Workbook C. Folder upvoted 2 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 21/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics   GPerez73 2 weeks, 2 days ago Question #12 Topic 1 It is correct for me upvoted 1 times HOTSPOT -   Guru1337 2 weeks, 3 days ago You are So Iprofiling datathe agree with by answer, using Power but IQuery Editor. believe you could also use the Text/Csv connector. So B should in theory also be a valid answer. You have a table upvoted named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in 1 times the following exhibit.   GPerez73 2 weeks, 2 days ago It says Excel file, so B does not meet the requeriment upvoted 2 times 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 selection is worth one point. Hot Area: Correct Answer: Box 1: 69 - 69 distinct/different values. https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 22/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Note: Column Distribution allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values (total number of values that only appear once in a given column). Box 2: 4 - Reference: https://systemmanagement.ro/2018/10/16/power-bi-data-profiling-distinct-vs-unique/   olajor 4 days, 2 hours ago 69 is always the right choice! ;) upvoted 2 times   div4lyfe 1 week, 1 day ago answer is correct upvoted 1 times   learnazureportal 1 week, 4 days ago Answer is correct upvoted 2 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 23/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #13 Topic 1 HOTSPOT - You have two CSV files named Products and Categories. The Products file contains the following columns: ✑ ProductID ✑ ProductName ✑ SupplierID ✑ CategoryID The Categories file contains the following columns: ✑ CategoryID ✑ CategoryName ✑ CategoryDescription From Power BI Desktop, you import the files into Power Query Editor. You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns: ✑ ProductID ✑ ProductName ✑ SupplierID ✑ CategoryID ✑ CategoryName ✑ CategoryDescription How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: Correct Answer: Box 1: Merge - There are two primary ways of combining queries: merging and appending. * When you have one or more columns that you'd like to add to another query, you merge the queries. * When you have additional rows of data that you'd like to add to an existing query, you append the query. https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 24/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Box 2: Disable the query load - Managing loading of queries - In many situations, it makes sense to break down your data transformations in multiple queries. One popular example is merging where you merge two queries into one to essentially do a join. In this type of situations, some queries are not relevant to load into Desktop as they are intermediate steps, while they are still required for your data transformations to work correctly. For these queries, you can make sure they are not loaded in Desktop by un-checking 'Enable load' in the context menu of the query in Desktop or in the Properties screen: Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data https://docs.microsoft.com/en-us/power- bi/connect-data/refresh-include-in-report-refresh   val38 1 day, 21 hours ago OK for me upvoted 1 times   VeroF 2 weeks ago Ok for me too upvoted 3 times   GPerez73 2 weeks, 2 days ago Ok for me upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 25/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #14 Topic 1 You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection? A. Add a SQL statement. B. Set the Command timeout in minutes setting. C. Set Data Connectivity mode to Import. D. Set Data Connectivity mode to DirectQuery. Correct Answer: D DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi- dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data. Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery Community vote distribution D (100%)   OGESSIUSER 1 week, 5 days ago Selected Answer: D D. Set Data Connectivity mode to DirectQuery. upvoted 2 times   MilouSluijter 2 weeks, 4 days ago D This question also occurs in examtopics DA-100: topic 1, question 11 upvoted 2 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 26/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #15 Topic 1 DRAG DROP - You have a folder that contains 100 CSV files. You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files. 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. Select and Place: Correct Answer: 1 3 2 Step 1: From Power BI Desktop, Select Get Data, and then Select Folder. Open Power BI Desktop and then select Get Data\More‫ג‬€¦ and choose Folder from the All options on the left. https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 27/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Enter the folder path, select OK, and then select Transform data to see the folder's files in Power Query Editor. Step 2: From Power Query Editor, expand the Attributes column. Step 3: From Power Query Editor, combine the Content column. https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 28/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Combine files behavior - To combine binary files in Power Query Editor, select Content (the first column label) and select Home > Combine Files. Or you can just select the Combine Files icon next to Content. Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries   Guru1337 Highly Voted  2 weeks, 3 days ago It should be remove Content not combine, since the file data is NOT to be stored. upvoted 14 times   GPerez73 2 weeks, 1 day ago I agree upvoted 5 times   emmanuelkech Highly Voted  2 weeks, 3 days ago I think the correct flow is Get data then select folder Remove content Colum Expand Attribute Colum upvoted 13 times   pnb11 1 week, 2 days ago These are right answer 1.Get data the select folder 2.Remove attribute column (because this column contain information about file which not needed). 3.Combine Content column (which contain actual data which needed for us) upvoted 7 times   Tata11 3 days, 16 hours ago Hello dear, Metadata means information about files. It's why we remove content. upvoted 3 times   RichardOgoma Most Recent  19 hours, 59 minutes ago 1. Get data and select folder 2. Remove the content column 3. Expand the attributes column You'll have only metadata of the files remaining. upvoted 1 times   Tata11 3 days, 16 hours ago "You need to make the file metadata (metadata= information about files) available" so, get data, remove content, expand attribute. https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 29/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics upvoted 2 times Question #16 Topic 1 A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: ✑ Minimize online processing operations. ✑ Minimize calculation times and render times for visuals. ✑ Include data from the current year, up to and including the previous day. What should you do? A. Create a dataflows connection that has DirectQuery mode selected. B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset. C. Create a dataflows connection that has Import mode selected and schedule a daily refresh. D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly. Correct Answer: C A daily update is adequate. When you set up a refresh schedule, Power BI connects directly to the data sources using connection information and credentials in the dataset to query for updated data, then loads the updated data into the dataset. Any visualizations in reports and dashboards based on that dataset in the Power BI service are also updated. Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-local-drive Community vote distribution C (100%)   Snow_28 1 day, 20 hours ago B. because it uses direct query to access the tables with the connection of on-premises SQL server which would require a gateway for the connection. upvoted 1 times   saurinkhamar 2 days, 5 hours ago B. Could be an answer. OnPremise SQL server to be connected which would require Gateway upvoted 1 times   fdsdfgxcvbdsfhshfg 1 week ago Selected Answer: C C is legit upvoted 2 times Topic 2 - Question Set 2 https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 30/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #1 Topic 2 You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do? A. In the report, add a DAX calculated column that calculates the length of col1 B. In the report, add a DAX function that calculates the average length of col1 C. From Power Query Editor, add a column that calculates the length of col1 D. From Power Query Editor, change the distribution for the Column profile to group by length for col1 Correct Answer: A The LEN DAX function returns the number of characters in a text string. Note: DAX is a collection of Power BI functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model. Reference: https://docs.microsoft.com/en-us/dax/len-function-dax https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics Community vote distribution D (89%) 5%   Muffinshow Highly Voted  3 weeks ago Selected Answer: D Wrong answer, A will affect the size of the model as would C. B doesn't give you enough information about the distribution (just the average) D is the right answer. upvoted 12 times   GPerez73 2 weeks, 1 day ago I agree upvoted 1 times   RichardOgoma Most Recent  19 hours, 49 minutes ago Selected Answer: C I am confident that the length of the strings in col1 must be used for the report analysis. Creating a calculated column with DAX is not the best practice and not as efficient as using Power Query's M. I would go with C. D is tempting, but you need the data, not just to view the profile in Power Query. upvoted 1 times   saurinkhamar 2 days ago Selected Answer: D D. is the right answer upvoted 1 times   saurinkhamar 2 days ago D. is the right answer upvoted 1 times   Manikom 5 days, 4 hours ago D is correct.. From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text length distribution upvoted 1 times   fdsdfgxcvbdsfhshfg 1 week ago Selected Answer: A D is not correct, column profile just shows you the information about the column in Power Query Even when it comes to grouping rows in Power Query, there are only a few basics operations and 'length' is not one of them A seem to be the only one making sense, it however consumes more RAM when loaded into the model upvoted 1 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 31/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics   fdsdfgxcvbdsfhshfg 5 days, 1 hour ago My bad, reviewed the question and by 'analyze' they don't mean to create a report. Correct: A upvoted 1 times   fdsdfgxcvbdsfhshfg 5 days, 1 hour ago I mean D upvoted 1 times   Manikom 5 days, 4 hours ago From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text lenght distribution... D is correct upvoted 1 times   hmax56 1 week, 3 days ago Selected Answer: D D is correct upvoted 1 times   Guru1337 2 weeks, 3 days ago Selected Answer: D D is right upvoted 3 times   sheth 2 weeks, 5 days ago A will affect the size because of calculated column upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 32/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #2 Topic 2 You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions. Each sales region has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers? A. Publish the reports in an app and grant the HR managers access permission. B. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace. C. Publish the reports to a different workspace other than the one hosting the datasets. D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets. Correct Answer: A Reference: https://kunaltripathy.com/2021/10/06/bring-your-power-bi-to-power-apps-portal-part-ii/   GPerez73 Highly Voted  2 weeks, 1 day ago I would say it is correct since an app would prevent to change the layout upvoted 5 times   Snow_28 Most Recent  1 day, 3 hours ago A. would be the answers because in the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access. upvoted 1 times   MilouSluijter 2 weeks, 4 days ago I think its B. https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps RLS is used to restrict access to data not to layout of the report. Members are allowed to change the report layout. upvoted 1 times   MilouSluijter 2 weeks, 4 days ago Oeps should have said A upvoted 1 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 33/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #3 Topic 2 You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user? A. Viewer B. Admin C. Contributor D. Member Correct Answer: D Member role allows adding members or other with lower permissions to the workspace. Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces   Snow_28 1 day, 3 hours ago B or D can both be the answers because they both have the permissions to add the members in the workspaces. upvoted 1 times   Luffy561 9 hours, 40 minutes ago answer is D must use least privilege upvoted 1 times   GPerez73 2 weeks, 1 day ago Correct upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 34/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #4 Topic 2 You have a Power BI query named Sales that imports the columns shown in the following table. Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Remove the rows in which Sales[Status] has a value of Canceled. B. Remove Sales[Sales_Date]. C. Change the data type of Sale[Delivery_Time] to Integer. D. Split Sales[Sale_Date] into separate date and time columns. E. Remove Sales[Canceled Date]. Correct Answer: AD A: Removing uninteresting rows will increase query performance. D: Splitting the Sales_Date column will make comparisons on the Sales date faster. Community vote distribution AE (100%)   bjornopjemic 4 days, 21 hours ago A, only records with state finished are used D, personally I would transform the column to a date format and not split it since only the date part is used Not E, All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value upvoted 3 times   fdsdfgxcvbdsfhshfg 6 days, 23 hours ago Selected Answer: AE A,E D is already used in the analysis further downstream, we cannot edit the column upvoted 2 times   learnazureportal 1 week, 4 days ago Answer is correct upvoted 1 times   GPerez73 2 weeks, 1 day ago For me it is correct upvoted 1 times   mrspeket 2 weeks, 2 days ago The answer is correct. A - Removing the Canceled ROWS will keep only Finished : “Only rows with a Status of Finished are used in analysis.” https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 35/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics D. “Users only use the DATE part of the Sales_Date”. We can split date and time columns, it reduces the load times of the query which is a requirement here. upvoted 1 times   Jukibabu 2 weeks, 4 days ago D,E A is still needed as includes also Finished (status) sales. upvoted 2 times   ElijahSu 2 weeks, 4 days ago A is Remove the rows, not the column, A is right. But I confused if E is right or not upvoted 1 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 36/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #5 Topic 2 You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables? A. one-to-many from Transaction to Customer B. one-to-one between Customer and Transaction C. many-to-many between Customer and Transaction D. one-to-many from Customer to Transaction Correct Answer: D One on the primary Key side (customer table), many on the foreign key side (Transaction table) of the relation. Community vote distribution D (100%)   RickyAnd 1 week, 2 days ago Selected Answer: D Correct upvoted 2 times   Pushliang 1 week, 4 days ago D IS RIGHT upvoted 2 times   GPerez73 2 weeks, 1 day ago It is correct for me upvoted 3 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 37/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #6 Topic 2 You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do? A. From Model view, set the Subject and Body columns to Hidden. B. Remove the Subject and Body columns during the import. C. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent. Correct Answer: B The Subject and the Body are not needed in the report. Dropping them resolves the security problem and minimizes the model. Community vote distribution B (100%)   RickyAnd 1 week, 2 days ago Selected Answer: B correct, "prevent report recipients from reading the analyzed emails" upvoted 2 times   aloulouder 1 week, 4 days ago correct upvoted 2 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 38/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #7 Topic 2 HOTSPOT - You create a Power BI dataset that contains the table shown in the following exhibit. You need to make the table available as an organizational data type in Microsoft Excel. How should you configure the properties of the table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 39/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Correct Answer: Box 1: Cost Center - The Row label field value is used in Excel so users can easily identify the row. It appears as the cell value for a linked cell, in the Data Selector pane, and in the Information card. Box 2: ID - The Key column field value provides the unique ID for the row. This value enables Excel to link a cell to a specific row in the table. Box 3: Yes - In the Data Types Gallery in Excel, your users can find data from featured tables in your Power BI datasets. Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-excel-featured-tables   Alexeyvykhodtsev Highly Voted  5 days, 10 hours ago Maybe a Row label must be a Name. upvoted 6 times   fdsdfgxcvbdsfhshfg 5 days, 1 hour ago Yeah, Name of the Business Unit should be a Row Label upvoted 1 times   Namenick10 Most Recent  2 days, 21 hours ago https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 40/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Row label: Name Key column: ID Is featured table: Yes upvoted 3 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 41/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #8 Topic 2 You have the Power BI model shown in the following exhibit. A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requirements: ✑ The managers must only see the data of their respective country. ✑ The number of RLS roles must be minimized. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function. B. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function. C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions. D. Create one role for each country. E. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single. Correct Answer: AC A: You can take advantage of the DAX functions username() or userprincipalname() within your dataset. You can use them within expressions in Power BI Desktop. When you publish your model, it will be used within the Power BI service. Note: To define security roles, follow these steps. Import data into your Power BI Desktop report, or configure a DirectQuery connection. 1. From the Modeling tab, select Manage Roles. 2. From the Manage roles window, select Create. 3. Under Roles, provide a name for the role. 4. Under Tables, select the table to which you want to apply a DAX rule. 5. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = ‫ג‬€Value‫ג‬€. 6. After you've created the DAX expression, select the checkmark above the expression box to validate the expression. Note: You can use username() within this expression. 7. Select Save. C: By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID. Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls Community vote distribution AC (100%) https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 42/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics   Namenick10 2 days, 21 hours ago Selected Answer: AC A and C upvoted 1 times   Guru1337 2 weeks, 3 days ago Username function does not return an email. It should either be userprincipalname or username should ne filtered with the actual username. upvoted 1 times   ThariCD 1 week, 3 days ago In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service. See https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670 for more information. upvoted 5 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 43/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #9 Topic 2 HOTSPOT - You have a Power BI imported dataset that contains the data model 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 selection is worth one point. Hot Area: https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 44/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Correct Answer: Box 1: Assume Referential Integrity When connecting to a data source using DirectQuery, you can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery. Note: The following requirements are necessary for Assume referential integrity to work properly: Data in the From column in the relationship is never Null or blank For each value in the From column, there is a corresponding value in the To column Box 2: Star schema - Star schema is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact. Generally, dimension tables contain a relatively small number of rows. Fact tables, on the other hand, can contain a very large number of rows and continue to grow over time. Example: Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity https://docs.microsoft.com/en-us/power- bi/guidance/star-schema   Guru1337 Highly Voted  2 weeks, 3 days ago It should be cross filter direction. As the answer correctly states "Assume Referential Integrity" only works for direct query connections. upvoted 15 times   RichardOgoma Most Recent  19 hours, 29 minutes ago https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 45/297 9/24/22, 4:47 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics The icons on the tables aren't for DirectQuery mode tables, and Assuming referential integrity is only possible for DirectQuery tables. The cross filter direction should be reviewed, in fact made single for the star schema model design. upvoted 1 times   aloulouder 1 week, 3 days ago It should be : - cross filter direction - star schema upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 46/297 9/24/22, 4:48 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #10 Topic 2 HOTSPOT - You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales. You need to create a measure that calculates the total sales from the equivalent month of the previous year. How should you complete the calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 47/297 9/24/22, 4:48 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Correct Answer: Box 1: CALCULATE - Box 2: PARALLELPERIOD - PARALLELPERIOD returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time. Syntax: PARALLELPERIOD(,,) dates: A column that contains dates. interval: The interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month. Incorrect: SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context. Syntax: SAMEPERIODLASTYEAR() DATESMTD returns a table that contains a column of the dates for the month to date, in the current context. Syntax: DATESMTD() Box 3: 'DATE' [Month] Reference: https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax   Muffinshow Highly Voted  3 weeks ago Calculate SamePeriodLastYear 'Date'[Month] ParallelPeriod could work but here the second agrument only takes one parameter and ParallelPeriod requires three upvoted 15 times   Mati81111 1 week, 2 days ago SAMEPERIODLASTYEAR accepts a data column, Month will usually be either text (Jan) or Integer (1). so: CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) upvoted 5 times   Leonardorcaquino Highly Voted  2 weeks ago CALCULATE SAMEPERIODLASTYEAR 'DATE'[DATE] upvoted 7 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 48/297 9/24/22, 4:48 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 49/297 9/24/22, 4:48 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #11 Topic 2 DRAG DROP - You plan to create a report that will display sales data from the last year for multiple regions. You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four 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. Select and Place: Correct Answer: You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions. To define security roles, follow these steps. 1. Import data into your Power BI Desktop report (Step 1) 2. From the Modeling tab, select Manage Roles. 3. From the Manage roles window, select Create. (Step 2) 4. Under Roles, provide a name for the role. 5. Under Tables, select the table to which you want to apply a DAX rule. 6. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = ‫ג‬€Value‫ג‬€(Step 3) 7. After you've created the DAX expression, select the checkmark above the expression box to validate the expression. 8. Select Save. Step 3: Assign Users to the role. You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service. After you've created your roles, test the results of the roles within Power BI Desktop. Step 4: Publish the report. Now that you're done validating the roles in Power BI Desktop, go ahead and publish your report to the Power BI service. Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls   OGESSIUSER Highly Voted  1 week, 5 days ago Import data create the roles on power bi Publish the report Assign Users to the role. upvoted 13 times   RickyAnd Most Recent  1 week, 2 days ago Import data create the roles on power bi Publish the report Assign Users to the role. https://docs.microsoft.com/en-us/training/modules/row-level-security-power-bi/2-static-method upvoted 3 times   simplex06 2 weeks, 6 days ago I think the disclosed answer is correct. upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 50/297 9/24/22, 4:48 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics   UriTG 2 weeks ago I'm not sure. I think that the order is not the right one. I mean, you create the roles on power bi, but the work to asign users on the roles it's made on the online platform, so first you need to publish the report, and after that you assign. upvoted 4 times https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 51/297 9/24/22, 4:48 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Question #12 Topic 2 DRAG DROP - You create a data model in Power BI. Report developers and users provide feedback that the data model is too complex. The model contains the following tables. The model has the following relationships: ✑ There is a one-to-one relationship between Sales_Region and Region_Manager. ✑ There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager. ✑ There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports. 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. Select and Place: Correct Answer: Step 1: Merge [Sales_Region] and [Sales_Manager] by using an inner join. Inner Join: Returns the rows present in both Left and right table only if there is a match. Otherwise, it returns zero records. Note: Sales_Region and Sales_manager There is a one-to-one relationship between Sales_Region and Region_Manager. There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. Step 2: Merge [Region_Manager] and [Manager] by using inner join. Only managers who are associated to a sales region must be included in the reports. Note: Region_Manager and Manager. There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager. https://www.examtopics.com/exams/microsoft/pl-300/custom-view/ 52/297 9/24/22, 4:48 PM PL-300 Exam – Free Actual Q&As, Page 1 | ExamTopics Step 3: Merge [Sales_region] and [Region_Manager] by using a right join as new query named [Sales_region_and_Region_Manager] Reference: https://www.tutorialgateway.org/joins-in-power-bi/   sylesh Highly Voted  1 week, 5 days ago I think the last query in the answer should be "Merge [sales_region] and [region_manager] using an inner join". Outer join may exclude some records for which region_manager info might be absent. upvoted 5 times   RickyAnd 1 week, 2 days ago exactly, I agree upvoted 1 times   fdsdfgxcvbdsfhshfg Most Recent  5 days, 1 hour ago All three should be inner joins upvoted 3 times