Download Microsoft.PL-300.Dump4Pass.2024-10-28.260q.vcex

Download Exam

File Info

Exam Microsoft Power BI Data Analyst
Number PL-300
File Name Microsoft.PL-300.Dump4Pass.2024-10-28.260q.vcex
Size 24 MB
Posted Oct 28, 2024
Download Microsoft.PL-300.Dump4Pass.2024-10-28.260q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

You need to update the Power Bl model to ensure that the analysts can quickly build drill-downs from business unit to product in a visual.  
What should you create? 
 


  1. a calculated table 
  2. a group 
  3. a calculated column 
  4. a hierarchy  
Correct answer: D



Question 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? 


  1. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent. 
  2. Remove the Subject and Body columns during the import. 
  3. From Model view, set the Subject and Body columns to Hidden.  
Correct answer: B
Explanation:
Incorrect Answers: A, C: Does not reduce the size of the model. 
Incorrect Answers: 
A, C: Does not reduce the size of the model. 



Question 3

You have the tables shown in the following table. 
 
 
The Impressions table contains approximately 30 million records per month. 
You need to create an ad analytics system to meet the following requirements: 
  • Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. 
  • Minimize the data model size.  
Which two actions should you perform? Each correct answer presents part of the solution.  
NOTE: Each correct selection is worth one point. 


  1. Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRowsfunction. 
  2. Create one-to-many relationships between the tables. 
  3. Create a calculated measure that aggregates by using the COUNTROWSfunction. 
  4. Create a calculated table that contains Ad_id, Site_name, andImpression_date.  
Correct answer: AB



Question 4

Your company has training videos that are published to Microsoft Stream. 
You need to surface the videos directly in a Microsoft Power BI dashboard. 
Which type of tile should you add? 


  1. video 
  2. custom streamingdata 
  3. textbox 
  4. webcontent  
Correct answer: D
Explanation:
The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source.  Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming  
The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source. 
 
Reference: 
https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming  



Question 5

You open a query in Power Query Editor.  
You need to identify the percentage of empty values in each column as quickly as possible. 
Which Data Preview option should you select? 


  1. Show whitespace 
  2. Columnprofile 
  3. Columndistribution 
  4. Columnquality  
Correct answer: D
Explanation:
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table. Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities: Column quality Column distribution Column profile  Reference: https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555  
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table. 
Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities: 
  • Column quality 
  • Column distribution 
  • Column profile  
Reference: 
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555  



Question 6

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:  
  • First name 
  • Last name 
  • Email address 
  • State/Region 
  • Phone number  
You import the list into Power Query Editor.  
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.  
Which two actions should you perform? Each correct answer presents part of the solution.  
NOTE: Each correct selection is worth one point. 


  1. Open the AdvancedEditor. 
  2. Select Columnquality. 
  3. Enable Column profiling based on entiredataset. 
  4. Select Columndistribution. 
  5. Select Columnprofile.  
Correct answer: CE
Explanation:
Data Profiling, Quality & Distribution in Power BI / Power Query features To enable these features, you need to go to the View tab à Data Preview Group à Check the following:  Column quality Column profile Column distribution     Column profile Turn on the Column Profiling feature.  Column distribution Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.  Reference: https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/ https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/  
Data Profiling, Quality & Distribution in Power BI / Power Query features 
To enable these features, you need to go to the View tab à Data Preview Group à Check the following:  
  • Column quality 
  • Column profile 
  • Column distribution 
 
 
  
  • Column profile 
Turn on the Column Profiling feature. 
 
  • Column distribution 
Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts. 
 
Reference: 
https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/ 
https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/  



Question 7

You have an API that returns more than 100 columns. The following is a sample of column names.  
  • client_notified_timestampc
  • lient_notified_sourceclien
  • t_notified_sourceidclient_
  • notified_valueclient_respo
  • nded_timestampclient_respo
  • nded_sourceclient_responde
  • d_sourceidclient_responded
  • _value  
You plan to include only a subset of the returned columns.  
You need to remove any columns that have a suffix of sourceid.  
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.  
NOTE: Each correct selection is worth one point. 


Correct answer: To work with this question, an Exam Simulator is required.
Explanation:
Box 1: Table.RemoveColumns When you do “Remove Columns” Power Query uses the Table.RemoveColumns function  Box 2: List.Select Get a list ofcolumns.  Box 3:Text.EndsWith  Reference: https://community.powerbi.com/t5/Power-Query/Remove-columns-containing-a-certain-value/td-p/759657  
Box 1: Table.RemoveColumns 
When you do “Remove Columns” Power Query uses the Table.RemoveColumns function 
 
Box 2: List.Select 
Get a list ofcolumns.  
Box 3:Text.EndsWith 
 
Reference: 
https://community.powerbi.com/t5/Power-Query/Remove-columns-containing-a-certain-value/td-p/759657  



Question 8

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  
The Customer ID and Address ID columns represent unique rows.  
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? 


  1. Merge the Customer and Address tables. 
  2. Transpose the Customer and Address tables. 
  3. Group the Customer and Address tables by the Address ID column. 
  4. Append the Customer and Address tables.  
Correct answer: A
Explanation:
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.  Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data  
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. 
 
Reference: 
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data  



Question 9

You have the following three versions of an Azure SQL database:  
  • Test 
  • Production 
  • Development  
You have a dataset that uses the development database as a data source. 
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.  
Which should you do? 


  1. Create a JSON file that contains the database server names. Import the JSON file to thedataset. 
  2. Create a parameter and update the queries to use theparameter. 
  3. Create a query for each database server and hide the developmenttables. 
  4. Set the data source privacy level to Organizational and use the ReplaceValuePower Query M function.  
Correct answer: B
Explanation:
As you can't edit datasets data sources in Power BI service, we recommend using parameters to store connection details such as instance names and database names, instead of using a static connection string. This allows you to manage the connections through the Power BI service web portal, or using APIs, at a later stage.  Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices 
As you can't edit datasets data sources in Power BI service, we recommend using parameters to store connection details such as instance names and database names, instead of using a static connection string. 
This allows you to manage the connections through the Power BI service web portal, or using APIs, at a later stage. 
 
Reference: 
https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices 



Question 10

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? 


  1. Change the data type of the Logged column to Date. 
  2. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date. 
  3. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date. 
  4. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.  
Correct answer: C
Explanation:
To use a built-in-date hierarchy, you need to set the data type of the new column to Date.  Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-examplehttps://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/  
To use a built-in-date hierarchy, you need to set the data type of the new column to Date. 
 
Reference: 
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example
https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into-separate-columns/  









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files