최신Microsoft Analyzing and Visualizing Data with Power BI - 070-778무료샘플문제
문제1
You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.
The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.
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?
You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.
The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.
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?
정답: A
문제2
You have a query that uses a Microsoft Excel data source. The data source contains the following table.
You need the data to appear as shown in the following table.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a query that uses a Microsoft Excel data source. The data source contains the following table.
You need the data to appear as shown in the following table.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
문제3
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 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?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
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 exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You are implementing the Power BI model.
You need to edit the Product Category query to match the desired Power BI model.
How should you complete the advanced 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 pint.
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 exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You are implementing the Power BI model.
You need to edit the Product Category query to match the desired Power BI model.
How should you complete the advanced 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 pint.
정답:
Explanation
Box 1: Table.RemoveColumns
Box 2: Table.RenameColumns
References:
https://msdn.microsoft.com/en-us/library/mt260776.aspx
https://msdn.microsoft.com/en-us/library/mt260808.aspx
문제5
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.
Start of repeated scenario
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 StoreJD column. This is the only relationship between the tables.
You plan to use Power Bl Desktop to create an analytics solution for the data.
End of repeated scenario.
You are modeling the data in Power Bl.
You need to import only a sample of the data from the Order table.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.
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.
Start of repeated scenario
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 StoreJD column. This is the only relationship between the tables.
You plan to use Power Bl Desktop to create an analytics solution for the data.
End of repeated scenario.
You are modeling the data in Power Bl.
You need to import only a sample of the data from the Order table.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.
정답: A
문제6
You have the following two queries in Power BI Desktop:
* A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
* A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle database Both tables have the same columns.
You need to combine the data from SMB_Customers and Enterprise_Customers.
Which command should you use?
You have the following two queries in Power BI Desktop:
* A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
* A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle database Both tables have the same columns.
You need to combine the data from SMB_Customers and Enterprise_Customers.
Which command should you use?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)
The file is in c:\data\.
You need to ensure that you can publish the file to Power BI.
What should you do first?
You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)
The file is in c:\data\.
You need to ensure that you can publish the file to Power BI.
What should you do first?
정답: C
문제8
You create a new app workspace. You add a user named Userl1 as a member of the workspace. Userl1 can edit content.
You plan to create a report in an app workspace that uses data from a Microsoft Azure SQL database.
You need to create the report. The solution must ensure that Userl1 can edit the report from Power BI Desktop and from powerbi.com.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You create a new app workspace. You add a user named Userl1 as a member of the workspace. Userl1 can edit content.
You plan to create a report in an app workspace that uses data from a Microsoft Azure SQL database.
You need to create the report. The solution must ensure that Userl1 can edit the report from Power BI Desktop and from powerbi.com.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
정답:
