[2020.4] Microsoft MCSA 70-778 Brain Dump and Practice Test Questions

How do I get the latest Microsoft MCSA 70-778 Practice Questions and Answers? Share the latest 70-778 exam dumps, 70-778 pdf,
and online hands-on tests for free to improve skills and experience, with Lead4pass providing the latest and complete
Microsoft 70-778 dumps: https://www.leads4pass.com/70-778.html (Latest Update)

Free effective Microsoft MCSA 70-778 video tutorial

Microsoft MCSA 70-778 exam pdf free download

^{[PDF Q1-Q13]} Free Microsoft 70-778 pdf dumps download from Google Drive: https://drive.google.com/open?id=1DdXIsaUSKmarhe1xDwsARxhe78ST3Nue

Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI: https://www.microsoft.com/en-us/learning/exam-70-778.aspx

Skills measured

This exam measures your ability to accomplish the technical tasks listed below.

• Consuming and Transforming Data By Using Power BI Desktop (20-25%)
• Modeling and Visualizing Data (45-50%)
• Configure Dashboards, Reports and Apps in the Power BI Service (25-35%)

Who should take this exam?

Candidates for this exam should have a good understanding of how to use Power BI to perform data analysis.
Candidates should be proficient in connecting to data sources and performing data transformations, modeling and
visualizing data by using Microsoft Power BI Desktop, and configuring dashboards by using the Power BI service.
Candidates should also be proficient in implementing direct connectivity to Microsoft SQL Azure and SQL Server
Analysis Services (SSAS), and implementing data analysis in Microsoft Excel. Candidates may include BI professionals,
data analysts, and other roles responsible for creating reports by using Power BI.

Latest Updated Microsoft MCSA 70-778 exam Practice Questions

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

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 2
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 on the review screen.
You have a user named User!. User1 is a member of a security group named Contoso PowerB1.
User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.
Solution: From the Power B1 Admin portal, you modify the Tenant settings.
A. Yes
B. No
Correct Answer: B

QUESTION 3
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 on the review screen.
You have a query for a table named Sales. Sales have 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 Errors.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

QUESTION 4
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 on 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: From Publish to the web, generate an iFrame.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B

QUESTION 5
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 on 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
Correct Answer: A
References: https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

QUESTION 6
You need to create a custom visualization for Power BI. What should you install first?
A. jQuery
B. Node.js
C. Microsoft Azure PowerShell
D. Microsoft.NET
Correct Answer: B
References:
https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools

QUESTION 7
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 BU Embedded to embed the report into an application. The application will authenticate the
users.
You need to ensure that RLS is enforced when accessing the embedded report.
What should you do?
A. In the access token for the application, including the user name and the role name.
B. In the access token for the application, include the report URL and the Microsoft Azure Active Directory Domain
name.
C. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
D. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.
Correct Answer: A
References: https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

QUESTION 8
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 QandA settings.
C. From the Sales Data dashboard, modify the dashboard as a Favorite.
D. From the properties of the datasets, modify the QandA and Cortana settings.
Correct Answer: D
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview

QUESTION 9
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily. Which three actions should you perform
in sequence? To answer, move the appropriate actions from the list of actions to answer the area and arrange them in the
correct order.
Select and Place:

Correct Answer:

QUESTION 10
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?
A. PARALLELPERIOD
B. SAMEPERIODLAST YEAR
C. DATESYTD
D. PREVIOUSYEAR
Correct Answer: A
References: https://msdn.microsoft.com/en-us/library/ee634873.aspx

QUESTION 11
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.
Correct Answer: A
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

QUESTION 12
Your organization has a Microsoft Office 365 subscription.
When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the
Exhibit button.)

You need to ensure that all the users can access the Power BI service. What should you do first?
A. From the Microsoft Azure Active Directory admin center, assign a Power BI (free) license to each user.
B. From the Power BI Admin portal, modify the Tenant settings.
C. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet.
D. From the properties of each dashboard, modify the Share dashboard settings.
Correct Answer: C
You need to run the following cmdlet: Set-MsolCompanySettings – AllowAdHocSubscriptions $true

QUESTION 13
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.
Hot Area:

Correct Answer:

References: https://docs.microsoft.com/en-us/powerquery-m/text-replace https://docs.microsoft.com/en-us/powerquerym/text-end

Share lead4pass discount codes for free 2020

About the benefits and introductions of Lead4Pass

Lead4pass offers the latest exam exercise questions for free! Microsoft exam questions are updated throughout the year.
Lead4Pass has many professional exam experts! Guaranteed valid passing of the exam! The highest pass rate, the highest cost-effective!
Help you pass the exam easily on your first attempt.

Summarize:

Multiexam shares the latest Microsoft 70-778 exam dumps,70-778 pdf,70-778 exam exercise questions for free. You can improve your skills and exam experience online to get complete exam questions and answers guaranteed to pass the exam we recommend Lead4Pass 70-778 exam dumps

Latest update Lead4pass 70-778 exam dumps: https://www.leads4pass.com/70-778.html (155 Q&As)

^{[Q1-Q13 PDF]} Free Microsoft 70-778 pdf dumps download from Google Drive: https://www.microsoft.com/en-us/learning/exam-70-778.aspx