PowerBI Certification Exam
If you want your data to B) DirectQuery
automatically refresh as you
interact with visualizations, which Explanation: When you use DirectQuery, no data is imported into
option should you choose? Power BI Desktop. As you create or interact with a visualization,
A) Import PowerBI Desktop queries the underlying data source, i.e. you're
B) DirectQuery always viewing current data.
How do you connect to Excel A) Connect to the files with Folder connector and use the Combine
files that contain target figures? Binaries functionality.
The solution should involve
minimum manual work when new
Excel files are created. Explanation: Connecting to files separately will take time if there
are lots of files in the folder. Its always better to connect to folder if
A) Connect to the files with files have same structure. If you copy new files in that folder with
Folder connector and use the same structure, that file will be loaded automatically without
Combine Binaries functionality. doing any change to data sources.
B) Connect to a new file each
month, perform transformations,
and use Append function in
Power Query Editor to combine
all targets in the same table.
,Imagine that you have created C) Modify the Customers query by adding an index column.
a query named "Customers" in a
PowerBI Desktop to append the Explanation: Index column option is available in query editor to add
rowss from three external indexed column starting from 0, 1, or custom number.
tables with customer data into
a single output table named
"Customers".
What would be the best
approach to add a new
fabricated ID column to the
Customers table to ensure that
every row in the "Customers"
table contains a unique ID value?
A) Modify the Customer query by
adding a counter column.
B) Modify the data model by
extending the Customers table
with a Counter column.
C) Modify the customers query
by adding an index column.
D) Modifythe data model by
extending the Customers table
with an index column.
Which two of the following B) Denormalizing the data model to make it better suited for data
strategies are recommended analysis and reporting.
when designing the queries to
import data from an OLTP-style D) Refactoring the imported tables into a star schema.
database into a Power BI Desktop
project? Explanation: Denormalization and star schema is desired to
transform the data in the format that is best fit for visualizations.
A) Normalizing the data model to
make it better suited for data
analysis and reporting.
B) Denormalizing the data model
to make it better suited for data
analysis and reporting.
C) Refactoring the imported
tables into a multidimensional
cube.
, D) Refactoring the imported
tables into a star schema.
If you want your data to B) DirectQuery
automatically refresh as you
interact with visualizations, which Explanation: When you use DirectQuery, no data is imported into
option should you choose? Power BI Desktop. As you create or interact with a visualization,
A) Import PowerBI Desktop queries the underlying data source, i.e. you're
B) DirectQuery always viewing current data.
How do you connect to Excel A) Connect to the files with Folder connector and use the Combine
files that contain target figures? Binaries functionality.
The solution should involve
minimum manual work when new
Excel files are created. Explanation: Connecting to files separately will take time if there
are lots of files in the folder. Its always better to connect to folder if
A) Connect to the files with files have same structure. If you copy new files in that folder with
Folder connector and use the same structure, that file will be loaded automatically without
Combine Binaries functionality. doing any change to data sources.
B) Connect to a new file each
month, perform transformations,
and use Append function in
Power Query Editor to combine
all targets in the same table.
,Imagine that you have created C) Modify the Customers query by adding an index column.
a query named "Customers" in a
PowerBI Desktop to append the Explanation: Index column option is available in query editor to add
rowss from three external indexed column starting from 0, 1, or custom number.
tables with customer data into
a single output table named
"Customers".
What would be the best
approach to add a new
fabricated ID column to the
Customers table to ensure that
every row in the "Customers"
table contains a unique ID value?
A) Modify the Customer query by
adding a counter column.
B) Modify the data model by
extending the Customers table
with a Counter column.
C) Modify the customers query
by adding an index column.
D) Modifythe data model by
extending the Customers table
with an index column.
Which two of the following B) Denormalizing the data model to make it better suited for data
strategies are recommended analysis and reporting.
when designing the queries to
import data from an OLTP-style D) Refactoring the imported tables into a star schema.
database into a Power BI Desktop
project? Explanation: Denormalization and star schema is desired to
transform the data in the format that is best fit for visualizations.
A) Normalizing the data model to
make it better suited for data
analysis and reporting.
B) Denormalizing the data model
to make it better suited for data
analysis and reporting.
C) Refactoring the imported
tables into a multidimensional
cube.
, D) Refactoring the imported
tables into a star schema.
