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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You build a report to help the sales team understand its performance and the drivers of sales.
The team needs to have a single visualization to identify which factors affect success.
Which type of visualization should you use?

• A.Key influences
• B.Funnel chart
• C.Q&A
• D.Line and clustered column chart

Comment: *

Name: *

Email: *

Verification: *

You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?

• A.an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id]to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id]to ShipDate[date_id]
• B.an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id]to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id]to ShipDate[date_id]
• C.a one-to-many relationship from Date[date_id]to Sales[sales_date_id]and another one-to-many relationship from Date[date_id]to Weekly_Returns[week_id]
• D.a one-to-many relationship from Sales[sales_date_id]to Date[date_id]and a one-to- many relationship from Sales[sales_ship_date_id]to Date[date_id]
• E.a one-to-many relationship from Date[date_id]to Sales[sales_date_id]and another one-to-many relationship from Date[date_id]to Sales[sales_ship_date_id]

Comment: *

Name: *

Email: *

Verification: *

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.

Comment: *

Name: *

Email: *

Verification: *

You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
* CustomerID
* Customer City
* Customer State
* Customer Name
* Customer Address 1
* Customer Address 2
* Customer Postal Code
The Invoice table contains the following fields:
* Order ID
* Invoice ID
* Invoice Date
* Customer ID
* Total Amount
* Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
* The number of customers invoiced in each state last month
* The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: One-to-many
A customer can have many invoices within one month.
Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the
"many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Comment: *

Name: *

Email: *

Verification: *