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
Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. 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?

• A.Merge the Customer and Address tables.
• B.Group the Customer and Address tables by the Address ID column.
• C.Append the Customer and Address tables.
• D.Transpose the Customer and Address tables.

Comment: *

Name: *

Email: *

Verification: *

You need to create a visualization to meet the reporting requirements of the sales managers.
HOW Should create the Visualization? TO answer, select the appropriate options in the answer are a.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.

Correct Answer:

Explanation
Graphical user interface, text, application, email Description automatically generated

References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Comment: *

Name: *

Email: *

Verification: *

You create a data model in Power BI.
Report developers and users provide feedback that the data model is too complex.
The model contains the following tables.

The model has the following relationships:
*There is a one-to-one relationship between Sales_Region and Region_Manager.
*There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.
*There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.
You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Correct Answer:

Explanation
1.Merge [Region_Manager] and [Manager] by using an inner join.
3.Merge [Sales_Region] and [Sales_Manager] by using an inner join.
6.Merge [Sales_Region] and [Region_Manager] by using an inner join.

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI dashboard that monitors the quality of manufacturing processes.
The dashboard contains the following elements:
* A line chart that shows the number of defective products manufactured by day.
* A KPI visual that shows the current daily percentage of defective products manufactured.
You need to be notified when the daily percentage of defective products manufactured exceeds 3%.
What should you create?

• A.an alert
• B.a Q&A visual
• C.a smart narrative visual
• D.a subscription

Comment: *

Name: *

Email: *

Verification: *