IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 70-778 問題集  / 70-778 問題練習

Microsoft 70-778 問題練習

Analyzing and Visualizing Data with Microsoft Power BI 試験

最新更新時間: 2019/05/15,合計59問。

平成から令和へ:70-778 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、70-778 問題集を使用してください。

 / 4

Question No : 1
You are create a report in Power BI Desktop.
You are consuming the following tables.



Date [Date] is in the mm/dd/yyy format. Date[DateKey] is in the ddmmyyy format. Date[MonthNumber] is in the mm formate[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?

正解:

Question No : 2
HOTSPOT
You have the following tables.



You need to create a measure to calculate a running total of Translation Quantity.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.






正解:

Question No : 3
You have a Power BI model for sales data.
You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.
Which DAX function should you use?

正解:

Question No : 4
DRAG DROP
From Power BI Desktop, you publish an app that contains one dashboard and one report Q&A is enabled on me dashboard.
In Q&A a user types the query count of clients and tails to receive any result. The user then types the query count of subscribers and receives 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 action from the list of actions to the answer area and arrange them in the correct order.



正解:

Question No : 5
You have a Power BI model that contains the following two tablets:



A)



B)



C)



D)



正解:

Question No : 6
HOTSPOT
You have a Power BI model that has the following tables:



You need to create the following relationships:
Sales to Product
Sales to Salesperson
You need to ensure that you can create a report that displays 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.



正解:

Question No : 7
You have a Power BI report in an app workspace.
You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.
Which information should you provide to the application developers?

正解:

Question No : 8
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 BI Embedded to embed the report into an application. The application will authenticate the users. You need to ensure that RIS is enforced when accessing the embedded report.
What should you do?

正解:

Question No : 9
DRAG DROP
You have the following two tables:



There is a relationship between Subscriber[EnrollmentDate] and Date[Date].
You plan to create a KP1 for the number of subscribers enrolled in the current year.
You need to create a goal that is five percent more than the number of subscribers enrolled during the previous calendar year.
How should you compete 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.



正解:

Question No : 10
You have two tables named Customer Visits and Date m a Power BI model.
You create a measure to calculate the number of customer visits. You use the measure m the report shown in the exhibit. (Click the Exhibit button.)



You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
You need to fix the report to display the correct data for each month.
What should you do?

正解:

Question No : 11
DRAG DROP
You have a Power BI model that contains a table named Sales. Sales contains named SalesAmount, OrderDate, SalesPerson, and OrderID.
You need to create a measure to calculate the last 12 months of sales. You must start from the last date a sale was made and ignore any niters set on the report.
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 coned selection is worth one point.



正解:

Question No : 12
You have a Power BI model that contains the following two tables:



The tables have a relationship. Date is marked as a date table in the Power B1 model.
You need to create a measure to calculate the sales for the last 12 months.
Which DAX formula should you use?
A)



B)



C)



D)



正解:

Question No : 13
You have a Power 61 report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category.
You need to ensure that when you select a year on the bar chart, the donut chart remains unchanged
What should you do?

正解:

Question No : 14
You have a Microsoft Excel 2016 workbook that has Power Pivot model. The model contains the following tables:



The model has the following relationships:



You create a new Power 61 file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson.
What should you do before you create the report?

正解:

Question No : 15
You plan to create a Power BI report You have the schema model shown m the exhibit. (Click the exhibit. button.) The model has the following relationships:



You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.
When the district managers view the sales report, they see Sales by Items for all the stores.
You need to ensure that the district managers cart see Sales by Hems for the stores they manage only.
How should you configure the relationship from Sales to Item?



正解:

 / 4