PL-300 Exam – Practice 4 Welcome to your PL-300 Exam - Practice 4 Question 1 You have some new staff joining your Power BI team. To help them get started in Power BI Desktop, you want to create a way for them to connect to the data sources that you are using on in your project. All they will need to do to connect to the data is enter their user credentials to authenticate.How can you achieve this? Create a dynamic M query Use an Excel Macro to build connections Create a PBIDS file with your key data sources Create a template in lineage view Question 2 You use an R script to build a custom visual. However, you find that you cannot see data marked ‘N/A’ and you are getting an error when importing your data as a list.What could be TWO reasons for these issues? ‘NA’ is transformed into ‘NULL’ by Power BI You have not used the correct R version Power BI only supports R dataframes You need to first install the library ‘tidyr’ Question 3 You have an inactive relationship between your date table and your shipping table. How would you use an inactive relationship in a measure? Use the LOOKUPVALUE() function Delete the active relationship and make the new relationship active Use the USERELATIONSHIP() function Change the crossfilter direction to both in the modelling tab Question 4 Your client has asked you whether you can create data alerts for all of the key visuals on your dashboard.Which two visuals can you NOT create a data alert. Funnel chart KPI chart Stacked column chart Gauge chart Card chart Question 5 You build a key influencers visual and you want to see how sales amount is affected by product category and product color.How do you complete the three fields below? Analyze -> Sales[Sales Quantity]; Explain by -> Product[Category], Product[Color] Analyze -> Sales[Sales Amount]; Expand by -> Product[Category], Product[Model] Analyze -> Sales[Sales Quantity]; Explain by -> Product[Category]; Expand by -> Product[Color] Analyze -> Sales[Sales Amount]; Explain by -> Product[Category], Product[Color] Question 6 You work for an electric car manufacturer and you need to import a Supplier table into your data model. The Supplier table list the supplier id, full name, short name and address.When reviewing the data in Power BI, you want to check the distinct and unique rows for each column. Column profile Monospaced Column distribution Show whitespace Column quality Question 7 You work for a large multinational company that has 23 departments. You have been tasked with creating a report with all the first aid trained staff . You need to create the same report for each department.How can you create the same report for each department in the most efficient manner? Create separate Power BI Desktop report for each department and email the PBIX file Add a parameter to the report to filter department Create a separate workspace for each department and create a report in each Create a separate dataset for each department and add a separate report Question 8 You have produced reports for a space tourism startup. The founder is thrilled with the Power BI service setup. However, he has some Questions on how to promote and secure the datasets to other users in the company. His three requirements are below:1. When Power BI Service launches, I want the competition report to be displayed on their screen.2. For the financial dashboard, I want the classification of the data clearly displayed.3. I want you to highlight particular reports because it is valuable and worthwhile for others to use. I also don’t want you to ask permission from the Power BI Admin each time.For the above requirements, them as either:· Certified· Promoted· Featured· Sensitivity Label Promoted / Certified / Featured Sensitivity Label / Featured / Promoted Featured / Sensitivity Label / Promoted Certified / Sensitivity Label / Promoted Question 9 You work for an electric scooter manufacturer. You have a report with five pages, and you have been asked to filter all five pages when you select a particular scooter category on the first page.What are the two ways you could do this? Add a page level filter on all five pages Create a report level filter using category in the Filter all pages’ well Use a single button and set the action type to bookmark Select paginated report and configure the settings Create a slicer for category on each page and then Sync slicers on all pages Question 10 A colleague built a Power BI desktop report. Your colleague imported a flat file into Power BI from his local machine. You have inherited the Power BI report and you need to update the source for the file. How would you go about this? On the home ribbon, click on properties and change the file path Click on the Applied step ‘source’ and click on the cog to change the file path On the home ribbon, click on manage -> then file, then change the file path Click on the Applied step 'changed type’ and click on the cog in the corner to change the file location Question 11 “A colleague calls you for help. She wants to build an app in Power BI and asks you how to publish the app.What are the three most important parts of publishing an app?“Select THREE from the below. On the permissions tab, decide who has access to the app On the title tab, fill in the name and description to help people find the app Before releasing the app, create a digital signature, so people know who built the app On the navigation tab, select the content to be visible in the app Click the Sync to organization button On the setup tab, fill in the name and description to help people find the app Question 12 You are a BI analyst for a digital marketing company. You have built a complex report that requires many custom DAX measures and tables. After releasing your report, senior management complains that it takes too long to load some key visuals.How would you identify the cause of the poorly performing report elements? Use the Dataverse button to drill into likely performance issues Use the Performance Analyzer to examine report element performance Use the cross report drillthrough feature to examine performance across the report Run an R script to determine the performance issues in report elements Question 13 You have a Premium workspace at your company and you want to use automatic page refresh.What are TWO key considerations to enable automatic page refresh? Use must first disable sharing of your workspace Your capacity administrator must enable the feature Your interval must be greater than the minimum refresh interval Refresh time in a premium capacity is rounded to the nearest 30 minutes Question 14 A medical devices company has contracted you to investigate their transportation provider’s performance. The company has a series of metrics they use to monitor the transporation provider’s performance, including on-time pickup, on-time delivery, billing accuracy etc. You are asked to find potential factors that contribute to the transportation provider’s performance.What sort of visualization can help? Scatter chart Q&A chart Key influencers chart Decomposition tree chart Question 15 The board of your company would like to see a report on their mobiles. So you go ahead and optimize the report for mobile.For each of the following statements, select Yes if the statement is true. Otherwise, select No. Yes / No / No No / No / Yes Yes / Yes / No Yes / No / Yes Question 16 Your company buys out a transportation company. You find that the company has several tables for customer records, all with the same structure and headings. You need to combine these tables to form a new single table for a customer segmentation analysis prior to merging the data into the parent company’s system.What transformation should you use? Merge queries Append queries as new Append queries Merge queries as new Question 17 You are asked by management to allow a consultant’s custom Power BI visual. However, by default, management wants no custom visuals. How would you enable the consultant’s visual while maintaining the default requirement in the most efficient manner? Temporarily disable the tenant setting for custom visualization Use Power BI Desktop .pbiviz files with the custom visual Add the custom visuals to the organizational store Build a separate Power BI service instance for the custom visual Question 18 What Text Analytics AI Insights are NOT available in Power BI. Language Detection Sentiment Analysis Key Phrase Extraction Word Sense Disambiguation Question 19 You create a Power BI report for a software company that uses AI for transportation companies. The company has a sales team across several countries and you create row-level security (RLS) in the model. Sales managers are restricted to access the data from their own country.In Power BI Desktop you create roles for each country e.g. USA, Canada, UK, France etc. You add a DAX expression for each role in the region table to filter country. You then add an Azure Active Directory security group for the country to each role. A new user starts in France.What do you need to do for the new user such that they can only see the sales data for France? In Power BI Desktop, edit the DAX expression on the role for France In Power BI Service, change the Power BI workspace security and change the user’s email address to “contributor” Add the user to the Azure Active Directory for France In Power BI Service, use “test as role” and use the email address of the new employee Question 20 You build a dashboard that has an important gauge visual for a furniture manufacturer. The head of manufacturing want an alert whenever the gauge exceeds a certain value.What are the two options for configuring an alert in Power BI Service? Use Microsoft Dataverse alert API Send an email Send a notification to mobile Use Microsoft Power Automate to trigger additional actions Question 21 What is NOT part of the Power BI Service dashboard theme? Dark Light Color-blind friendly Custom Tab-order friendly Question 22 You decide to add a KPI visual for your company’s dashboard. You need to show total units this year, show the historic values at a monthly level and for the comparison use total units last year.What fields should be used from the exhibit below in the KPI wells: Indicator, Trend Axis and Target Goals? Indicator: Sales Units This Year , Trend axis: Fiscal Month , Target Goals: Sales Units This year Indicator: Sales Units This Year , Trend axis: Fiscal Month , Target Goals: Sales Units Last year Indicator: Sales Units Last Year , Trend axis: Fiscal Month , Target Goals: Sales Units This year Indicator: Sales Units This Year , Trend axis: Fiscal Year , Target Goals: Sales Units Last year Question 23 You import a customer table from a flat file into your data model. You have been asked to investigate the performance of your model and decide to check all the data sources ‘view native query’ . When you come to the customer table, you find that the ‘view native query’ does not display.What is a possible cause for ‘view native query’ being disabled? Flat files do not support query folding In the transformation, there is a promoted headers step that blocks the native query You have used import as the storage mode There is row-level security on the dataset Question 24 You create a report for a hospital and use row-level security (RLS) for doctors to view their metrics and salary using a doctors’ role. You also create a hospital manager’ role that can see all the data. The employee table you use for RLS has id, name, role and email address.For each of the following statements, select Yes if the statement is true, otherwise select No. Yes / Yes / No Yes / Yes / Yes Yes / No / No No / Yes / No Question 25 You import the below Transport table into your model and have been instructed to find the totals across destination ZIP codes. Which summarization option would you recommend for aggregating the below three columns?· DestinationZIP· Weight· Units MAX / NONE / SUM COUNT / SUM / NONE NONE / SUM / SUM NONE / MAX / SUM Question 26 Your manager at a construction materials company wants to know how category sales have changed over time with an animation. You decide that a chart with an animation to show changes across months would help visualize the data.How would you go about achieving this objective? Create a line chart and add month to the axis well Create a waterfall chart and add month to the breakdown well Create a scatter chart and add month to the play axis well Create a tree map and add month to the details well Question 27 You are asked to create a measure to calculate the sales amount including the value added tax with the ability to go to the lowest level of detail (row level.) In addition, the value added tax is only relevant for order dates after Jan/1/2018. Prior to 2018, there is no tax applicable. See the exhibit below as an example of the output.How would you achieve this goal using a DAX expression? SUM(sales[Sales Amount]) + SUM(sales[Sales Tax]) SUMX(sales,if(sales[OrderDate]>=DATE(2018,1,1),sales[Sales Amount]+sales[Sales Tax],sales[Sales Amount]) ) SUMX(filter(sales,sales[OrderDate]>=DATE(2018,1,1)),sales[Sales Amount]+sales[Sales Tax]) SUM(sales,if(sales[OrderDate]>=‘1/1/2018’,sales[Sales Amount]+sales[Sales Tax],sales[Sales Amount]) Question 28 At your company, you are the Power BI administrator. Your company policy states that only DA-100 certified people are allowed to create new workspaces. The people who are DA-100 certified are grouped into a security group called DA100Workspace. You hire several new people who have recently completed their DA-100 certification and assign them to the DA100Workspace security group.The new users compain that they cannot create new workspaces. What three actions do you need to take in sequence in the admin portal to fix this issue?Possible actions:i. Navigate to Power BI admin portal and select Tenant settingsii. Navigate to office 365 admin security and select settingsiii. Choose specific security groups to apply to and add DA100Workspaceiv. Click on Workspace settings and then click on create workspacesv. Click refresh i / iv / iii ii / iii / v ii / iv / v i / ii / iii Question 29 You have built a dashboard for the board of a soft drink company. One of the board members has some ideas he wants to test with several visuals from a report page. However, he he wants to be able to immediatelty see the updates in the dashboard after you make changes.How would you go about doing this in the most efficient manner? Create a new dashboard for every new request and pin the new tiles Pin the report page as live to the dashboard On the report page, select embed in dashboard Create a hyperlink for the tiles and select embed in dashboard Question 30 You work for a rapid fashion company and are tasked with calculating the percentage change in sales from last month. You are given a measure Sales Total that aggregates sales and you have date table you built in DAX.How would you calculate last month’s sales percentage change? VAR SalesLastMonth = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,MONTH)) VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth) Return SalesPercentageChange VAR SalesLastMonth = CALCULATE([Sales Total], PARALLELPERIOD (‘Date‘[Date],-1,QUARTER)) VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth) Return SalesPercentageChange VAR SalesLastMonth = CALCULATE([Sales Total], SAMEPERIODLASTYEAR (‘Date‘[Date]) ) VAR SalesPercentageChange = DIVIDE([Sales Total]-SalesLastMonth,SalesLastMonth) Return SalesPercentageChange VAR SalesLastMonth = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,MONTH)) VAR SalesPercentageChange = Sales Total-SalesLastMonth Return SalesPercentageChange Question 31 Senior management wants you to add data classifications to your dashboards to raise awareness with those viewing your dashboards about what level of security should be used.For each of the following statements, select Yes if the statement is true. Otherwise, select No. Yes / Yes / Yes No / Yes / No No / No / Yes Yes / No / Yes Question 32 You have created a measure for the percentage of sales subcategory to sales and wish to apply conditional formatting as per the below exhibit. The rule you want to use is if the value is less than 10%, then shade the cell blue and if the value is greater than 10%, then shade the cell green.How would you complete the below conditional formatting table? Format: ‘Color Scale’, Row 1: ‘0 / Number’ and ‘10 / Number’, Row 2: ‘10 / Number’ and ‘100 / Number’ Format: ‘Field Value’, Row 1: ‘0 / Percentage’ and ‘10 / Percentage’, Row 2: ‘10 / Percentage’ and ‘100 / Percentage’ Format: ‘Rules’, Row 1: ‘0 / Number’ and ‘0.1 / Number’, Row 2: ‘0.1 / Number’ and ‘1 / Number’ Format: ‘Color Scale, Row 1: ‘0 / Percentage’ and ‘10 / Percentage’, Row 2: ‘10 / Percentage’ and ‘100 / Percentage’ Question 33 You work for a wine maker who has a selection of white and red wines that are fermented in barrels. The process can take between 5 and 35 months. Your data set has columns for fermentation time, start and end dateYou need to create a bar chart that shows wine fermentation time in ranges of 5 months.When creating the bar chart, which four actions should you perform in sequence? Select the fermentation time column, right click and select New Group -> Set Group type to Bin -> Set the Bin type to number of bins -> Make the bin count 6up type to Bin -> Set the Bin type to number of bins -> Make the bin count 6 Set Group type to list -> Select the fermentation time column, right click and select New Group -> Set the Bin type to number of bins -> Make the bin count 30 Select the fermentation time column, right click and select New Group -> Set the Bin type to count of bins -> Set Group type to Bin -> Make the bin size 6 Select the fermentation time column, right click and select New Group -> Set Group type to Bin -> Make the bin count 30 -> Set the Bin type to number of bins Question 34 Your company has a current year target of last year’s sales multiplied by an additional 10%. You have a date table called ‘date’ and you have a measure to sum sales called ‘Sales Total.’How would you go about creating a DAX measure to calculate this? VAR PreviousYearSales = SUMX([Sales Total], SAMEPERIODLASTYEAR (‘Date‘[Date],-1,YEAR)) VAR TargetSales = PreviousYearSales*1.1 Return TargetSales VAR PreviousYearSales = CALCULATE([Sales Total],DATEADD(‘Date‘[Date],-1,YEAR)) VAR TargetSales = PreviousYearSales*1.1 Return TargetSales VAR PreviousYearSales = CALCULATETABLE([Sales Total],DATEADD(‘Date‘[Date],-1,YEAR)) VAR TargetSales = PreviousYearSales*0.1 Return TargetSales VAR PreviousYearSales = CALCULATE([Sales Total], PARALLELPERIOD (‘Date‘[Date],-1,MONTH)) VAR TargetSales = PreviousYearSales*1.1 Return PreviousYearSales Question 35 You work for a cryptocurrency exchange as a BI analyst. You are tasked with creating a report for weekly trends across the asset ranges. Your source dataset has over 150 million rows.What two things can you do to optimize the report performance? Use the Direct Query storage mode for the dataset Only use line charts for visuals Use the Import storage mode for the dataset Do not use tab or layer order Create a summary table in the source data grouped by weekly volumes Question 36 You work for a bicycle manufacturer and you have created a bar chart with sales by category.Your boss wants to know the median sales, the 50th percentile of values in a column, rather than the total sales for each category.What are the two ways to achieve this goal? Create a new measure using the MEDIAN DAX function on the sales column In the analytics pane, add a trendline In the chart values well, right click on sales and change the summarization to Median Create a new measure using the Count (distinct) DAX function on the sales column In the chart values well, right click on sales and change the show value as’ to a percent of grand total Question 37 Your users give you feedback that they would like your reports to have more interactivity. You add some interactivity.To answer, select the following feature for each requirement from top to bottom. A feature may be used once, more than once, or not at all.Features:· Back button· Tab selection· Bookmarks· Edit interactions· Format pane Tab selection / Format pane / Back button Edit interactions / Bookmarks / Back button Edit interactions / Tab selection / Back button Bookmarks / Edit interractions / Back button Question 38 You find that your visuals on a report page are taking a long time to load and you need to find the cause. You remember there is a way to get how each of your report elements, such as visuals and DAX formulas, are performing.What five actions should you take in sequence from the below set of potential steps.· Open performance analyzer and press start recording· Ineract with the visuals· Restart Power BI· Press stop and review results· Open query diagnostics and press start recording· Click on SQL Server diagnostics· Check enable diagnostics logging· Create a blank report page Restart Power BI -> Open performance analyzer and press start recording -> Check enable diagnostics logging -> Press stop and review results Create a blank report page -> Restart Power BI -> Click on SQL Server diagnostics -> Ineract with the visuals -> Press stop and review results Create a blank report page -> Restart Power BI -> Open performance analyzer and press start recording -> Ineract with the visuals -> Press stop and review results Restart Power BI -> Open query diagnostics and press start recording -> Ineract with the visuals -> Press stop and review results Question 39 You have a dataset in Power BI Service, and you want to use Quick Insights to get some ideas for a dashboard. However, you notice that Quick Insights are not working.What are the three possible reasons why Quick Insights is not working? You have uploaded data to Power BI Your dataset uses Direct Query Your dataset uses streaming You have measures in your dataset Your dataset is not statistically significant Question 40 You have two visuals as per the below exhibit. You have the sales by year on the left, and on the right, you have sales by category.You need to configure the visual interaction between the two charts.For each of the following statements, select Yes if the statement is true. Otherwise, select No. Yes / No / Yes Yes / No / No No / No / Yes Yes / Yes / No Question 41 Your company has a Power BI Premium license and you want to use the AI features in your report to expose insights.Which of the following two statements is NOT true? You can take a piece of text and return a list of key phrases You can build your own machine learning models and use them in Power BI desktop The decomposition tree requires a premium subscription Sentiment Analysis is available for select languages You cannot use Power BI to tag images Question 42 You have created a dashboard you want to share with your suppliers to help with the data communications between your organizations. Your supplier has a Power BI Pro license and uses Power BI within their own organization as well.Prior to sharing your dashboard with your supplier, what do you first need to do? Make sure your supplier has upgraded to Power BI Premium In the tenant settings, enable email notification service for outages or incidents In the tenant settings, enable share content with external users Publish your dashboard to the web Question 43 You work for a software company that enables cryptocurrency payments for retailers.The key tables you have for your company’s reporting requirements are:1. Date is a date table created in DAX2. Countries is a geographic table that is rarely updated3. Sales has the software sales to retailers and has many new records added every dayWhich storage model should you use for each of the three requirements from top to bottom? Import / Import / Live Connection Dual / Import / Live Connection Dual / Import / DirectQuery Import / Import / DirectQuery Question 44 For your annual report, your company has produced a YouTube video. Your manager asks to add this YouTube video to your financial dashboard so the board members can see the video in the dashboard.How would you go about adding the YouTube video to your dashboard? Add an image tile Add a video tile Add a text box tile Add a custom streaming data tile Question 45 You have a large Power BI dashboard for stock prices that display weekly performance. The data set goes back to 1985. When the dashboard refreshes it takes visuals too long to load.How would you optimize the model performance? Add a personal gateway to your organization’s dataset Add a streaming tile to your dashboard Adjust the time zone in the tenant setting Configure incremental refresh Question 46 Your country has created a register for confirmed cases of COVID-19. The data is recorded in a large Azure SQL Database and is updated continuously. You have been contracted as a consultant to assist your government in creating a dashboard to visualize the data in Power BI.How would you configure your connection to the COVID-19 database? Create a script to continuously import the data Connect to the data with Live Connection Connect to the data with DirectQuery Connect to the data with AI Insights Question 47 You work for an electric engine manufacturer as a Power BI admin. You have two colleagues, Ray and Jane, who need access to your workspace. Ray will need to publish, unpublish, and change permissions for the apps. Jane needs to be able to publish reports to the workspace and delete content.What workspace roles should Ray and Jane be assigned? Ray = Member / Jane = Contributor Ray = Admin / Jane = Member Ray = Member / Jane = Viewer Ray = Member / Jane = Member Question 48 Your company uses a transport provider that charges freight costs and fuel surcharge costs as per the below exhibit for the Transport table.How would you create a measure for the row-level average of the sum of freight and surcharge? AVERAGE( Transport, Transport[Freight ($)] + Transport[Surcharge ($)]) SUMX(Transport, Transport[Freight ($)] + Transport[Surcharge ($)]) AVERAGEA( Transport, Transport[Freight ($)]) AVERAGEX( Transport, Transport[Freight ($)] + Transport[Surcharge ($)]) Question 49 You are checking your data for errors and want to see the average and standard deviation for a column.What data quality option should you use? Column quality Column distribution Column profile Monospaced Question 50 You are the Power BI admin at your company. You have assigned a colleague as a member role in your workspace.What roles can she NOT perform? Update an app Manage dataset permissions Update and delete the workspace Allow others to reshare items Question 51 You work in a warehouse for a large eCommerce company. You have a Power BI Premium dashboard of the key logistics metrics called daily shipments. You would like to receive a daily snapshot by email of the daily shipments dashboard.How can you achieve this goal? Integrate the dashboard to Power BI Desktop Ask the admin to add you as a contributor to the workspace Subscribe to the dashboard Turn on notifications on your instance of Power BI Service Question 52 You are in Power Query Editor, and you see the below view across multiple columns.What data profile tool shows the image in the red box? Column distribution Column quality Column histogram Column profile Question 53 You have two tables named Invoice and Geo that are connected through an active relationship using the GeoID field. You need to be able to filter the data from both the Geo table and from the Invoice table. I.e. you need the Invoice table filtered by Geo and the Geo table filtered by Invoice type.You have configured row-level security (RLS) so that Geographic leaders can only see the invoices from their region.You are having difficulty getting RLS working for the relationship between the Geo and Invoices.Which TWO actions should you perform to resolve this issue? In the relationship view, set the cross filter direction to Single In the relationship view, check apply security filter in both directions In the relationship view, set the cross filter direction to Both In the relationship view, uncheck make this relationship active Question 54 Your company plans to use dataflows to process the data stored in the Common Data Service to prepare for Power BI reports and Dashboards.Where should you store the dataflows? Common Data Model folder Azure Data Lake Gen2 Sharepoint Azure SQL Server Question 55 You are a Power BI User Admin.Which TWO tasks can you perform? Manage subscriptions Create and manage users and groups Enable and disable Power BI features Reset user passwords Question 56 You want to share a dashboard with external guest users from another business.How would you share content with external users? Invite external guests through the Azure Active Directory B2B Click share directly from the dashboard Go to the Power BI admin tenant setting and add the emails for the external users Modify the workspace permissions to allow for the external users Question 57 You think that a decomposition tree may be useful for your analysis.What TWO things does a decomposition tree do? Conduct root cause analysis Segments that contribute to the selected metric value Visualize data across multiple dimensions Contrast the relative importance of factors Question 58 You have an Inventory table and a Date table (see exhibit below) and need to calculate a semi-additive measure for the closing inventory value.How would you complete the below the [VALUE] field in the DAX expression?Last Inventory Level =CALCULATE (SUM ( Inventory[Quantity] ),[VALUE] ( [VALUE])) MAX / Date[Date] LASTDATE / Inventory[MovementDate] LASTNONBLANK / Inventory[MovementDate] LASTDATE / Date[Date] Question 59 How can you create a calculated table in Power BI? By using the New Table feature and writing a DAX formula By using the Group By feature By creating a new column with a table formula By using the Pivot Table feature Question 60 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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table.Solution: You write a DAX expression that uses the FILTER function.Does this meet the goal? Yes No Question 61 What is the purpose of data aggregation? To combine data from multiple sources To remove outliers from the data To replace missing data with estimated values To transform data into a different format Question 62 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? From Model view, set the Subject and Body columns to Hidden Remove the Subject and Body columns during the import. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent. Question 63 In Power Query, how does referencing a query differ from duplicating a query? Referencing uses the original query as a lookup table. Referencing works on external data sources, while duplicating does not. When you reference a query, any changes to the original query fail to reflect in the new query. Referencing uses the original query as the source and it can be used in other queries for the further processing Time's up Trần Quân PL-300 Exam – Practice 3 PL-300 Exam – Practice 5