<< Prev Question Next Question >>

Question 20/21

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.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (21q)
Question 1: You need to address the data concerns before creating the da...
Question 2: You need to calculate the last day of the month in the balan...
Question 3: You are creating a column chart visualization. You configure...
Question 4: You are creating a Microsoft Power Bl model that has two tab...
Question 5: You are modeling data in table named SalesDetail by using Mi...
Question 6: Your company plans to completely separate development and pr...
Question 7: You have five sales regions. Each region is assigned a singl...
Question 8: You are creating an analytics report that will consume data ...
Question 9: Note: This question is part of a series of questions that pr...
Question 10: You are developing a report page. Some users will navigate t...
Question 11: You have a folder of monthly transaction extracts. You plan ...
Question 12: You need to create a DAX measure in the data model that only...
Question 13: What should you create to meet the reporting requirements of...
Question 14: You build a report to analyze customer transactions from a d...
Question 15: You have four sales regions. Each region has multiple sales ...
Question 16: You create the following step by using Power Query Editor. =...
1 commentQuestion 17: You have a report that contains three pages. One of the page...
Question 18: You need to create a relationship between the Weekly_Returns...
Question 19: You need to create a visual as shown in the following exhibi...
Question 20: You have two Azure SQL databases that contain the same table...
Question 21: You are creating a visual to show the ranking of product cat...