1. You want to create a model to predict sales of ice cream based on historic data that includes daily ice cream sales totals and weather measurements. Which Azure service should you use?
o Azure Machine Learning
o Azure
Bot
o Language
Answer: Azure Machine Learning:That is correct. Azure Machine
Learning enables you to train a predictive model from the existing data..
2.
You are
designing an AI application that uses images to detect cracks in car
windshields and warn drivers when a windshield should be repaired or replaced.
What AI workload is described?
o
Computer Vision
o Anomaly Detection
o Natural Language Processing
Answer: Computer Vision: That is correct. Images of the
car windshield can be analyzed with computer vision and classified into groups
based on windshield condition.
3.
A
predictive app provides audio output for visually impaired users. Which
principle of Responsible AI is reflected here?
o
Transparency
o
Inclusiveness
o
Fairness
Answer: Inclusiveness: That is correct. Inclusiveness
is about how AI should bring benefits to all parts of society, regardless of
physical ability, gender, sexual orientation, ethnicity, or other factors.
4.
An
automobile dealership wants to use historic car sales data to train a machine
learning model. The model should predict the price of a pre-owned car based on
its make, model, engine size, and mileage. What kind of machine learning model
should the dealership use automated machine learning to create?
o Classification
o Regression
o Time series forecasting
Correct Answer: Regression: To predict a numeric value, use
a regression model.
5.
A bank
wants to use historic loan repayment records to categorize loan applications as
low-risk or high-risk based on characteristics like the loan amount, the income
of the borrower, and
the loan period. What kind of machine learning model should the bank use
automated machine learning to create?
o
Classification
o Regression
o Time
series forecasting
Correct Answer: Classification: Correct. To predict a category,
or class, use a classification model.
6.
You want
to use automated machine learning to train a regression model with the best
possible R2 score. How should you configure the automated machine learning
experiment?
o
Set the Primary
metric to R2 score
o
Block all
algorithms other than
o
GradientBoosting
o
Enable
featurization
Correct. Answer: Set the Primary
metric to R2 score:The
primary metric determines the metric used to evaluate the best performing
model.
7.
In Azure
Machine Learning studio, what can you use to author regression machine learning
pipelines using a drag-and-drop interface?
o
Notebooks
o
Automated
machine learning
o
Designer
Correct: Designer: You can use Designer to author
regression pipelines with a drag-and-drop interface.
8.
You are
creating a training pipeline for a regression model. You use a dataset that has
multiple numeric columns in which the values are on different scales. You want
to transform the numeric columns so that the values are all on a similar scale.
You also want the transformation to scale relative to the minimum and maximum
values in each column. Which module should you add to the pipeline?
o
Select
Columns in a ataset
o
Clean
Missing Data
o
Normalize Data
Correct: Normalize Data: When you transform numeric data
to be on a similar scale, use a Normalize Data module.
9. Why do
you split data into training and validation sets?
o
Data is
split into two sets in order to create two models, one model with the training
set and a different model with the validation set.
o
Splitting data into
two sets enables you to compare the labels that the model predicts
with the actual known labels in the original dataset.
o
Only
split data when you use the Azure Machine Learning Designer, not in other
machine learning scenarios.
Correct: Splitting data into two
sets enables you to compare the labels that the model
predicts with the actual known
labels in the original dataset: You want to test the model created with training
data on validation data to see how well the model performs with data it was not
trained on.
10.You're using Azure Machine Learning designer to
create a training pipeline for a binary classification model. You've added a
dataset containing features and labels, a Two-Class Decision Forest module, and
a Train Model module. You plan to use Score Model and Evaluate Model modules to
test the trained model with a subset of the dataset that wasn't used for
training. What's another module should you add?
o
Join Data
o
Split Data
o
Select
Columns in Dataset
Correct Answer: Split Data: Use a Split Data module to
randomly split a dataset into training and validation subsets.
11.
You use
an Azure Machine Learning designer pipeline to train and test a binary
classification model. You review the model's performance metrics in an Evaluate
Model module, and note that it has an AUC score of 0.3. What can you conclude
about the model?
o
The model
can explain 30% of the variance between true and predicted labels. o The model predicts accurately for 70% of test cases.
o The model performs worse than random guessing.
Correct:The model performs worse
than random guessing :An AUC
of 0.5 is what you'd expect with random prediction of a binary model.
12.
You use
Azure Machine learning designer to create a training pipeline for a
classification model. What must you do before deploying the model as a service?
o
Create an inference
pipeline from the training pipeline
o Add an Evaluate Model module to the training pipeline o Clone the training pipeline with a different name
Correct:
Create an inference pipeline from the training pipeline: You must create an inference
pipeline to deploy as a service
13.
You are
using an Azure Machine Learning designer pipeline to train and test a K-Means
clustering model. You want your model to assign items to one of three clusters.
Which configuration property of the K-Means Clustering module should you set to
accomplish this?
o
Set Number of
Centroids to 3
o Set Random number seed to 3
o Set Iterations to 3
Correct:
Set Number of Centroids to 3:To create K clusters, you must set the number of
centroids to K
14.
You use
Azure Machine Learning designer to create a training pipeline for a clustering
model. Now you want to use the model in an inference pipeline. Which module
should you use to infer cluster predictions from the model?
o Score Model
o
Assign Data to
Clusters
o Train Clustering Model
Correct Answer: Assign Data to
Clusters: use the
Assign Data to Clusters module to generate cluster predictions from a trained
clustering model
Knowledge check
15.
You want
to use the Computer Vision service to analyze images. You also want to use the
Language service to analyze text. You want developers to require only one key
and endpoint to access all of your services. What kind of resource should you
create in your Azure subscription?
o
Computer
Vision
O Cognitive
Services
o Custom Vision
Correct: Cognitive Services: A Cognitive Services resource
supports both Computer Vision and Language.
16.
You want
to use the Computer Vision service to identify the location of individual items
in an image. Which of the following features should you retrieve?
o
Objects
o
Tags
o
Categories
Correct Answer: Objects: Computer Vision returns objects
with a bounding box to indicate their location in the image.
17.
You want
to use the Computer Vision service to analyze images of locations and identify
well-known buildings. What should you do?
o
Retrieve
the objects in the image.
o
Retrieve
the categories for the image, specifying the celebrities’ domain.
o
Retrieve the
categories for the image, specifying the landmarks domain.
Correct Answer: Retrieve the
categories for the image, specifying the landmarks domain:-The landmarks domain includes
many well-known buildings around the world.
18.
You plan
to use the Custom Vision service to train an image classification model. You
want to create a resource that can only be used for model training, and not for
prediction. Which kind of resource should you create in your Azure
subscription?
o
Custom Vision
o
Cognitive
Services
o
Computer
Vision
Correct Answer: Custom Vision: When you create a Custom Vision
resource, you can specify whether it is to be used for training, prediction, or
both.
19.
You train
an image classification model that achieves less than satisfactory evaluation
metrics. How might you improve it?
o
Reduce
the size of the images used to train the model.
o Add a new label for "unknown" classes.
o Add more images to the training set.
Correct Answer: Add more images to the training set:Generally, adding more images
to the project and retraining the model is likely to improve performance.
20.
You have
published an image classification model. What information must you provide to
developers who want to use it?
o
Only the
project ID.
o
The project ID, the
model name, and the key and endpoint for the prediction resource
o
The
project ID, iteration number, and the key and endpoint for the training
resource.
Correct Answer: The project ID, the model name, and the key and endpoint for the
prediction resource: To use a published model, you need the project ID, the
model name, and the key and endpoint for the prediction resource.
21.
Which of
the following results does an object detection model typically return for an
image?
o A class label and probability score for the
image
o Bounding box coordinates that indicates the region of the image where
all of the objects it contains are located
o A class label, probability, and bounding box for each object in the
image
Correct answer: A class label, probability, and bounding box for each
object in the image: An
object detection model predicts a class label, probability, and bounding box
for each object in the image
22.
You plan
to use a set of images to train an object detection model, and then publish the
model as a predictive service. You want to use a single Azure resource with the
same key and endpoint for training and prediction. What kind of Azure resource
should you create?
o
Cognitive Services
o Custom Vision
o Computer Vision
Correct answer: Cognitive
services: A cognitive services resource can be used for both training and
prediction.
Knowledge check
23.
You plan
to use Face to detect human faces in an image. How does the service indicate
the location of the faces it detects?
o
A pair of
coordinates for each face, indicating the center of the face
o
Two pairs
of coordinates for each face, indicating the location of the eyes
o
A set of
coordinates for each face, defining a rectangular bounding box around the face
Correct: The locations of
detected faces are indicated by coordinates for a rectangular bounding box
24.
What is
one aspect that may impair facial detection?
o Glasses
o Extreme
angles
o Fast shutter speed
Correct Answer: Best results are
obtained when the faces are full-frontal or as near as possible to full-frontal
25.You
want to extract text from images and then use the Language service to analyze
the text. You want developers to require only one key and endpoint to access
all of your services. What kind of resource should you create in your Azure
subscription?
o
Computer
Vision
o Cognitive
Services
o Language
Correct. A Cognitive Services resource supports both Computer Vision for
text extraction, and Language for text analytics.
26.
You plan
to use the Computer Vision service's Read API. What results can the Read API
provide?
o
Results arranged in
pages, lines, and words
o
Only the
bounding box coordinations
o
Results
arranged by pages that have photographs first, then pages that exclusively have
text
Correct: Results arranged in
pages, lines, and words: The Read API takes an image and extracts the words, organizing the
results by page and line.
27.
You plan
to use the Form Recognizer pre-built receipt model. Which kind of Azure
resource should you create?
o
Computer
Vision resource
o
Form Recognizer or
Cognitive Services resource
o Only Form Recognizer resource
Correct: Form Recognizer or
Cognitive Services resource: Both the Form Recognizer resource and Cognitive
Services resource provide access to the Form Recognizer service
28.
You are
using the Form Recognizer service to analyze receipts that you have scanned
into JPG format images. What is the maximum file size of JPG file you can
submit to the pre-built receipt model?
o
2 MB
o
50 MB
o 200 MB
Correct answer: 50 MB: The maximum file size for the
pre-built receipt model is 50 MB
29.
You want to use the Language
service to determine the key talking points in a text document. Which feature
of the service should you use?
o
Sentiment
analysis
o
Key phrase
extraction
o Entity detection
Correct Answer: Key phrase
extraction:- Key
phrases can be used to identify the main talking points in a text document.
30.
You use the Language service to
perform sentiment analysis on a document, and a score of 0.99 is returned. What
does this score indicate about the document sentiment?
o
The document is
positive.
o The document is neutral.
o The document is negative.
Correct Answer: The document is
positive:- Score
values closer to 1 indicated a more positive sentiment where scores closer to 0
indicated negative sentiment.
31.
When might you see NaN returned
for a score in Language Detection?
o When the score calculated by the service is
outside the range of 0 to 1
o When the
predominant language in the text is mixed with other languages
o When the language is
ambiguous
Correct Answer: When the language
is ambiguous:- The
service will return NaN when it cannot determine the language in the provided
text.
32.
You plan
to build an application that uses the Speech service to transcribe audio
recordings of phone calls into text, and then submits the transcribed text to
the Language service to extract key phrases. You want to manage access and
billing for the application services in a single Azure resource. Which type of
Azure resource should you create?
o
Speech
o Language
o Cognitive Services
Correct Answer: Cognitive
Services:- This
resource would support both the Speech and Language services.
33.
You want
to use the Speech service to build an application that reads incoming email
message subjects aloud. Which API should you use?
o
Speech-to-Text
o Text-to-Speech
o Translate
Correct Answer: Text-to-Speech:-. The Text-to-Speech API converts
text to audible speech.
34.
You are
developing an application that must take English input from a microphone and
generate a real-time text-based transcription in Hindi. Which service should
you use?
o
Translator
o Speech
o Language
Correct-Speech: - The Speech service can translate
from audio sources to text.
35.
You need
to use the Translator service to translate email messages from Spanish into
both English and French. What is the most efficient way to accomplish this
goal?
o
Make a single call
to the service; specifying a "from" language of "es", a
"to" language of "en", and another "to" language of "fr".
o
Make a single call to the service; specifying
a "from" language of "es", and a "to" language of
"en-fr".
o
Make two
calls to the service; one with a "from" language of "es"
and a "to" language of "en", and another with a
"from" language of "es" and a "to" language of
"fr"
CorrectAnswer:- Make a single
call to the service; specifying a "from" language of "es",
a "to" language of "en", and another "to"
language of "fr":- You can specify a single "from" language
and multiple "to" languages.
36.
You need
to provision an Azure resource that will be used to author a new Language
Understanding application. What kind of resource should you create?
o
Custom
Language service
o Language
service
o Cognitive Services
Correct- Language service:- To author a Conversational
Language Understanding model, you need a Language resource.
37.
You are
authoring a Conversational Language Understanding application to support an
international clock. You want users to be able to ask for the current time in a
specified city, for example "What is the time in London?". What
should you do?
o
Define a
"city" entity and a "GetTime" intent with utterances that
indicate the city
intent.
o
Create an
intent for each city, each with an utterance that asks for the time in that
city.
o Add the utterance "What time is it in city" to the
"None" intent.
Correct Answer: Define a
"city" entity and a "GetTime" intent with utterances that
indicate the city intent:-. The intent encapsulates the task (getting the time) and the entity
specifies the item to which the intent is applied (the city).
38.
You have
published your Conversational Language Understanding application. What
information does a client application developer need to get predictions from
it?
o
The endpoint and
key for the application's prediction resource
o The endpoint and key for the
application's authoring resource
o
The Azure
credentials of the user who published the Language Understanding application
Correct- The endpoint and key for
the application's prediction resource:- Client applications must connect to the endpoint
of the prediction resource, specifying an associated authentication key.
39.
Your
organization has an existing frequently asked questions (FAQ) document. You
need to create a knowledge base that includes the questions and answers from
the FAQ with the least possible effort. What should you do?
o
Create an
empty knowledge base, and then manually copy and paste the FAQ entries into it.
o
Import the existing
FAQ document into a new knowledge base.
o Import a pre-defined
chit-chat data source.
Correct Answer- Import the
existing FAQ document into a new knowledge base:- You can import question and
answer pairs from an existing FAQ document into a question answering knowledge
base.
40.
You want
to create a knowledge base for bots. What service would you use?
o Conversational
Language Understanding
o Question Answering
o Azure Bot
41.
You need
to deliver a support bot for internal use in your organization. Some users want
to be able to submit questions to the bot using Microsoft Teams, others want to
use a web chat interface on an internal web site. What should you do?
o
Create a knowledge
base. Then create a bot for the knowledge base and connect the
o
Create a
knowledge base. Then create two bots that use the same knowledge base - one
bot connected to the Microsoft Teams channel, and
the other to the Web Chat channel.
o
Create
two knowledge bases with the same question and answer pairs. Then create a bot
for each knowledge base; one connected to the Microsoft Teams channel, and the
other to the Web Chat channel
Correct
Answer: The Microsoft Teams channel enables your bot to receive and respond to
messages in Microsoft Teams, and the Web Chat channel enables interactions
through a web chat interface.
42.
What is
meant by seasonal data?
o Data based on the time or year it was
recorded.
o
How far
apart the values are by default for each recorded period.
o Data
occurring at regular intervals.
Correct. Seasonal times series is
considered to be a pattern in your data that occurs at regular intervals.
Examples would be hourly, daily, or monthly patterns.
43.
What is
the purpose of specifying granularity in your JSON data object?
o It is used to indicate the recording pattern of the data.
o It tells the service how to chunk up the results that are returned for
review, independent of the time series data pattern.
o It is used to indicate the range of
acceptable values.
Correct
Answer: Granularity
would be specified as hourly, daily, weekly, etc.
44.
How does
the Anomaly Detector service evaluate real-time data for anomalies?
o It
collects all the values in a window of time and evaluates them all at once.
o It evaluates the current
value against the previous value.
o It uses interpolation based on the current value and the previous value
to predict what the expected value should be.
Correct
Answer. It
evaluates previously seen data points to determine if your latest one is an
anomaly
45.
Which
data format is accepted by Azure Cognitive Search when you're pushing data to
the index?
o
CSV.
o SQL.
o JSON.
Correct Answer JSON:- Cognitive Search can index
JSON documents. JSON is also used to define index schemas, indexers, and data
source objects.
46.
Which
explanation best describes an indexer and an index?
o An
indexer converts documents into JSON and forwards them to a search engine for
indexing.
o An
indexer can be used instead of an index if the files are already in the proper
format. o An indexer is only used for AI
enrichment and skillset execution.
Correct Answer: An indexer serializes a source
document into JSON before passing it to a search engine for indexing. An
indexer automates several steps of data ingestion, reducing the amount of code
you need to write.
47.
If you
set up a search index without including a skillset, which would you still be
able to query?
o
Sentiment.
o
Text content.
o Image captions.
Correct Answer. Cognitive Search is used for
full text search over indexes containing alphanumeric content.
Answer the following questions to
see what you've learned.
48.
Which
data role enables advanced analytics capabilities specifically through reports
and visualizations?
o
Data
scientist
o Data engineer
o Data
analyst
Correct
Answer:-A data analyst uses appropriate visuals to help business decision
makers gain deep and meaningful insights from data.
49. Which
data analyst task has a critical performance impact on reporting and data
analysis?
o
Model
o Analyze
o Visualize
Correct
Answer:- An optimized and tuned data model performs better and provides a
better data analysis experience.
50.
Which one
of the following options is the most important key benefit of data analysis?
o Decisive analytics
o Informed business
decisions
o Complex
reports
Correct
Answer:- A key benefit of data analysis is the ability to gain valuable
insights from a business's data assets to make timely and optimal business decisions.
Get
started with Power BI
51. What
is the common flow of activity in Power BI?
o
Create a
report in Power BI mobile, share it to the Power BI Desktop, view and interact
in the Power BI service.
o
Create a
report in the Power BI service, share it to Power BI mobile, interact with it
in Power BI Desktop.
o
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.
o
Bring
data into Power BI mobile, create a report, then share it to Power BI Desktop.
Answer:
The Power BI service lets you view and interact with reports and dashboards,
but doesn't let you shape data.
52. Which of the following are building blocks of Power BI?
o
Tiles,
dashboards, databases, mobile devices.
o
Visualizations,
datasets, reports, dashboards, tiles.
Answer: -
Building blocks for Power BI are visualizations, datasets, reports, dashboards,
tiles.
o
Visual
Studio, C#, and JSON files.
53.
A
collection of ready-made visuals, pre-arranged in dashboards and reports is
called what in Power
BI?
o
The
canvas.
o
Scheduled
refresh.
o An
app.
Answer:-
An app is a collection of ready-made visuals, pre-arranged in dashboards and
reports.
You can get apps that connect to
many online services from the AppSource.
54.
What type of expression do you
use to extract data from Microsoft SQL Server?
o DAX
o
MDX
o T-SQL
Correct Answer:-True. T-SQL is
the query language that you would use for SQL Server.
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?
o
Import
o
T-SQL
o
Live connection
Correct Answer:- Live
connection:-This will
reflect cube changes immediately.
56. What can you do to improve
performance when you're getting data in Power BI?
o
Use query folding
Correct Answer:- Power Query and Power Query
Editor are built to allow you to process the data, however, the processing
power required to do this might lower performance in other areas of your
reports. It's good practice to process as much as possible in the native data source
by using query folding.
o
Only pull
data into the Power BI service, not Power BI Desktop
o
Use the
Select SQL statement in your SQL queries when you're pulling data from a
relational database.
o
Combine
date and time columns into a single column
57.
What is a
risk of having null values in a numeric column?
o
That
function SUM of data will be incorrect.
o
That
function MAX of data will be incorrect.
o
That function
AVERAGE of data will be incorrect.
Correct Answer: AVERAGE takes the
total and divides by the number of non-null values. If NULL is synonymous with
zero in the data, the average will be different from the accurate average.
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?
o
Append
o
Merge
o
Combine
Column
Correct Answer: Append will take
two tables and combine it into one query. The combined query will have more
rows while keeping the same number of columns.
59.
Which of
the following selections are not best practices for naming conventions in Power
BI?
o
Rename
columns to have spaces in them.
o
Abbreviate column
names.
Correct
Answer: Abbreviations lead to confusion because they are often overused or not
universally agreed on.
o
Replace
values that have integers with human readable results.
60.
What does
data granularity mean?
o
Data
granularity is the filter direction that is associated with the relationship
between two columns.
o
Data granularity is
the level of detail that is represented in the data.
Correct answer: Data granularity
indicates the level the detail within the data, so the higher the granularity,
the more detail that is represented in the data.
o
Data
granularity is a many-to-many relationship.
o
Data
granularity is a type of schema design.
61.
What is
the difference between a fact table and a dimension table?
o
Fact tables contain
observational data while dimension tables contain information about specific
entities within the
data.
Correct Answer:-Fact tables
contain observational data such as sales orders, employees, shipping dates, and
so on, while dimension tables contain information about specific entities such
as product IDs and dates.
o
Fact
tables contain information about specific entities while dimension tables
contain information about observational data.
o
There is
no difference.
o
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?
o
Cardinality is the measure of
unique values in a table.
Correct
answer:-An example of high cardinality would be a Sales table as it has a high
number of unique values.
o
Cardinality
is the granularity of the data.
o
Cardinality
is how long it takes for the data to load.
o
Cardinality
is a type of visual element.
63.
Which two
functions will help you compare dates to the previous month?
o
CALCULATE and
PREVIOUSMONTH
Correct Answer: CALCULATE and
PREVIOUSMONTH help you compare dates to the previous month.
o
TOTALYTD
and PREVIOUS MONTH
o
CALCULATE
and TOTALTYD
64.
Why would
you want to override the default context?
o
To create measures
that behave according to your intentions, regardless of what the user selects.
Correct
Answer: You would want to override the default context to create measures that
behave according to your intentions, regardless of what the user selects.
o
To create
measures that does not summarize or average.
o To create new relationships.
65. How do you use an inactive relationship in a single measure?
o
Change
the active relationship in the Modeling tab.
o Use the
USERELATIONSHIP function.
Correct Answer: This function
will change which relationship is used in a single measure.
o
Delete
one relationship.
66.
What
benefit do you get from analyzing the metadata?
o
The benefit of
analyzing the metadata is that you can clearly identify data inconsistences
with your dataset.
Correct
Answer:The benefit of analyzing the metadata is that you can clearly identify
data inconsistences with your dataset.
o
The
benefit of analyzing the metadata is to get familiar with your data.
o
The
benefit of analyzing the metadata is to know the number of rows, columns and
tables being loaded into your model.
67.
What can
be achieved by removing unnecessary rows and columns?
o
It is not
necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
o
Deleting
unnecessary rows and columns will reduce a dataset size and its good practice
to load only necessary data
into your data model.
Correct
Answer:-Deleting unnecessary rows and columns will reduce a dataset size and
its good practice to load only necessary data into your data model.
o
Deleting
unnecessary rows and columns can damage the structure of the data model.
68.
Is it
possible to create a relationship between two columns if they are different
DATA TYPE columns?
o
Yes, if
cardinality of the relationship is set to Many-to-Many.
o
No, both columns in
a relationship must be sharing the same DATA TYPE.
Correct
Answer:-No, it is not possible to create a relationship between two columns if
they are different DATA TYPE columns. Both columns in a relationship must be
sharing the same DATA TYPE.
o
Yes, the
above is fully supported in latest version of Power BI desktop.
69.
What is
the benefit of using a report tooltip?
o
To give
users additional information about a report visual, such as the author and
date/time it was created.
o
To provide
additional detail that is specific to the context of the data that is being
hovered over.
Correct
Answer: The benefit of using a report tooltip is it provides additional detail
that is specific to the context of the data that is being hovered over.
o
To give
users the ability to export data from the visual.
70.
Which of
the following options isn't one of the four components in the Q&A
visualization?
o
The question
box, where users enter their question and are shown suggestions to help them
complete their question.
o
A
pre-populated list of suggested questions
o Automatic
creation of a custom tooltip
Correct
Answer:Automatic creation of a custom tooltip isn't one of the four components
in the Q&A visualization.
o
An icon
that users can select to convert the Q&A visual into a standard visual.
o
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?
o
No,
custom visuals are always available for selection under the Visualization pane.
o
yes, custom visuals
must be imported from AppSource each time you start developing a new report.
Correct
Answer:Custom visuals must be imported each time you start developing a new
report.
o
No,
custom visuals only need to be imported once and will always remain in Power BI
for future
72.
Which of
the following filters are not available in Power BI reports?
o
Drillthrough
o
Page type
Correct Answer: Page type filters
are not available in Power BI reports.
o
Report
level
o
Page
level
73.
How can
you analyze performance of each of your report elements?
o
By
analyzing your metadata
o
By using
performance analyzer
Correct Answer: Use performance
analyzer to analyze each of your report elements.
o
By
deleting unnecessary rows and columns to reduce your dataset size
74.
Can you
use bookmarks to create a slide show in Power BI?
o
No, you
cannot, because bookmarks are not dynamic.
o
Yes, you can, by adding buttons
as navigation to go between saved bookmarks.
Correct Answer:You can use
bookmarks to create a slide show in Power BI by adding buttons as navigation to
go between saved bookmarks.
o
No, you
will require a specific visual to achieve this task.
75.
what is a
dashboard?
o
A canvas
of report elements that can be built in Power BI Desktop
o
A canvas of report
elements that can be built in Power BI service
Correct Answer:Dashboards can
only be built in Power BI service.
o
Dashboards
can be built by using visuals that are developed with an underlying data source.
o
The
canvas in which you can view the data model of a report
76.
What is
one way that reports and dashboards differ?
o
They are
the same
o
In
reports, you can use the slicers and filter by selecting a data point on a
visual; in dashboards, you cannot.
o
In
reports, you can have multiple pages; in dashboards, you can have only one
page.
o You
can only build reports and dashboards in Power BI service.
Correct Answer: You can only
build dashboards in Power BI service.
77. Where
can you configure and set data alerts?
o
Data alerts can be
set only in Power BI service on specific visuals such as KPI cards, gauges, and
cards.
Correct Answer: Data alerts can
be set only in Power BI service on specific visuals.
o
Data
alerts can be set in both Power BI service and Power BI Desktop on any kind of visual.
o
Data
alerts can be set in Power BI service on any kind of visual.
o
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?
o They allow the report developer to control
the refresh interval of the report.
o They
allow the user to control aspects of how the report is rendered when the report
is run.
Correct
Answer: Parameters can be used in the report dataset, the report design
surface, and other places. Users insert values into the available parameters,
and the report author uses those values in the appropriate location in the
report.
o
They are
required so that Power BI can call the paginated report.
79.
Power BI
paginated reports are created by using which tool?
o
Power BI
Desktop
o
Power BI
service
o
Power BI Report
Builder
Correct Answer: They are only
built by using the Power BI Report Builder.
80. Power
BI paginated reports is an evolved technology that was built from which
original tool?
o
SQL
Server Analysis Services
o
SQL Server
Reporting Services
Correct
Answer: Power BI paginated reports was built from SQL Server Reporting
Services.
o
Microsoft
SharePoint
81.
What
Power BI feature can give an in-depth analysis of the distribution of data?
o
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.
o
The Analyze feature
allows a user to understand why the distribution looks the way that it does.
Correct Answer: The Analyze feature gives an in-depth analysis of the
distribution of data.
o
Only time
series analysis can provide in-depth analysis on the data.
82.
Where are
time series charts located?
o
The
filter pane is where all filters on visuals and pages are located.
o
Time series charts
can be imported from AppSource.
Correct Answer: Time series charts can be imported
from AppSource.
o
The
fields pane is where all charts are located.
83.
What
visual should be used to display outliers?
o
The line
chart is best-suited to display outliers.
o
The scatter chart is best-suited to display outliers.
Correct
Answer:The scatter chart displays outliers.
o
The
clustered column chart is best-suited to display outliers.
84.
What does
the AI splits feature do?
o
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.
o
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.
Correct
Answeer: 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.
o
AI splits
only display the difference between highest and lowest value of the measure
that is being analyzed.
85.
Can you
access the Q&A feature by using buttons?
o
No, to
use the Q&A feature, you will need to add the Q&A visual to your
reporting
canvas.
o
Yes, you can access
the Q&A feature by selecting Q&A button type.
Correct Answer:- Yes, you can
access the Q&A feature by selecting the Q&A button type.
o
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.
86.
Which of
the following selections is NOT a feature of the Q&A visual?
o
Adding
new synonyms to fields through Q&A tooling.
o
Converting
a Q&A answer into a visual inside your report.
o Searching
for help topics about Power BI.
Correct
Answer:- Searching for help topics about Power BI is not a feature of the
Q&A visual.
87. How is the Admin workspace
role different from other types of workspace roles?
o
Admin is the only
role that can remove users.
Correct Answer: Only Admins can
add and remove users from a workspace.
o
Admin is
the only role that can publish or update apps.
o
Admin is
the only role that can create, edit, or delete content in a workspace.
o
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?
o
A
workspace is a feature in Power BI service that allows you to view reports
only.
o
A
workspace is a feature of Power BI Desktop that allows you to build reports
only.
o
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.
Correct Answer: 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.
o
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?
o
Usage
Metrics report
o
Query
Caching
o Quick Insights
o Lineage
view
Correct Answer: Lineage view
allows you to view and troubleshoot the data flow from source to destination.
90. Where
are dataset-scheduled refreshes configured?
o
Power BI service
Correct Answer: Dataset-scheduled
refreshes are configured in Power BI service.
o
Power BI
Desktop
o AppSource
91.
What
reserved parameters configure the start and end of where Incremental refresh
should occur?
o StartRange and EndRange
o RangeStart
and RangeEnd
Correct Answer: RangeStart and
RangeEnd configure the start and end of where Incremental refresh should occur.
92.
What is
the difference between Promotion and Certification when you are endorsing a
dataset?
o
Promotion
requires write access while Certification requires permission from the dataset
owner to access to the dataset.
o
Promotion is for broad
usage while Certification needs permission granted on the Admin Tenant settings.
Correct
Answer: Promotion does not need specific permissions while Certification
requires permission from the dataset owner to access to the dataset.
o
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?
o
USERPRINCIPALNAME()
Correct Answer: The USERPRINCIPALNAME() function will tell you
which user is signed in to view a report.
o
LOOKUPVALUE()
o
USEROBJECTID()
94.
Where can you test RLS by using different security roles?
o
Power BI Desktop only
o
Power BI service only
o
Both Power BI
Desktop and Power BI service
Correct Answer: You
can use Power BI Desktop and Power BI service to test RLS.
No comments:
Post a Comment