How should you configure the relationships from Products to ProductCategory?

HOTSPOT You are creating a Microsoft Power BI data model that has the tables shown in the following table. The Products table is related to the ProductCategory table through the ProductCategoryID column. You need to ensure that you can analyze sales by product category. How should you configure the relationships...

September 11, 2022 No Comments READ MORE +

What should you do?

You need to configure access for the sales department users. The solution must me meet the security requirements . What should you do?A . Add the sales department as a member of the reports workspace B. Add the Azure Active Directory group of the sales department as an Admin of...

September 11, 2022 No Comments READ MORE +

What should you configure?

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...

September 11, 2022 No Comments READ MORE +

How should you complete the Power Query M code?

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...

September 11, 2022 No Comments READ MORE +

What should you use?

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....

September 11, 2022 No Comments READ MORE +

Which DAX expression should you use?

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

September 10, 2022 No Comments READ MORE +

What should you recommend?

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...

September 10, 2022 No Comments READ MORE +

What should you do first?

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...

September 10, 2022 No Comments READ MORE +

Which data source should the report use?

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...

September 10, 2022 No Comments READ MORE +

What should you do?

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...

September 10, 2022 No Comments READ MORE +