POWE
POWER BI DA-100 EXAM QUESTIONS WITH
CORRECT VERIFIED SOLUTIONS 100%
GUARANTEED PASS (LATEST UPDATE)
What does managing entail for the data analyst? - ANS ✓Power BI consists of
many components, including reports, dashboards, workspaces, datasets, and
more. As a data analyst, you are responsible for the management of these Power
BI assets, overseeing the sharing and distribution of items, such as reports and
dashboards, and ensuring the security of Power BI assets.
How does data management reduce duplication of efforts? - ANS ✓Proper
management can also help reduce data silos within your organization. Data
duplication can make managing and introducing data latency difficult when
resources are overused. Power BI helps reduce data silos with the use of shared
datasets, and it allows you to reuse data that you have prepared and modeled.
For key business data, endorsing a dataset as certified can help to ensure trust in
that data.
The management of Power BI assets helps reduce the duplication of efforts
and helps ensure security of the data.
What is Microsoft Power BI? - ANS ✓Microsoft Power BI is a collection of
software services, apps, and connectors that work together to turn your
unrelated sources of data into coherent, visually immersive, and interactive
insights.
What is the common flow of activity for working in Power BI? - ANS ✓The
common flow of activity looks like this:
1. Bring data into Power BI Desktop, and create a report.
2. Publish to the Power BI service, where you can create new visualizations
or build dashboards.
POWER BI
,POWE
3. Share dashboards with others, especially people who are on the go.
4. View and interact with shared dashboards and reports in Power BI
Mobile apps.
What are the basic building blocks in Power BI? - ANS ✓Here are the basic
building blocks in Power BI:
-Visualizations
-Datasets
-Reports
-Dashboards
-Tiles
What is a visualization? - ANS ✓A visualization (sometimes also referred to as a
visual) is a visual representation of data, like a chart, a color-coded map, or other
interesting things you can create to represent your data visually.
What is the goal of a visual? - ANS ✓The goal of a visual is to present data in a
way that provides context and insights, both of which would probably be difficult
to discern from a raw table of numbers or text.
What is the role of data connectors in Power BI? - ANS ✓An important and
enabling part of Power BI is the multitude of data connectors that are included.
Whether the data you want is in Excel or a Microsoft SQL Server database, in
Azure or Oracle, or in a service like Facebook, Salesforce, or MailChimp, Power BI
has built-in data connectors that let you easily connect to that data, filter it if
necessary, and bring it into your dataset.
What is a Power BI report? - ANS ✓In Power BI, a report is a collection of
visualizations that appear together on one or more pages.
What is a Power BI dashboard? - ANS ✓When you're ready to share a single
page from a report, or a collection of visualizations, you create a dashboard.
Much like the dashboard in a car, a Power BI dashboard is a collection of visuals
POWER BI
,POWE
from a single page that you can share with others. Often, it's a selected group of
visuals that provide quick insight into the data or story you're trying to present.
What rules apply to Power BI dashboards? - ANS ✓A dashboard must fit on a
single page, often called a canvas (the canvas is the blank backdrop in Power BI
Desktop or the service, where you put visualizations).
How can you share Power BI dashboards? - ANS ✓You can share dashboards
with other users or groups, who can then interact with your dashboards when
they're in the Power BI service or on their mobile device.
What is a tile in Power BI? - ANS ✓In Power BI, a tile is a single visualization on
a report or a dashboard. It's the rectangular box that holds an individual visual.
In the following image, you see one tile, which is also surrounded by other tiles.
How do you connect data in Power BI? - ANS ✓With Power BI, connecting to
data is easy. From the Power BI service, you can just select the Get Data button in
the lower-left corner of the home page.
What is the canvas? - ANS ✓The canvas (the area in the center of the Power BI
service) shows you the available sources of data in the Power BI service. In
addition to common data sources like Microsoft Excel files, databases, or
Microsoft Azure data, Power BI can just as easily connect to a whole assortment
of software services (also called SaaS providers or cloud services): Salesforce,
Facebook, Google Analytics, and more.
What is an app? - ANS ✓Power BI's collection of visuals is called an app. Apps
get you up and running quickly, with data and dashboards that your organization
has created for you. For example, when you use the GitHub app, Power BI
connects to your GitHub account (after you provide your credentials) and then
populates a predefined collection of visuals and dashboards in Power BI.
How do you see what apps you can connect? - ANS ✓You select the Get button
in the Services box
POWER BI
, POWE
How do you update data in Power BI? - ANS ✓You can also choose to update
the dataset for an app, or other data that you use in Power BI. To set update
settings, select the schedule update icon for the dataset to update, and then use
the menu that appears. You can also select the update icon (the circle with an
arrow) next to the schedule update icon to update the dataset immediately.
How do you schedule datasets to refresh? - ANS ✓The Datasets tab is selected
on the Settings page that appears. In the right pane, select the arrow next to
Scheduled refresh to expand that section. The Settings dialog box appears on the
canvas, letting you set the update settings that meet your needs.
What are the basic building blocks of Power BI and their roles? - ANS ✓We
also discussed the basic building blocks in Power BI:
-Visualizations: A visual representation of data, sometimes just called
visuals
-Datasets: A collection of data that Power BI uses to create visualizations
-Reports: A collection of visuals from a dataset, spanning one or more pages
-Dashboards: A single-page collection of visuals built from a report
-Tiles: A single visualization on a report or dashboard
What is a flat file? - ANS ✓A flat file is a type of file that has only one data table
and every row of data is in the same structure. The file does not contain
hierarchies. Likely, you're familiar with the most common types of flat files,
which are comma-separated values (.csv) files, delimited text (.txt) files, and fixed
width files.
In what locations might your Excel files be located? - ANS ✓Your Excel files
might exist in one of the following locations:
Local: You can import data from a local file into Power BI.
OneDrive for Business: You can pull data from OneDrive for Business into
Power BI.
OneDrive Personal: You can use data from files on a personal OneDrive
account, and get many of the same benefits that you would with OneDrive
for Business.
POWER BI
POWER BI DA-100 EXAM QUESTIONS WITH
CORRECT VERIFIED SOLUTIONS 100%
GUARANTEED PASS (LATEST UPDATE)
What does managing entail for the data analyst? - ANS ✓Power BI consists of
many components, including reports, dashboards, workspaces, datasets, and
more. As a data analyst, you are responsible for the management of these Power
BI assets, overseeing the sharing and distribution of items, such as reports and
dashboards, and ensuring the security of Power BI assets.
How does data management reduce duplication of efforts? - ANS ✓Proper
management can also help reduce data silos within your organization. Data
duplication can make managing and introducing data latency difficult when
resources are overused. Power BI helps reduce data silos with the use of shared
datasets, and it allows you to reuse data that you have prepared and modeled.
For key business data, endorsing a dataset as certified can help to ensure trust in
that data.
The management of Power BI assets helps reduce the duplication of efforts
and helps ensure security of the data.
What is Microsoft Power BI? - ANS ✓Microsoft Power BI is a collection of
software services, apps, and connectors that work together to turn your
unrelated sources of data into coherent, visually immersive, and interactive
insights.
What is the common flow of activity for working in Power BI? - ANS ✓The
common flow of activity looks like this:
1. Bring data into Power BI Desktop, and create a report.
2. Publish to the Power BI service, where you can create new visualizations
or build dashboards.
POWER BI
,POWE
3. Share dashboards with others, especially people who are on the go.
4. View and interact with shared dashboards and reports in Power BI
Mobile apps.
What are the basic building blocks in Power BI? - ANS ✓Here are the basic
building blocks in Power BI:
-Visualizations
-Datasets
-Reports
-Dashboards
-Tiles
What is a visualization? - ANS ✓A visualization (sometimes also referred to as a
visual) is a visual representation of data, like a chart, a color-coded map, or other
interesting things you can create to represent your data visually.
What is the goal of a visual? - ANS ✓The goal of a visual is to present data in a
way that provides context and insights, both of which would probably be difficult
to discern from a raw table of numbers or text.
What is the role of data connectors in Power BI? - ANS ✓An important and
enabling part of Power BI is the multitude of data connectors that are included.
Whether the data you want is in Excel or a Microsoft SQL Server database, in
Azure or Oracle, or in a service like Facebook, Salesforce, or MailChimp, Power BI
has built-in data connectors that let you easily connect to that data, filter it if
necessary, and bring it into your dataset.
What is a Power BI report? - ANS ✓In Power BI, a report is a collection of
visualizations that appear together on one or more pages.
What is a Power BI dashboard? - ANS ✓When you're ready to share a single
page from a report, or a collection of visualizations, you create a dashboard.
Much like the dashboard in a car, a Power BI dashboard is a collection of visuals
POWER BI
,POWE
from a single page that you can share with others. Often, it's a selected group of
visuals that provide quick insight into the data or story you're trying to present.
What rules apply to Power BI dashboards? - ANS ✓A dashboard must fit on a
single page, often called a canvas (the canvas is the blank backdrop in Power BI
Desktop or the service, where you put visualizations).
How can you share Power BI dashboards? - ANS ✓You can share dashboards
with other users or groups, who can then interact with your dashboards when
they're in the Power BI service or on their mobile device.
What is a tile in Power BI? - ANS ✓In Power BI, a tile is a single visualization on
a report or a dashboard. It's the rectangular box that holds an individual visual.
In the following image, you see one tile, which is also surrounded by other tiles.
How do you connect data in Power BI? - ANS ✓With Power BI, connecting to
data is easy. From the Power BI service, you can just select the Get Data button in
the lower-left corner of the home page.
What is the canvas? - ANS ✓The canvas (the area in the center of the Power BI
service) shows you the available sources of data in the Power BI service. In
addition to common data sources like Microsoft Excel files, databases, or
Microsoft Azure data, Power BI can just as easily connect to a whole assortment
of software services (also called SaaS providers or cloud services): Salesforce,
Facebook, Google Analytics, and more.
What is an app? - ANS ✓Power BI's collection of visuals is called an app. Apps
get you up and running quickly, with data and dashboards that your organization
has created for you. For example, when you use the GitHub app, Power BI
connects to your GitHub account (after you provide your credentials) and then
populates a predefined collection of visuals and dashboards in Power BI.
How do you see what apps you can connect? - ANS ✓You select the Get button
in the Services box
POWER BI
, POWE
How do you update data in Power BI? - ANS ✓You can also choose to update
the dataset for an app, or other data that you use in Power BI. To set update
settings, select the schedule update icon for the dataset to update, and then use
the menu that appears. You can also select the update icon (the circle with an
arrow) next to the schedule update icon to update the dataset immediately.
How do you schedule datasets to refresh? - ANS ✓The Datasets tab is selected
on the Settings page that appears. In the right pane, select the arrow next to
Scheduled refresh to expand that section. The Settings dialog box appears on the
canvas, letting you set the update settings that meet your needs.
What are the basic building blocks of Power BI and their roles? - ANS ✓We
also discussed the basic building blocks in Power BI:
-Visualizations: A visual representation of data, sometimes just called
visuals
-Datasets: A collection of data that Power BI uses to create visualizations
-Reports: A collection of visuals from a dataset, spanning one or more pages
-Dashboards: A single-page collection of visuals built from a report
-Tiles: A single visualization on a report or dashboard
What is a flat file? - ANS ✓A flat file is a type of file that has only one data table
and every row of data is in the same structure. The file does not contain
hierarchies. Likely, you're familiar with the most common types of flat files,
which are comma-separated values (.csv) files, delimited text (.txt) files, and fixed
width files.
In what locations might your Excel files be located? - ANS ✓Your Excel files
might exist in one of the following locations:
Local: You can import data from a local file into Power BI.
OneDrive for Business: You can pull data from OneDrive for Business into
Power BI.
OneDrive Personal: You can use data from files on a personal OneDrive
account, and get many of the same benefits that you would with OneDrive
for Business.
POWER BI
