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
https://community.powerbi.com/t5/Power-Query/Append-vs-Append-as-new-for-performance/td-p/1822710

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Box 1: TOPN
TOPN returns the top N rows of the specified table.
Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups.
Box 3: DESC
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]...]) Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax

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:

See the explanatio for answer
Explanation:
Answer is as below:

Comment: *

Name: *

Email: *

Verification: *

You have a semantic model that connects to a streaming data source. The data source is updated frequently.
You need to create a Power B1 report that meets the following requirements:
* Supports real-time analytics
* Minimizes performance impact on the data source
* Displays the most recent data without performing a data refresh
Which connectivity mode should you use for the dataset?

• A.push mode
• B.DirectQuery mode
• C.LiveConnect mode
• D.import mode

Comment: *

Name: *

Email: *

Verification: *

Users only use the date portion of the TransactionDate value when performing data analysis. You need to minimize the model size without affecting the analysis.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Remove the TransactionID column
• B.Change the data type of the TransactionDate column to Date
• C.Remove the PostDate column
• D.Change the data type of the PostDate column to Date

Comment: *

Name: *

Email: *

Verification: *