Microsoft 70-778 Free Practice Questions 2021

NEW QUESTION 1
You plan to deploy a Power BI app workspace that will be viewed by 10,000 users. You need to ensure that dashboard data can be updated every 30 minutes.
What should you do?

• A. Assign each user a Power BI Pro license.
• B. Store the dataset in Microsoft Azure Storage that uses the Premium storage tier.
• C. Create the app workspace by using an account that is assigned a Power BI Pro license.
• D. Configure the app workspace for Premium capacity.

Answer: D

Explanation: References: https://docs.microsoft.com/en-us/power-bi/service-premium

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

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.

Answer:

Explanation:

NEW QUESTION 3
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 a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power BI service.
Solution: From the Power BI service, get the data from SharePoint Online, and then click Import. Does this meet the goal?

• A. Yes
• B. No

Answer: A

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

NEW QUESTION 4
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 query for a table named Sales. Sales has a column named CustomerID. The Data type of CustomerID is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column and click Replace Values… Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 5
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?

• A. LASTDATE
• B. TOTALYTFD
• C. SAMEPERIOOLASTYEAR
• D. PREVIOUSYEAR

Answer: C

NEW QUESTION 6
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace

NEW QUESTION 7
You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit.

You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart.

• A. Click the Revenue by Year and Manufacturer char
• B. On the Format tab, click Edit Interaction
• C. On the Units by Country chart, click Filter.
• D. Click the Revenue by Year and Manufacturer char
• E. On the Format tab, click Edit Interaction
• F. On the Units by Country chart, click Highlight.
• G. Click the Units by Country char
• H. On the Format tab, click Edit Interaction
• I. On the Revenue by Year and Manufacturer chart, click Filter.
• J. Click the Units by Country char
• K. On the Format tab, click Edit Interaction
• L. On the Revenue by Year and Manufacturer chart, click Highlight.

Answer: C

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

NEW QUESTION 8
You have a Power BI model that contains the following tables:
Sales (Sales_ID, DateID, sales_amount)
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 (‘Date’ [Date]))
• B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR (‘Date’ [Date]))
• C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[Date]))
• D. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]),DATESYTD(‘Date’[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

NEW QUESTION 9
You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do?

• A. Add a Microsoft SQL Server Analysis Services (SSAS) data source that uses Connect live and create a repor
• B. Pin the report to a dashboard.
• C. Create an app workspace and publish the workspace to a dashboard.
• D. Add a Microsoft Azure SQL database data source that uses DirectQuery and create a repor
• E. Pin the report to a dashboard.
• F. Add a custom streaming data tile to a dashboard.

Answer: D

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming#set-up-your-real-time-streaming-dataset-

NEW QUESTION 10
You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?

• A. From the Power BI Admin portal, click Usage metrics.
• B. From the Office 365 Admin center, click Users.
• C. From the Office 365 Admin center, click Groups.
• D. From the Power BI Admin portal, click Tenant settings.

Answer: C

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365

NEW QUESTION 11
You have the following tables.

There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date]. The Cross filter direction of the relationship is set to Single.
You plan to create a column chart that displays the following two measures:
Count of SubscriberID by Month based on the StartDate
Count of SubscriberID by Month based on the EndDate What should you do before you create the measures?

• A. Create an active one-to-one relationship from Subscriber[StartDate] to Date[Date].
• B. Change the Cross filter direction of the active relationship to Both.
• C. Change the active relationship for many-to-one.
• D. Create an inactive many-to-one relationship from Subscriber[StartDate] to Date[Date].

Answer: B

Explanation: References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

NEW QUESTION 12
You have two tables named CustomerVisits and Date in a Power BI model.
You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)

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?

• A. Create a relationship between the CustomerVisits table and the Date table.
• B. Create a hierarchy in the Date table.
• C. Modify the n=measure to use the CALCULATE DAX function.
• D. Modify the measure to use the SUM DAX function.

Answer: A

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

NEW 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

Answer: D

Explanation: References:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query

NEW QUESTION 14
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 need to create a measure of Sales[SalesAmount] where Product[Color] is Red or Product[Size] is 50. Which DAX formula should you use?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C

NEW QUESTION 15
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.

Answer:

Explanation:

NEW QUESTION 16
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.

Answer:

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

NEW QUESTION 17
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?

• A. From the Power BI Admin portal, disable the Publish to web setting.
• B. From the Power BI settings, delete the embedded codes.
• C. From the Power BI Admin portal, disable the Share content with external users setting.
• D. From the dashboard settings, modify the Share dashboard settings.

Answer: A

Explanation: References: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

NEW QUESTION 18
You have a workspace that contains 10 dashboards. A dashboard named Sales Data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries. You need to ensure that the users can find data by using natural language queries.
What should you do?

• A. From the settings of the workspace, modify the Language Settings.
• B. From the properties of the dashboard, modify the Q&A settings.
• C. From the Sales Data dashboard, modify the dashboard as a Favorite.
• D. From the properties of the datasets, modify the Q&A and Cortana settings.

Answer: D

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview

NEW QUESTION 19
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: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

Explanation: References:
https://docs.microsoft.com/en-us/power-bi/developer/embed-sample-for-customers

NEW QUESTION 20
From Power BI Desktop, you create a query that imports the following table.

You need to configure the table to appear as shown in the following table.

What should you do?

• A. From the Extract menu, click Last Characters.
• B. From the Extract menu, click Text After Delimiter.
• C. From the Format menu, click Trim.
• D. From the Split Column menu, click BY Delimiter.

Answer: B

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