Microsoft Analyzing and Visualizing Data with Power BI - 70-778무료 덤프문제 풀어보기
You are creating a report in Power BI Desktop.
You are consuming the following tables.
Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format.
You create the report shown in the exhibit. (Click the Exhibit button.)
You need to ensure that the months appear in the order of the calendar.
How should you sort the MonthName column?
You are consuming the following tables.
Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format.
You create the report shown in the exhibit. (Click the Exhibit button.)
You need to ensure that the months appear in the order of the calendar.
How should you sort the MonthName column?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
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 a user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI.
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 a user named User1. User1 is a member of a security group named Contoso PowerBI.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI.
Does this meet the goal?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You have a Power BI report that is configured to use row-level security (RLS).
You have the following roles:
* A manager role that limits managers to see only the sales data from the stores they manage.
* A region role that limits users to see only the data from their respective region You plan to use Power BU Embedded to embed the report into an application. The application will authenticate the users.
You need to ensure that RLS is enforced when accessing the embedded report.
What should you do?
You have the following roles:
* A manager role that limits managers to see only the sales data from the stores they manage.
* A region role that limits users to see only the data from their respective region You plan to use Power BU Embedded to embed the report into an application. The application will authenticate the users.
You need to ensure that RLS is enforced when accessing the embedded report.
What should you do?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
Your organization has a Microsoft Office 365 subscription.
When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit.
(Click the Exhibit button.)
You need to ensure that all the users can access the Power BI service.
What should you do first?
When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit.
(Click the Exhibit button.)
You need to ensure that all the users can access the Power BI service.
What should you do first?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
Note: This question is part of a series of questions that use 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 the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain date 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 a 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.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain date 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 a 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.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
From Power BI Desktop, you create a query that imports the following table.
You need to configure the table to appear as shown in the following table.
What should you do?
You need to configure the table to appear as shown in the following table.
What should you do?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database. From Power BI Desktop, you can query the database.
When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should you do to resolve the issue?
When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should you do to resolve the issue?
정답: C
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales.
You need to compare the year-to-date sales with the previous year for the same time period.
Which DAX function should you use?
You need to compare the year-to-date sales with the previous year for the same time period.
Which DAX function should you use?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
You have a Microsoft Excel spreadsheet that contains a table named Sales.
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
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?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
You have a Power B1 model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?
정답: C
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.
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 power BI model that contains the following tables:
* Assets( AssetsID, AssetName, Purchase_DateID, Value)
* Date( DateID, Date, Month, Week, Year)
The tables have relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the percentage that the total assets value increased since one year ago.
Which DAX formula should you use?
* Assets( AssetsID, AssetName, Purchase_DateID, Value)
* Date( DateID, Date, Month, Week, Year)
The tables have relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the percentage that the total assets value increased since one year ago.
Which DAX formula should you use?
정답: D
설명: (Fast2test 회원만 볼 수 있음)