The Microsoft Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Analyzing and Visualizing Data with Microsoft Power BI certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guide for the Microsoft Certified Solutions Associate (MCSA) - BI Reporting will help guide you through the study process for your certification.
70-778 Analyzing and Visualizing Data with Microsoft Power BI Exam Summary
Exam Name: Microsoft Certified Solutions Associate (MCSA) - BI Reporting
Exam Code: 70-778
Exam Price: $165 (USD)
Duration: 120 mins
Number of Questions: 45-55
Passing Score: 700 / 1000
Reference Books: 20778B: Analyzing Data with Power BI
Schedule Exam: Pearson VUE
Sample Questions: Microsoft Analyzing and Visualizing Data with Microsoft Power BI Sample Questions
Recommended Practice: Microsoft 70-778 Certification Practice Exam
Exam Syllabus: 70-778 Microsoft Certified Solutions Associate (MCSA) - BI Reporting
1. Consuming and Transforming Data By Using Power BI Desktop
Connect to data sources. - May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
Perform transformations. - May include: Design and implement basic and advanced transformations; apply business rules; change data format to support visualization
Cleanse data. - May include: Manage incomplete data; meet data quality requirements
2. Modeling and Visualizing Data
Create and optimize data models. - May include: Manage relationships; optimize models for reporting; manually type in data; use Power Query
Create calculated columns, calculated tables, and measures. - May include: Create DAX formulas for calculated columns, calculated tables, and measures; Use What If parameters
Measure performance by using KPIs, gauges and cards. - May include: calculate the actual; calculate the target; calculate actual to target; configure values for gauges; use the format settings to manually set values
Create hierarchies. - May include: Create date hierarchies; create hierarchies based on business needs; add columns to tables to support desired hierarchy
Create and format interactive visualizations. - May include: Select a visualization type; configure page layout and formatting; configure interactions between visual; configure duplicate pages; handle categories that have no data; configure default summarization and data category of columns; position, align, and sort visuals; enable and integrate R visuals; format measures; Use bookmarks and themes for reports
Manage custom reporting solutions. - May include: Configure and access Microsoft Power BI Embedded; enable developers to create and edit reports through custom applications; enable developers to embed reports in applications; use the Power BI API to push data into a Power BI dataset; enable developers to create custom visuals
3. Configure Dashboards, Reports and Apps in the Power BI Service
Access on-premises data. - May include: Connect to a data source by using a data gateway;publish reports to the Power BI service from Power BI Desktop; edit Power BI Service reports by using Power BI desktop
Configure a dashboard. - May include: Add text and images; filter dashboards; dashboard settings; customize the URL and title; enable natural language queries
Publish and embed reports. - May include: Publish to web; publish to Microsoft SharePoint; publish reports to a Power BI Report Server
Configure security for dashboards, reports and apps. - May include: Create a security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant; configure Row-Level Security
Configure apps and apps workspaces. - May include: Create and configure an app workspace; publish an app; update a published app; package dashboards and reports as apps
Microsoft 70-778Certification Sample Questions and Answers
To make you familiar with Analyzing and Visualizing Data with Microsoft Power BI (70-778) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for MCSA BI Reporting 70-778 Certification to test your understanding of Microsoft 70-778process with real Microsoft certification exam environment.
70-778Analyzing and Visualizing Data with Microsoft Power BI Sample Questions:-
01. 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) PARALLELPERIOO
b) SAMPERIOOLASTYEAR
c) DATESYTD
d) PREVIOUSYEAR
02. 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 chart 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.
03. You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?
a) Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.
b) Deploy an on-premises data gateway. Import the data by using Import Data Connectivity mode.
c) Deploy an on-premises data gateway (personal mode).Import the data by using Data Query Data Connectivity mode.
d) Deploy an on-premises data gateway (personal mode). Import the data by using the Directory Query Data Connectivity mode.
04. 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) Dataset
d) Workbooks
05. In the Power BI service, you create an app workplace that contains several dashboards. You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards What should you do?
a) From the app workspace, click Update app, and then configure the Access settings.
b) Share the dashboard, and then modify the Access settings of the dashboard.
c) Configure security for the dataset used by the app.
d) Modify the members of the app workspace.
06. You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to ensure that all the visualization in the report can be consumed by users. Which two types of visualizations should you exclude horn the report?
Each correct answer presents part of the solution.
a) funnel charts
b) custom visuals
c) bubble maps
d) breadcrumbs
e) R visuals
07. You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data Which data source you should use?
a) Microsoft Azure Data Lake Store
b) Microsoft Azure Table Storage
c) Microsoft Azure HD lnsight
d) Microsoft Azure SQL Database
08. You have an on-premises Power BI Report Server. You plan to create a report in Power BI Desktop and to 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
09. 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?
a) the application token and the report URL
b) the report URL and a user name
c) the app workspace name and the access key
d) the access key and the report ID
10. You have a app workspace named Retail Store 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 Power BI Admin portal, click Tenant settings
d) From the Office 365 Admin center, click Groups
Answers:-
Answer 1 :- C
Answer 2 :- D
Answer 3 :- D
Answer 4 :- C
Answer 5 :- D
Answer 6 :- D, E
Answer 7 :- A
Answer 8 :- C
Answer 9 :- C
Answer 10:- C
Bình luận