Name: Score:
90 Multiple choice questions
Definition 1 of 90
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?
Change the data type of the Logged column to Date.
Apply the Parse function from the Date transformations options to the Logged column.
Create a column by example that starts with 2018-12-31 and set the data type of the new
column to Date.
Apply a transform to extract the first 11 characters of the Logged column.
Definition 2 of 90
Which technology improves performance by generating a single query statement to retrieve
and transform source data?
Query folding
Adding index columns
Adding custom columns with complex logic
Definition 3 of 90
Which of the following sources can Power BI connect to?
SQL Database
Google Analytics
R scripts
All of the above
,Definition 4 of 90
You have sales data in a star schema that contains four tables named Sales, Customer, Date,
and Product. The Sales table contains purchase and ship dates. Most often, you will use the
purchase date to analyze the data, but you will analyze the data by both dates independently
and together.
You need to design an imported dataset to support the analysis. The solution must minimize
the model size and the number of queries against the data source.
Which data modeling design should you use?
Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date
table.
Duplicate the Date query in Power Query and use active relationships between both
Date tables.
On the Date table, use a reference query in Power Query and create active relationships
between Sales and both Date tables in the modeling view.
Create an active relationship between Sales and Date for the purchase date and an
inactive relationship for the ship date.
Definition 5 of 90
When should you use DirectQuery?
The source data never changes
Company policy states no data source restrictions
Dataset is too large to be stored in-memory
All of the above
,Definition 6 of 90
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?
Create a JSON file that contains the database server names. Import the JSON file to the
dataset.
Create a parameter and update the queries to use the parameter.
Create a query for each database server and hide the development tables.
Set the data source privacy level to Organizational and use the ReplaceValue Power
Query M function.
Definition 7 of 90
What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
Deleting unnecessary rows and columns can damage the structure of the data model.
Deleting unnecessary rows and columns will reduce the dataset size and it is a good
practice to load only necessary data into your data model.
Definition 8 of 90
Based on the conditional column above, what Price Range value would be given to a
Unit_Price of 500?
Low
Mid
High
Unclassified
, Definition 9 of 90
Data profiling is defined as what?
Aggregating columns containing numeric data
Studying the nuances of the data
Data modeling
Definition 10 of 90
During your data QA process, you notice that there are null values in the Return type column
(Returned, No return, and null).
After talking with your manager, you decide to impute (replace) the null values with a value of
"No return".
Which of the following actions should you take?
Select the Return type column > Transform > Replace values
Select the Return type column > Transform > Fill down
Select the Return type column > Add column > Column from example
Select the Return type column > Home > Remove rows
90 Multiple choice questions
Definition 1 of 90
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?
Change the data type of the Logged column to Date.
Apply the Parse function from the Date transformations options to the Logged column.
Create a column by example that starts with 2018-12-31 and set the data type of the new
column to Date.
Apply a transform to extract the first 11 characters of the Logged column.
Definition 2 of 90
Which technology improves performance by generating a single query statement to retrieve
and transform source data?
Query folding
Adding index columns
Adding custom columns with complex logic
Definition 3 of 90
Which of the following sources can Power BI connect to?
SQL Database
Google Analytics
R scripts
All of the above
,Definition 4 of 90
You have sales data in a star schema that contains four tables named Sales, Customer, Date,
and Product. The Sales table contains purchase and ship dates. Most often, you will use the
purchase date to analyze the data, but you will analyze the data by both dates independently
and together.
You need to design an imported dataset to support the analysis. The solution must minimize
the model size and the number of queries against the data source.
Which data modeling design should you use?
Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date
table.
Duplicate the Date query in Power Query and use active relationships between both
Date tables.
On the Date table, use a reference query in Power Query and create active relationships
between Sales and both Date tables in the modeling view.
Create an active relationship between Sales and Date for the purchase date and an
inactive relationship for the ship date.
Definition 5 of 90
When should you use DirectQuery?
The source data never changes
Company policy states no data source restrictions
Dataset is too large to be stored in-memory
All of the above
,Definition 6 of 90
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?
Create a JSON file that contains the database server names. Import the JSON file to the
dataset.
Create a parameter and update the queries to use the parameter.
Create a query for each database server and hide the development tables.
Set the data source privacy level to Organizational and use the ReplaceValue Power
Query M function.
Definition 7 of 90
What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
Deleting unnecessary rows and columns can damage the structure of the data model.
Deleting unnecessary rows and columns will reduce the dataset size and it is a good
practice to load only necessary data into your data model.
Definition 8 of 90
Based on the conditional column above, what Price Range value would be given to a
Unit_Price of 500?
Low
Mid
High
Unclassified
, Definition 9 of 90
Data profiling is defined as what?
Aggregating columns containing numeric data
Studying the nuances of the data
Data modeling
Definition 10 of 90
During your data QA process, you notice that there are null values in the Return type column
(Returned, No return, and null).
After talking with your manager, you decide to impute (replace) the null values with a value of
"No return".
Which of the following actions should you take?
Select the Return type column > Transform > Replace values
Select the Return type column > Transform > Fill down
Select the Return type column > Add column > Column from example
Select the Return type column > Home > Remove rows
