1)
What is the
common flow of activity in Power BI?
a)
Create a report
in Power BI mobile, share it to the Power BI Desktop, view and interact in the
Power BI service.
b)
Create a report
in the Power BI service, share it to Power BI mobile, interact with it in Power
BI Desktop.
c)
Bring data into Power BI Desktop and create
a report, share it to the Power BI service, view and interact with reports and
dashboards in the service and Power BI
mobile.
d)
Bring data into
Power BI mobile, create a report, then share it to Power BI Desktop.
2)
Which of the
following are building blocks of Power BI?
a)
Tiles,
dashboards, databases, mobile devices.
b)
Visualizations, datasets, reports,
dashboards, tiles.
c)
Visual Studio,
C#, and JSON files.
d)
All of the above
53) A collection of ready-made visuals, pre-arranged
in dashboards and reports is called what in Power BI?
a)
The canvas.
b)
Scheduled
refresh.
c)
An app.
d)
All of the above
54)
What type of expression do you use to extract data from Microsoft SQL Server?
a)
DAX
b)
T-SQL
c)
MDX
d)
All of the above
55)
You're creating a Power BI report with data from an Azure Analysis Services
Cube. When the data refreshes in the cube, you would like to see it immediately
in the Power BI report. How should you connect?
a)
Import
b)
T-SQL
c)
Live connection
d)
All of the above
56)
What can you do to improve performance when you're getting data in Power BI?
a)
Use query folding
b)
Only pull data
into the Power BI service, not Power BI Desktop
c)
Use the Select
SQL statement in your SQL queries when you're pulling data from a relational
database.
d)
Combine date and
time columns into a single column
57)
What is a risk of having null values in a numeric column?
a)
That function SUM
of data will be incorrect.
b)
That function MAX
of data will be incorrect.
c)
That function AVERAGE of data will be
incorrect.
d)
All of the above
58)
If you have two queries that have different data but the same column headers,
and you want to combine both tables into one query with all the combined rows,
which operation should you perform?
a)
Append
b)
Merge
c)
Combine Column
d)
All of the above
59) Which of the following selections are not best
practices for naming conventions in Power BI?
a)
Rename columns to
have spaces in them.
b)
Abbreviate column names.
c)
Replace values
that have integers with human readable results.
d)
All of the above
60)
What does data granularity mean?
a)
Data granularity
is the filter direction that is associated with the relationship between two
columns.
b)
Data granularity is the level of detail that
is represented in the data.
c)
Data granularity
is a many-to-many relationship.
d)
Data granularity
is a type of schema design.
61)
What is the difference between a fact table and a dimension table?
a)
Fact tables contain observational data while
dimension tables contain information about specific entities within the data.
b)
Fact tables
contain information about specific entities while dimension tables contain
information about observational data.
c)
There is no
difference.
d)
Dimension tables
tell you about specific roles in Power BI while fact tables tell you
information about facts that are associated with those roles in Power BI.
62)
What is cardinality?
a)
Cardinality is the measure of unique values
in a table.
b)
Cardinality is
the granularity of the data.
c)
Cardinality is
how long it takes for the data to load.
d)
Cardinality is a
type of visual element.
63)
Which two functions will help you compare dates to the previous month?
a)
CALCULATE and PREVIOUSMONTH
b)
TOTALYTD and
PREVIOUS MONTH
c)
CALCULATE and
TOTALTYD
d)
All of the above
64)
Why would you want to override the default context?
a)
To create measures that behave according to
your intentions, regardless of what the user selects.
b)
To create
measures that do not summarize or average.
c)
To create new
relationships.
d)
All of the above
65)
How do you use an inactive relationship in a single measure?
a)
Change the active
relationship in the Modeling tab.
b)
Use the USERELATIONSHIP function.
c)
Delete one
relationship.
d)
All of the above
66)
What benefit do you get from analyzing the metadata?
a)
The benefit of analyzing the metadata is
that you can clearly identify data inconsistences with your dataset.
b)
The benefit of
analyzing the metadata is to get familiar with your data.
c)
The benefit of
analyzing the metadata is to know the number of rows, columns and tables being
loaded into your model.
d)
All of the above
67)
What can be achieved by removing unnecessary rows and columns?
a)
It is not
necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
b)
Deleting unnecessary rows and columns will
reduce a dataset size and its good practice to load only necessary data into
your data model.
c)
Deleting
unnecessary rows and columns can damage the structure of the data model.
d)
All of the above
68)
Is it possible to create a relationship between two columns if they are
different DATA TYPE columns?
a)
Yes, if
cardinality of the relationship is set to Many-to-Many.
b)
No, both columns in a relationship must be
sharing the same DATA TYPE.
c)
Yes, the above is
fully supported in latest version of Power BI desktop.
d)
All of the above
69)
What is the benefit of using a report tooltip?
a)
To give users
additional information about a report visual, such as the author and date/time
it was created.
b)
To provide additional detail that is
specific to the context of the data that is being hovered over.
c)
To give users the
ability to export data from the visual.
d)
All of the above
70)
Which of the following options isn't one of the four components in the Q&A
visualization?
a)
The question box,
where users enter their question and are shown suggestions to help them
complete their question.
b)
Automatic creation of a custom tooltip
c)
An icon that
users can select to convert the Q&A visual into a standard visual.
d)
An icon that
users can select to open Q&A tooling, which allows designers to configure
the underlying natural language engine.
71)
Do you need to import custom visuals each time you want to use them when you're
developing a new report, not an existing report?
a)
No, custom
visuals are always available for selection under the Visualization pane.
b)
Yes, custom visuals must be imported from
AppSource each time you start developing a new report.
c)
No, custom
visuals only need to be imported once and will always remain in Power BI for
future
d)
All of the above
72)
Which of the following filters are not available in Power BI reports?
a)
Drillthrough
b)
Page type
c)
Report level
d)
Page level
73)
How can you analyze performance of each of your report elements?
a)
By analyzing your
metadata
b)
By using performance analyzer
c)
By deleting
unnecessary rows and columns to reduce your dataset size
d)
All of the above
74)
Can you use bookmarks to create a slide show in Power BI?
a)
No, you cannot,
because bookmarks are not dynamic.
b)
Yes, you can, by adding buttons as
navigation to go between saved bookmarks.
c)
No, you will
require a specific visual to achieve this task.
d)
All of the above
75)
What is a dashboard?
a)
A canvas of
report elements that can be built in Power BI Desktop
b)
A canvas of report elements that can be
built in Power BI service
c)
Dashboards can be
built by using visuals that are developed with an underlying data source.
d)
The canvas in
which you can view the data model of a report
e)
What is one way
that reports and dashboards differ?
76)
They are the same
a)
In reports, you
can use the slicers and filter by selecting a data point on a visual; in
dashboards, you cannot.
b)
In reports, you
can have multiple pages; in dashboards, you can have only one page.
c)
You can only build reports and dashboards in
Power BI service.
77)
Where can you configure and set data alerts?
a)
Data alerts can be set only in Power BI
service on specific visuals such as KPI cards, gauges, and cards.
b)
Data alerts can
be set in both Power BI service and Power BI Desktop on any kind of visual.
c)
Data alerts can
be set in Power BI service on any kind of visual.
d)
Data alerts can
be set only in Power BI Desktop on specific kinds of visuals such as KPI cards
and gauges.
78)
Why are parameters important in Power BI paginated reports?
a)
They allow the
report developer to control the refresh interval of the report.
b)
They allow the user to control aspects of
how the report is rendered when the report is run.
c)
They are required
so that Power BI can call the paginated report.
d)
All of the above
79)
Power BI paginated reports are created by using which tool?
a)
Power BI Desktop
b)
Power BI service
c)
Power BI Report Builder
d)
All of the above
80)
Power BI paginated reports is an evolved technology that was built from which
original tool?
a)
SQL Server
Analysis Services
b)
SQL Server Reporting Services
c)
Microsoft
SharePoint
d)
All of the above
81)
What Power BI feature can give an in-depth analysis of the distribution of
data?
a)
The Next Level of
Hierarchy feature can give in-depth analysis because it will allow you to drill
down for all subcategories and is not used to analyze the distribution.
b)
The Analyze feature allows a user to
understand why the distribution looks the way that it does.
c)
Only time series
analysis can provide in-depth analysis on the data.
82)
Where are time series charts located?
a)
The filter pane
is where all filters on visuals and pages are located.
b)
Time series charts can be imported from
AppSource.
c)
The field’s pane
is where all charts are located.
d)
All of the above
83)
What visual should be used to display outliers?
a)
The line chart is
best-suited to display outliers.
b)
The scatter chart is best-suited to display
outliers.
c)
The clustered
column chart is best-suited to display outliers.
d)
All of the above
84)
What does the AI splits feature do?
a)
AI splits work by
considering all available fields and determining which one to drill into and
will only return the highest or lowest value within your dataset.
b)
AI splits work by considering all available
fields and determining which one to drill into to get the highest/lowest value
of the measure that is being analyzed.
c)
AI splits only
display the difference between highest and lowest value of the measure that is
being analyzed.
d)
All of the above
85)
Can you access the Q&A feature by using buttons?
a)
No, to use the
Q&A feature, you will need to add the Q&A visual to your reporting
canvas.
b)
Yes, you can access the Q&A feature by
selecting Q&A button type.
c)
Yes, you can, but
you will need to add the Q&A visual to your reporting canvas and then link
your button with the visual that you have added.
d)
All of the above
86)
Which of the following selections is NOT a feature of the Q&A visual?
a)
Adding new
synonyms to fields through Q&A tooling.
b)
Converting a
Q&A answer into a visual inside your report.
c)
Searching for help topics about Power BI.
d)
All of the above
87)
How is the Admin workspace role different from other types of workspace roles?
a)
Admin is the only role that can remove
users.
b)
Admin is
the only role that can publish or update apps.
c)
Admin is the only
role that can create, edit, or delete content in a workspace.
d)
Admin is the only
role that can publish content to a workspace.
88)
Which one of the following options is the best description of a workspace?
a)
A workspace is a
feature in Power BI service that allows you to view reports only.
b)
A workspace is a
feature of Power BI Desktop that allows you to build reports only.
c)
A workspace is a centralized location or
repository that allows you to collaborate with colleagues and teams to create
collections of reports, dashboards, and so on.
d)
A workspace is a
feature that allows you to view and edit the data model, build visualizations,
and transform the data.
89)
What feature in Power BI service can you use to troubleshoot the flow of data
from its source to its destination?
a)
Usage Metrics
report
b)
Query Caching
c)
Quick Insights
d)
Lineage view
90)
Where are dataset-scheduled refreshes configured?
a)
Power BI service
b)
Power BI Desktop
c)
AppSource
d)
All of the above
91)
What reserved parameters configure the start and end of where Incremental
refresh should occur?
a)
Start and End
parameters
b)
StartRange and
EndRange
c)
RangeStart and RangeEnd
d)
All of the above
92)
What is the difference between Promotion and Certification when you are
endorsing a dataset?
a)
Promotion
requires write access while Certification requires permission from the dataset
owner to access to the dataset.
b)
Promotion is for broad usage while
Certification needs permission granted on the Admin Tenant settings.
c)
Promotion is for
specific users while Certification needs permission granted on the Admin Tenant
settings.
93)
Which function will tell you the username of the person who is signed in to
Power BI service?
a)
USERPRINCIPALNAME()
b)
LOOKUPVALUE()
c)
USEROBJECTID()
d)
All of the above
94)
Where can you test RLS by using different security roles?
a)
Power BI Desktop
only
b)
Power BI service
only
c)
Both Power BI Desktop and Power BI service
d)
All of the above
95)
You have a project management app that is fully hosted in Microsoft Teams. The
app was developed by using Microsoft Power Apps.You need to create a Power BI
report that connects to the project management app. Which connector should you
select?
a)
Microsoft Teams
Personal Analytics
b)
SQL Server
database
c)
Dataverse
d)
Dataflows
96)
You are designing an AI system that empowers everyone, including people who
have hearing, visual, and other impairments. This is an example of which
Microsoft guiding principle for responsible AI?
a)
fairness
b)
inclusiveness
c)
reliability and
safety
d)
accountability
97)
You are building an AI system. Which task should you include to ensure that the
service meets the Microsoft transparency principle for responsible AI?
a)
Ensure that all
visuals have an associated text that can be read by a screen reader.
b)
Enable auto
scaling to ensure that a service scales based on demand.
c)
Provide documentation to help developers
debug code.
d)
Ensure that a
training dataset is representative of the population.
98)
A company employs a team of customer service agents to provide telephone and
email support to customers. The company develops a webchat bot to provide
automated answers to common customer queries. Which business benefit should the
company expect as a result of creating the web chat bot solution?
b)
a reduced workload for the customer service
agents
c)
improved product
reliability
d)
Set Primary
metric to accuracy
99)
You build a machine learning model by using the automated machine learning user
interface (UI). You need to ensure that the model meets the Microsoft
transparency principle for responsible AI. What should you do?
a)
Set Validation
type to auto.
b)
Enable Explain best model.
c)
Set Primary
metric to accuracy.
d)
Set Max
concurrent iterations to 0.
100)
What are three Microsoft guiding principles for responsible AI? Each correct
answer presents a complete solution. NOTE: Each correct selection is worth one
point.
a)
knowledgeability
b)
decisiveness
c)
inclusiveness
d)
opinionatedness
101)
Which two components can you drag onto a canvas in Azure Machine Learning
designer? Each correct answer presents a complete solution. NOTE: Each correct
selection is worth one point.
a)
dataset
b)
compute
c)
pipeline
d)
modeling
102)
For the sales department at your company, you publish a Power BI report that
imports data from a Microsoft Excel file located in a Microsoft SharePoint
folder.The data model contains several measures. You need to create a Power BI
report from the existing data. The solution must minimize development effort.
Which type of data source should you use?
a)
Power BI dataset
b)
a SharePoint folder
c)
Power BI
dataflows
d)
an Excel workbook
103)
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)
Apply a
transformation to extract the last 11 characters of the Logged column and set
the data type of the new column to Date.
b)
Change the data
type of the Logged column to Date.
c)
Split the Logged
column by using at as the delimiter.
d)
Apply a transformation to extract the first
11 characters of the Logged column.
104)
You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must
be imported to a Power BI dataset. You need to ensure that the dataset can be
refreshed in powerbi.com. Which two connectors can you use to connect to the
file? Each correct answer presents a complete solution.
a)
Web
b)
Text/CSV
c)
Folder
d)
SharePoint folder
105)
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 the Command
timeout in minutes setting.
c)
Set Data
Connectivity mode to Import.
d)
Set Data Connectivity mode to Direct Query.
106)
Your company has training videos that are published to Microsoft Stream.You
need to surface the videos directly in a Microsoft Power BI dashboard.Which
type of tile should you add?
a)
video
b)
custom streaming data
c)
text box
d)
web content
107)
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
108)
For a machine learning progress, how should you split data for training and
evaluation?
a)
Use features for
training and labels for evaluation.
b)
Randomly split
the data into rows for training and rows for evaluation. Most Voted
c)
Use labels for
training and features for evaluation.
d)
Randomly split the data into columns for
training and columns for evaluation.
109)
You build a machine learning model by using the automated machine learning user
interface (UI).You need to ensure that the model meets the Microsoft
transparency principle for responsible AI. What should you do?
a)
Set Validation
type to Auto.
b)
Enable Explain best model.
c)
Set Primary
metric to accuracy.
d)
Set Max concurrent
iterations to 0.
110)
SQL Stand For
a)
Structure Query Language
b)
Simple Query
Language
c)
Stand Query
Language
d)
Stack Queue
Language
111)
AI stands for
a)
Artificial Intelligence
b)
All information
c)
Art Information
No comments:
Post a Comment