최신 070-778 무료덤프 - Microsoft Analyzing and Visualizing Data with Power BI
You have the following tables.
There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date].
The Cross filter direction of the relationship is set to Single.
You plan to create a column chart that displays the following two measures:
* Count of SubscriberID by Month based on the StartDate
* Count of SubscriberID by Month based on the EndDate
What should you do before you create the measures?
There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date].
The Cross filter direction of the relationship is set to Single.
You plan to create a column chart that displays the following two measures:
* Count of SubscriberID by Month based on the StartDate
* Count of SubscriberID by Month based on the EndDate
What should you do before you create the measures?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have a Power BI model that has a date table. A sample of the data shown in the following table.
You need to add a column to display the date in the format of December 01, 2014.
Which DAX formula should you use in Power BI Desktop?
You need to add a column to display the date in the format of December 01, 2014.
Which DAX formula should you use in Power BI Desktop?
정답: C
You have a Microsoft SharePoint Online site named Sales.
Your company has 1,000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales can view the report from the Sales site.
What should you do?
Your company has 1,000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales can view the report from the Sales site.
What should you do?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an app workspace that contains a report. The report contains sensitive data.
You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.
Solution: From Publish to web, generate an iFrame.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an app workspace that contains a report. The report contains sensitive data.
You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.
Solution: From Publish to web, generate an iFrame.
Does this meet the goal?
정답: A
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an app workspace that contains a report. The report contains sensitive data.
You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.
Solution: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an app workspace that contains a report. The report contains sensitive data.
You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.
Solution: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity.
Does this meet the goal?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You plan to use Power BI Embedded to deliver reports in a web application.
You need to ensure that the reports display live data.
Which data source you should use?
You need to ensure that the reports display live data.
Which data source you should use?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have a table in Power BI Desktop as shown in the following exhibit.
You pivot the columns as shown in the following exhibit.
You need to resolve the error in row 3. The solution must preserve all the data.
What should you do?
You pivot the columns as shown in the following exhibit.
You need to resolve the error in row 3. The solution must preserve all the data.
What should you do?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
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.
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.
정답:
Explanation
CONCATENATE
MMM
References: https://msdn.microsoft.com/en-us/library/ee634811.aspx
You have three Power BI Desktop projects named Reportl.pbix, Report2.pbix, and Report3.pbix that have the following characteristics:
* Report1.pbix contains a custom visualization.
* Report2.pbix implements row-level security.
* Report3.pbix connects to a Microsoft SQL Server database by using DirectQuery.
Which reports support Publish to Web, and which reports can be published to Power BI Report Server? To answer, drag the appropriate reports to the correct targets. Each report 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.
* Report1.pbix contains a custom visualization.
* Report2.pbix implements row-level security.
* Report3.pbix connects to a Microsoft SQL Server database by using DirectQuery.
Which reports support Publish to Web, and which reports can be published to Power BI Report Server? To answer, drag the appropriate reports to the correct targets. Each report 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://docs.microsoft.com/en-us/power-bi/service-publish-to-web#custom-visuals
You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year.
You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year.
What should you do?
You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year.
What should you do?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)