You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Graphical user interface, text Description automatically generated with medium confidence

Box 1: Append Queries as New.
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.
Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Reference:
https://docs.microsoft.com/en-us/power-query/append-queries

Comment: *

Name: *

Email: *

Verification: *

You have a prospective customer list that contains 1,500 rows of dat
a. 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.

• A.Open the Advanced Editor.
• B.Select Column quality.
• C.Enable Column profiling based on entire dataset.
• D.Select Column distribution.
• E.Select Column profile.

Comment: *

Name: *

Email: *

Verification: *

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year.
You grant users access to the dashboard by using the viewer role on the workspace.
A user wants to receive daily notifications of the number shown on the card visual.
You need to automate the notifications.
What should you do?

• A.Create a subscription.
• B.Tag the user in a comment.
• C.Create a data alert.
• D.Share the dashboard to the user.

Comment: *

Name: *

Email: *

Verification: *

You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
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.

Correct Answer:

1 - Duplicate Customer query....
2 - Group by CustId by Max ModifiedDate (only 2 columns to keep)
3 - Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)

Comment: *

Name: *

Email: *

Verification: *