Microsoft 70-778 ExamAnalyzing and Visualizing Data with Microsoft Power BI (beta)

Total Question: 59 Last Updated: Jul 16,2018
  • Updated 70-778 Dumps
  • Based on Real 70-778 Exams Scenarios
  • Free 70-778 pdf Demo Available
  • Check out our 70-778 Dumps in a new PDF format
  • Instant 70-778 download
  • Guarantee 70-778 success in first attempt
Package Select:

Questions & Answers PDF

Practice Test Software

Practice Test + PDF 30% Discount

Price: $65.95 $29.99

Buy Now Free Trial

Practical 70-778 software Reviews & Tips

Exam Code: 70-778 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Analyzing and Visualizing Data with Microsoft Power BI (beta)
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-778 Exam.

P.S. Vivid 70-778 courses are available on Google Drive, GET MORE: https://drive.google.com/open?id=1DsY4MrMrQbFhmpjP8lcA3sh-CLMy30N3


New Microsoft 70-778 Exam Dumps Collection (Question 1 - Question 10)

Question No: 1

You have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

A. Subscriptions

B. Dashboards

C. Datasets

D. Workbooks

Answer: C

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured- questions


Question No: 2

You have a Power BI model that contains the following tables:

u2711 Sales (Sales_ID, DateID, sales_amount)

u2711 Date (DateID, Date, Month, week, Year)

The tables have a relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the sales for the last 12 months.

Which DAX formula should you use?

A. CALCULATEx(SUM(sales[sales_amount]) DATESYTD (u2018Dateu2019 [Date]))

B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR (u2018Dateu2019 [Date]))

C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(u2018Dateu2019[Date]))

D. SUM(sales[sales_amount])- CALCULATE(SUM(sales[sales_amount]),DATESYTD(u2018Dateu2019[Date]))

Answer: C

Explanation:

References:

https://msdn.microsoft.com/en-us/library/ee634825.aspx https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics https://msdn.microsoft.com/en-us/library/ee634972.aspx


Question No: 3

HOTSPOT

You have the following tables.

You need to create a measure to calculate a running total of TransactionQuantity.

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.

Answer:

Explanation:

References: http://www.daxpatterns.com/cumulative-total/


Question No: 4

You have a Power BI 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 remains unchanged.

What should you do?

A. Set a visual level filter on the bar chart.

B. Edit the interactions form the Format menu.

C. Set a visual level filter on the donut chart.

D. Add a slicer to the page that uses the year column.

Answer: B

Explanation:

References: https://www.excelguru.ca/blog/2016/11/23/visual-interactions-in-power-bi/


Question No: 5

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?

A. Configure the app workspace for Premium capacity.

B. Enable anonymous access for the Sales site.

C. Configure the Portal Site Connection for the Sales site.

D. Disable the Embed content in apps setting from the Tenant settings in Power BI.

Answer: A

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo


Question No: 6

You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: u201cThis content isnu2019t availableu201d.

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online. What should you do?

A. Publish the app workspace.

B. Edit the settings of the Power BI web part.

C. Modify the members of the app workplace.

D. Share the dashboards in the app workspace.

Answer: C

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo


Question No: 7

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 has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values. End of repeated scenario.

You implement the Power BI model.

You add another table named Territory to the model. A sample of the data is shown in the following table.

You need to create a relationship between the Territory table and the Sales table.

Which function should you use in the query for Territory before you create the relationship?

A. Table.RemoveMatchingRows

B. Table.Distinct

C. Table.InDistinct

D. Table.ReplaceMatchingRows

Answer: B

Explanation:

References: https://msdn.microsoft.com/en-us/library/mt260775.aspx


Question No: 8

Note: This question is a 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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains two columns named Date and Time.

The tables have the following relationships:

u2711 Sales [DueDate] and Date [Date]

u2711 Sales [ShipDate] and Date [Date]

u2711 Sales [OrderDate] and Date [Date]

The active relationship is on Sales [DueDate].

You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.

Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.

Does this meet the goal?

A. Yes

B. No

Answer: B


Question No: 9

You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

You need to ensure that User sees App1 from the My organization AppSource.

What should you do?

A. From the app workspace, click Update app, configure the Content settings, and then click Update app.

B. From the app workspace settings, add a member.

C. From the app workspace, click Update app, configure the Access setting, and then click Update app.

D. From the app workspace, share the dashboard.

Answer: C

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource


Question No: 10

Note: This question is a 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 use name User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards.

Solution: From the properties of each dashboard, you modify the Share settings. Does this meet the goal?

A. Yes

B. No

Answer: B

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-your-organization#how-do-i-remove-power-bi-for-users-that-already-signed-up


P.S. Easily pass 70-778 Exam with 2passeasy Vivid Dumps & pdf vce, Try Free: https://www.2passeasy.com/dumps/70-778/ (58 New Questions)


Related 70-778 Articles