70-778 Free Practice Test

You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table.
< ><>>< ><>><>

1. A. Right Anti
2. B. Right Outer
3. C. Left Anti
4. D. Left Outer
5. E. Inner

Correct Answer: D

You have a workspace that contains 10 dashboards. A dashboard named Sales Data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries. You need to ensure that the users can find data by using natural language queries.
What should you do?

1. A. From the settings of the workspace, modify the Language Settings.
2. B. From the properties of the dashboard, modify the Q&A settings.
3. C. From the Sales Data dashboard, modify the dashboard as a Favorite.
4. D. From the properties of the datasets, modify the Q&A and Cortana settings.

Correct Answer: D
References:
https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview

You create an app workspace named Wingtip Sales. Wingtip Sales is configured as shown in the following exhibit.
< ><>>>< >
Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

You are creating a report in Power BI Desktop. You are consuming the following tables.
<>>

1. A. Union Fiscal and Date as one table.
2. B. Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year].
3. C. Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
4. D. Merge Fiscal into the Date table.

Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service.
Which three operations can the developers achieve by using the API? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

1. A. Retrieve rows from a dataset
2. B. Create a dataset
3. C. Add rows to a dataset
4. D. Refresh an imported dataset
5. E. Add a member to a row-level security role

Correct Answer: ABC