070-778試験無料問題集「Microsoft Analyzing and Visualizing Data with Power BI 認定」

ページ: 1 / 11
トータル 155 問
完全版を入手する
You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular named SalesDB in Microsoft SQL Server Analysis Services (SSAS). The report will be published to the Power BI service.
You need to ensure that the report published to the Power BI service will access the current data in SalesDB.
What should you do?

解説: (GoShiken メンバーにのみ表示されます)
You have the following table named Location.

The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.
What should you do?

解説: (GoShiken メンバーにのみ表示されます)
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? 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/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart The date value in AdivityDate is a number column named DatelD. DatelD is in the YYYYMMDD format.
What should you do in the model before you create the relationship?

From Power BI Desktop, you publish an app that contains one dashboard and one report. Q&A is enabled on the dashboard.
In Q&A, a user types the query count of clients and fails to receive any results. The user then types the query count of subscribers and received the expected results.
You need to ensure that the user can use both queries to receive the same results.
Which four actions should you perform in sequence? To answer, move the appropriate actions form the list of actions to the answer area and arrange them in the correct order.
正解：

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: Configure the app workspace to be read-only for members and to run in a shared capacity.
Does this meet the goal?

You have the report 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.
正解：

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 are modifying the model to report on the number of order.
You need to calculate the number of orders.
What should you do?

解説: (GoShiken メンバーにのみ表示されます)
A data analyst publishes several Power BI visualizations to a blog.
You discover that some of the visualizations contain data that is considered private by your company.
You need to prevent the visualizations from being published to the blog.
What should you do?

解説: (GoShiken メンバーにのみ表示されます)
You plan to create a report in Power BI Desktop.
You have the following tables.

You have a measure that uses the following DAX formula.
Total Sales = SUM('Sales'[SalesAmount])
You plan to create a report to display TotalSales by ProductCategory and ProductSubCategory.
You need to create a measure to calculate the percentage of TotalSales for each ProductCategory.
How should you complete the DAX formula? 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://support.office.com/en-us/article/when-to-use-calculated-columns-and-calculated-fields-ca18d63a-5b6d-40
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.

You have a Power BI model that has the following tables:
* Product (Product_id, Product_Name)
* Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
* Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
* Sales to Product
* Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：

From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data.

You add Region and Sales to a visualization and the visualization displays the following data.

What causes the visualization to display four rows of data instead of six?

You have a table named Sales. Sales contains the data shown in the following table.

You have the following measure.
Total Sales This Year = SUM([Total Sales])
You plan to create a KPI to compare the current yearly sales to the previous year as shown in the exhibit.
(Click the Exhibit button.)

You need to create the measure for the goal.
How should you complete the DAX formula? 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/query-bi/dax/dateadd-function-dax
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.
Your company has 1,000 users in a Microsoft Office 365 subscription.
A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users.
You discover that a user named User1 can access all the dashboards.
You need to prevent User1 from accessing all the dashboards.
Solution: From the Office 365 Admin center, you remove the Power BI license from User1.
Does this meet the goal?

ページ: 1 / 11
トータル 155 問