HOTSPOT

You open powerbi.com as shown in the following exhibit.

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.

Reveal Solution Hide Solution

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard.

How should you configure the connection to the data source?

Reveal Solution Hide Solution

You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and publish the report to the report server.

Which data source should the report use?

Reveal Solution Hide Solution

You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

You need to ensure that User sees App1 from the My organization AppSource.

What should you do?

Reveal Solution Hide Solution

You plan to embed multiple visualization in a public website.

Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

You have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

Reveal Solution Hide Solution

You have an app workspace named Retail Analysis in the Power BI service.

You need manage the members that have access to the app workspace.

What should you do?

Reveal Solution Hide Solution

You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.

You need to ensure that all the visualization in the report can be consumed by users.

Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

DRAG DROP

Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that contains the following tables.

The following columns contain data 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 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.

End of repeated scenario.

You need to display the month as a three-letter abbreviation, followed by the year, such as jan2017.

You add a calculated column in Power BI.

Which DAX formula should you use for the calculated column? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bat between panes or scroll to view continent.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

CONCATENATE

MMM

References: https://msdn.microsoft.com/en-us/library/ee634811.aspx