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?

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

Comment: *

Name: *

Email: *

Verification: *

You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *