You have the Power BI model shown in the following exhibit.There are four departments in the Departments table.You need to ensure that users can see the data of their respective department only.What should you do?
Answer(s): B
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.What should you do?
HOTSPOT (Drag and Drop is not supported) You have a column named UnitsInStock as shown in the following exhibit.UnitsInStock has 75 non-null values, of which 51 are unique.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:
Answer(s): A
Box 1: 75 rows Is nullable allows NULL values in the column.Box 2: reduce
https://blog.crossjoin.co.uk/2019/01/20/is-nullable-column-property-power-bi/
HOTSPOT (Drag and Drop is not supported) You have a Power BI report.You have the following tables.You have the following DAX measure.Accounts :=CALCULATE (DISTINCTCOUNT (Balances[AccountID]),LASTDATE ('Date'[Date])For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
Box 1: No It will show the total number of accounts that were live at the last day of the year only.Note:DISTINCTCOUNT counts the number of distinct values in a column.LASTDATE returns the last date in the current context for the specified column of dates.Box 2: No It will show the total number of accounts that were live at the last day of the month only.Box 3: Yes
https://docs.microsoft.com/en-us/dax/distinctcount-function-dax https://docs.microsoft.com/en-us/dax/lastdate-function-dax
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.
Answer(s): A,B
Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-300 content, but please register or login to continue.