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.

• A. Visual2
• B. Visual4
• C. Visual5
• D. Visual3
• E. Visual1

설명: (Fast2test 회원만 볼 수 있음)

You are creating reports in Power BI Desktop. The model has the following tables.

There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.
You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have a column named phone_number. The values in the columns are in one of the following formats:
* 999-999-9999x123
* 1-999-999-9999x232
* +1-999-999-9999x66x666
The values after x in the phone-number column indicate the phone extension.
You need to create a custom column in Query Editor that contains only the phone extensions.
How should you complete the query? 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 bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Explanation

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

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 configure a KPI indicator to show the monthly sales of a store versus the target sales of the store.
How should you configure the KPI indicator? To answer, drag the appropriate column to the correct fields.
Each column may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Explanation
Indicator : Order[Order_amount]
Trend axis = Date[Month]
Target goals = Store[Sales-target]
References:
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-service-tutorial-kpi/#how-to-create-a-kpi

Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
* Access a published Power BI app
* Modify reports in an app workspace
* Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Explanation

References:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps
https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace