DA100 - Practice Test QUESTIONS &
ANSWERS 100% CORRECT
Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server
databases contain the same tables. What's the easiest way to swap connection between the 2 dbs?
- Answers:in the Power Query editor, by going to Home> Data source settings, it is possible to
update the origin of the data for the whole model you are working on.
When you use the Pivot feature, you have to take care of the ____ Value Functions displayed in
the ______options - Answers:When you use the Pivot feature, you have to take care of the
Aggregate Value Functions displayed in the Advanced options
As opposed to Text.Replace, _______ replaces an existing value with a new value in the
specified columns of a table. - Answers:Table.ReplaceValue
In order to make sure a table contains no duplicates, what 2 methods can you use? -
Answers:Click on Remove Duplicates on the table columns
Add an Index column to the table making all rows unique
In order to use R scripting in Power BI, you must first download ___. - Answers:Download
Microsoft R. Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It
is a complete open source platform for statistical analysis and data science.
Two visuals have help identify possible causes for data anomalies is ____ and ___. -
Answers:Key Influencer and Decomposition tree visuals
You plan to create a custom visualization for Power BI. What do you install first? -
Answers:Node.js. The language you use to create a custom visual is JavaScript. Node.js is an
open-source, cross-platform, back-end JavaScript runtime environment that runs on the V8
engine and executes JavaScript code outside a web browser.
Where do you go to add synonyms to the Q&A? In Power BI ___ in the ___ tab's _____ pane. -
Answers:You add Q&A synonyms in Power BI Desktop in the Modeling tab's Properties pane.
ANSWERS 100% CORRECT
Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server
databases contain the same tables. What's the easiest way to swap connection between the 2 dbs?
- Answers:in the Power Query editor, by going to Home> Data source settings, it is possible to
update the origin of the data for the whole model you are working on.
When you use the Pivot feature, you have to take care of the ____ Value Functions displayed in
the ______options - Answers:When you use the Pivot feature, you have to take care of the
Aggregate Value Functions displayed in the Advanced options
As opposed to Text.Replace, _______ replaces an existing value with a new value in the
specified columns of a table. - Answers:Table.ReplaceValue
In order to make sure a table contains no duplicates, what 2 methods can you use? -
Answers:Click on Remove Duplicates on the table columns
Add an Index column to the table making all rows unique
In order to use R scripting in Power BI, you must first download ___. - Answers:Download
Microsoft R. Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It
is a complete open source platform for statistical analysis and data science.
Two visuals have help identify possible causes for data anomalies is ____ and ___. -
Answers:Key Influencer and Decomposition tree visuals
You plan to create a custom visualization for Power BI. What do you install first? -
Answers:Node.js. The language you use to create a custom visual is JavaScript. Node.js is an
open-source, cross-platform, back-end JavaScript runtime environment that runs on the V8
engine and executes JavaScript code outside a web browser.
Where do you go to add synonyms to the Q&A? In Power BI ___ in the ___ tab's _____ pane. -
Answers:You add Q&A synonyms in Power BI Desktop in the Modeling tab's Properties pane.
