Tag - PL-300 exam

HOTSPOT You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields: ✑ CustomerID ✑ Customer City ✑ Customer State ✑ Customer Name ✑ Customer Address 1 ✑ Customer Address 2 ✑ Customer Postal Code The Invoice table contains the following...

HOTSPOT You have an API that returns more than 100 columns. The following is a sample of column names. ✑ client_notified_timestamp ✑ client_notified_source ✑ client_notified_sourceid ✑ client_notified_value ✑ client_responded_timestamp ✑ client_responded_source ✑ client_responded_sourceid ✑ client_responded_value You plan to include only a subset of the returned columns. You need to remove...

You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design. What should you use?A . Active Directory groups B. tiles C....

You need to create a calculated column to display the month based on the reporting requirements . Which DAX expression should you use?A . FORMAT('Date'[date], "MMM YYYY") B. FORMAT('Date' [date], "M YY") C. FORMAT('Date'[date_id], "MMM") ""& & FORMAT('Date'[year], "#") D. FORMAT('Date' [date_id], "MMM YYYY")View AnswerAnswer: A

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend?A . Create a shared dataset for each standardized entity. B. Create dataflows for the standardized data and make the dataflows available for...

You are building a Power Bl 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...

You have an on-premises Power BI Report Server. You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?A . Microsoft Azure SQL Database B. a Microsoft SQL Server database C. a Microsoft SQL Server Analysis...

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data In DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The...

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can...

Topic 1, Litware, Inc. Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to...