Microsoft Power BI Exam 70-778 Practice Questions for Free

How can I find Microsoft Power BI free practice tests (70-778)?Microsoft Power BI is a free tool for data visualization. The Pass4itsure practice test covers the entire 70-778 exam outline(https://www.pass4itsure.com/70-778.html 70-778 dumps).Here you can get Microsoft 70-778 exam free practice!

[Free] Microsoft MCSA 70-778 PDF Dumps https://drive.google.com/open?id=1ItDAXR4jfutLH9E-eZjVpfpw2CHXAwQc

70-778 Practice Questions

List:

  • YouTube channel | helpful to prepare 70-778 exam
  • Microsoft 70-778 exam free practice questions 1-12
  • Latest Microsoft MCSA 70-778 Google Drive
  • Pass4itsure Discount Code 2020
  • More related Microsoft MCSA 2020

YouTube channel | helpful to prepare 70-778 exam

Microsoft 70-778 exam free practice questions 1-13

Using Microsoft Power BI Desktop, and configuring dashboards by using the Power BI service.

https://www.microsoft.com/en-us/learning/exam-70-778.aspx

QUESTION 1
You create a dashboard that displays the results of a customer satisfaction survey. You need to embed a tweet from
your company\\’s Twitter feed into the dashboard. What should you do?
A. To the dashboard, add a tile that uses a web content source.
B. To the dashboard, add a tile that uses a PubNub content source.
C. Edit the report and import a visualization from a file. Pin the visualization to the dashboard.
D. Edit the report and import a visualization from the marketplace. Pin the visualization to the dashboard.
Correct Answer: A
References: https://docs.microsoft.com/en-us/power-bi/service-dashboard-add-widget

QUESTION 2
You plan to create a report in Power BI Desktop. You have the following tables.

Pass4itsure 70-778 exam questions-q2

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.
Select and Place:

Pass4itsure 70-778 exam questions-q2-3

Correct Answer:

Pass4itsure 70-778 exam questions-q2-3

References: https://support.office.com/en-us/article/when-to-use-calculated-columns-and-calculated-fieldsca18d63a-5b6d-4000-8ca2-14d2aadbb734

QUESTION 3
You are creating a work schedule for a retail store.
You have the following data from a query named Schedule.

Pass4itsure 70-778 exam questions-q3

You need to visualize the data as shown in the following exhibit.
You add a matrix visualization, and then you add Employee to the rows and Scheduled to columns.
Which DAX formula should you use to create the measure that will display the checkboxes? 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.
Select and Place:

Pass4itsure 70-778 exam questions-q3-2

Correct Answer:

Pass4itsure 70-778 exam questions-q3-3

QUESTION 4
You create a report in Power BI Desktop.
You need to embed the report into a Microsoft SharePoint Online site.
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.
Select and Place:

Pass4itsure 70-778 exam questions-q4

Correct Answer:

Pass4itsure 70-778 exam questions-q4-2

References: https://powerbi.microsoft.com/en-us/blog/integrate-power-bi-reports-in-sharepoint-online/

QUESTION 5
You have an on-premises Power BI Report Server.
You plan to create a report in Power BI Desktop and publish the report to the report server.
Which data source should the report use?
A. Microsoft Azure SQL Database
B. a Microsoft SQL Server database
C. a Microsoft SQL Server Analysis Services (SSAS) database
D. Microsoft Excel
Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report
https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources

QUESTION 6
In the Power BI service, you create an app workplace that contains several dashboards.
You need to provide a user named [email protected] with the ability to edit and publish dashboards.
What should you do?
A. Modify the members of the app workspace.
B. Configure security for the dataset used by the app.
C. Share the dashboard, and then modify the Access settings of the dashboard.
D. From the app workspace, click Update app, and then configure the Access settings.
Correct Answer: C

QUESTION 7
You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same
tables as SQLProd, but only a subset of the data in SQLProd.
You create a new Power BI Desktop model that uses 120 tables from SQLDev.
You plan to publish the Power BI file to the Power BI service.
You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort.
What should you do from Query Editor before you publish the model?
A. Create a new connection to SQLProd, and then import the tables from SQLProd.
B. Delete the existing queries, and then add new data sources.
C. Configure the Data source settings.
D. Edit the source of each table query.
Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data

QUESTION 8
You have the following tables.

Pass4itsure 70-778 exam questions-q8

You need to create a new table that displays the top 10 customers by the total of SalesAmount.
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.
Hot Area:

Pass4itsure 70-778 exam questions-q8-2

Correct Answer:

Pass4itsure 70-778 exam questions-q8-3

QUESTION 9
You have a query that retrieves sales data. A sample of the data is shown in the following table.

Pass4itsure 70-778 exam questions-q9

You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from
the previous row. What should you click on the Transform tab in Query Editor?
A. Format, and then Clean
B. Date, and then Earliest
C. Fill, and then Down
D. Replace Values, and then Replace Errors
Correct Answer: C
References: https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/

QUESTION 10
You are creating a report in Power BI Desktop. You are consuming the following tables.

Pass4itsure 70-778 exam questions-q10

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.)

Pass4itsure 70-778 exam questions-q10-2

You need to ensure that the months appear in the order of the calendar. How should you sort the MonthName column?
A. by MonthNumber
B. ascending
C. descending
D. by DateKey
Correct Answer: A
References: http://ppmworks.com/sorting-month-names-chronologically-in-microsoft-power-bi-reports/

QUESTION 11
You are creating a Power BI Desktop report that has several bar charts and a date slicer. You need to create a slide
show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year. What
should you do before you publish the report?
A. Configure report level filters, and then create groups that use the List group type.
B. Configure drillthrough filters for each bar chart, and then select Selection Pane.
C. Filter the bar charts by using the slicer, and then create bookmarks.
D. Configure page level filters, and then create groups that use the Bin group type.
Correct Answer: C
References: https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

QUESTION 12
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.

Pass4itsure 70-778 exam questions-q12

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?
A.In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
B.In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
C.To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
D.To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
Correct Answer: B
References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

QUESTION 13
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. Combine Files
B. Merge Columns
C. Merge Queries
D. Append Queries
Correct Answer: D
References: http://radacad.com/append-vs-merge-in-power-bi-and-power-query

Latest Microsoft MCSA 70-778 Google Drive

Free Microsoft MCSA 70-778 PDF Dumps https://drive.google.com/open?id=1ItDAXR4jfutLH9E-eZjVpfpw2CHXAwQc

Pass4itsure Discount Code 2020

Pass4itsure discount code 2020

More related Microsoft MCSA 2020

Microsoft SQL Server Free Certification Exam Material | 70-761 dumps, 70-762 dumps, 70-764 dumps, 70-765 dumps, 70-767 dumps

70-779: Analyzing and Visualizing Data with Microsoft Excel

How to use Microsoft Excel to perform data analysis.

[Free] Microsoft MCSA 70-778 PDF Dumps https://drive.google.com/open?id=1ItDAXR4jfutLH9E-eZjVpfpw2CHXAwQc

Summarize:

This blog shares the latest Microsoft 70-778 exam dumps, 70-778 exam questions, and answers! 70-778 pdf, 70-778 exam video! You can also practice the test online! Latest update Pass4itsure 70-778 exam dumps: https://www.pass4itsure.com/70-778.html.