Which connector should you select?

The data model contains several measures.

You need to create a Power BI report from the existing data. The solution must minimize development effort.

Which type of data source should you use?

Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table. You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?

You import the following tables.

You need to perform the following analyses:

✑ Orders sold over time that include a measure of the total order value

Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report.

What should you do first?

One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.

What should you do?

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

The file must be imported to a Power BI dataset.

You need to ensure that the dataset can be refreshed in powerbi.com.

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

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?

You need to use the dataflow in a report. The solution must meet the following requirements:

✑ Minimize online processing operations.

✑ Minimize calculation times and render times for visuals.

✑ Include data from the current year, up to and including the previous day.

What should you do?

From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

You need to select an alternate data connector that will connect to the database.

Which type of connector should you choose?

A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Datasource.Error: Could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

• If the discount column returns an error, a discount of 0.05 must be used.

• All the rows of data must be maintained.

• Administrative effort must be minimized.

What should you do in Power Query Editor?

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

You load a data extract that includes a free text field named col1.

You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.

What should you do?

Each sales region has an HR manager.

You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.

How should you provision access to the reports for the HR managers?

Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis.

You need to reduce the load times of the query without affecting the analysis.

Which two actions achieve this goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Which relationship should you use to link the tables?