microsoft analyzing and visualizing data microsoft power bi 70 778 certification sample
Free Power BI Exam Questions
Here goes the Quiz:
Rita’s company has training videos that are published to Microsoft Stream.
She needs to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should Rita add?
a. Web content
b. Text Box
c. Custom streaming data
d. video
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
a. show whitespace
b. Column profile
c. Column distribution
d. Column quality
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
First name
Last name
Email address
State/Region
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
a. Open the Advanced Editor.
b. Select Column quality.
c. Enable Column profiling based on the entire dataset.
d. Select Column distribution.
e. Select Column profile.
You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
a. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
b. Create a parameter and update the queries to use the parameter.
c. Create a query for each database server and hide the development tables.
d. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
a. Change the data type of the Logged column to Date
b. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
c. Apply a transform to extract the first 11 characters of the Logged column.
d. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
a. Add a SQL statement.
b. Set Data Connectivity mode to DirectQuery.
c. Set the Command timeout in minutes setting.
d. Set Data Connectivity mode to Import.
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
a. Merge tables by using Power Query.
b. Split the model into multiple models.
c. Hide unused columns in the model.
d. Transpose
You are configuring a Microsoft Power BI data model to enable users to ask natural language questions by using Q&A.
You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for “subscriber count” by using Q&A. The solution must minimize the size of the model.
What should you do?
a. Set Summarize By to None for the CustomerID column.
b. Add a synonym of “subscriber” to the Customer table.
c. Add a synonym of “subscriberID” to the CustomerID column.
d. Add a description of “subscriber count” to the Customer Count measure.
You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
a. Change the Microsoft Power BI license type of the sales manager.
b. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.
c. Request that the sales manager be added to the correct Azure Active Directory group.
d. Manage the permissions of the underlying dataset.
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?
a. stacked area chart
b. donut chart
c. line chart
d. waterfall chart.
Check if your answers are correct or not here:
c.
Explanation: The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source.
d.
Explanation: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.
d & e.
Explanation: Data Profiling, Quality & Distribution in Power BI / Power Query features
To enable these features, you need to go to the View tab à Data Preview Group Ã
d.
Explanation: With privacy level settings, you can specify an isolation level that defines the degree that one data source must be isolated from other data sources.
An Organizational data source limits the visibility of a data source to a trusted group of people. An Organizational data source is isolated from all Public data sources but is visible to other Organizational data sources.
c.
Explanation: With Power Query you can Split Date and Time into Separate Columns by using a transform
b.
Explanation: With Power BI Desktop, when you connect to your data source, it’s always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
a.
Explanation: Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you would like to add to another query, you merge the queries.
b.
Explanation: You can add synonyms to tables and columns.
Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
c.
Explanation: Using AD Security Groups, you no longer need to maintain a long list of users.
All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.
c.
Explanation: A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time “” a time series “” thus the line is often drawn chronologically.
More sample questions are coming up, so keep checking. Please share your feedback in the below comments section.
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) PARALELLPERIOD
b) SAMEPERIODLASTYEAR
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 the Import Data Connectivity mode.
c) Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.
d) Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery 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 from 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 an app workspace named Retail Store Analysis in the Power BI service. You need to manage the members that have access to the app workspace using the least amount of administrative effort. 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:
Question: 01
Answer: c Question: 02
Answer: b Question: 03
Answer: c Question: 04
Answer: c Question: 05
Answer: d
Question: 06
Answer: d, e Question: 07
Answer: a Question: 08
Answer: c Question: 09
Answer: c Question: 10
Answer: d
Disclaimer: These questions are NOT appearing in the certification exam. I personally or Enrollmytraining do not have any official tie-up with Microsoft regarding the certification or the kind of questions asked. These are my best guesses for the kind of questions to expect with Microsoft in general and with the examination.
power bi online training batch starts at weekend .You can enroll on your flexible timing
Power BI online training batch starts at weekend. You can enroll on your flexible timing.
Power BI training, Power BI tutorial, Power BI device manager, Power BI best practices, Power BI online training, Power BI security training, Power BI jobs in hyderabad, Power BI training in hyderabad, Power BI jobs in chennai, Power BI openings in pune, Power BI certification, Power BI course content, Power BI online training from india, Power BI developer jobs in india, Power BI administration training, Power BI training in bangalore, Power BI training online.
