- (Exam Topic 4)
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

1. A. Add a SQL statement.
2. B. Set Data Connectivity mode to DirectQuery.
3. C. Set the Command timeout in minutes setting.
4. D. Set Data Connectivity mode to Import.

Correct Answer: B
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you’re always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

- (Exam Topic 4)
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

1. A. A user pressed F5
2. B. A new transaction was added to the data source.
3. C. A user added a comment to a tile.
4. D. The dashboard tile cache refreshed.

Correct Answer: A
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

- (Exam Topic 4)
You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by location. This
information is NOT visualized in the report. The solution must minimize the impact on the report.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Use quick insights on the dashboard.
2. B. Hide the report page.
3. C. Ask a question by using Q&A.
4. D. Add the visual to the report.
5. E. Pin the visual to the dashboard.

Correct Answer: CE

- (Exam Topic 4)
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Monthly_returns table and Date[Date_ID]. What should you do before you create the relationship?

1. A. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
2. B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
3. C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
4. D. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.

Correct Answer: B
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

- (Exam Topic 4)
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 any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: Table.RemoveColumns
When you do “Remove Columns” Power Query uses the Table.RemoveColumns function Box 2: List.Select
Get a list of columns. Box 3: Text.EndsWith

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A