power_bi_outset docx

Prévia do material em texto

Quiz 1
1. Which of the following types of data can you source into Power BI?
All the options
2. ______ is the processing unit of Hadoop, using which the data in Hadoop can be processed.
MapReduce
3. Which of the following are filters of Power BI?
All the options
4. Quick measures are generally are not supported when connected via DirectQuery.
TRUE
5. Which of the following is true about measure?
You can create a new measure by clicking on the New Measure button in the ribbon on Power BI Desktop’s Home tab
6. Which transform function would you use to operate the filename values into two separate columns, one for the filename and the other for the file extension? e.g., xml.
Split Column - Split at right-most delimiter
Quiz 2
1. In the formula,
Total Cost = Sum(‘Fact'[Cost]),
What sort of calculation should Total Cost be as per best practice?
Measure
2. What is not an option for suggested values when defining a parameter?
Table
3. What do you use to combine queries in Power BI?
Merge Queries
4. What visual would you use to display a single value?
Card
5. What is the M language function to sort a column in the query editor?
Table.Sort - incorrect
Quiz 3
1. R visuals are like any other visual in Power BI Desktop while interacting through filtering/highlighting.
TRUE
2. The expression language used in Power BI is __________________.
DAX
This study source was downloaded by 100000805987360 from CourseHero.com on 03-25-2021 08:28:05 GMT -05:00
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
3. We can refresh our reports through ________________.
Data Management Gateway and owner BI Personal gateway
4. What would be the DAX expression if you want to find if the employee is a bad hire (employee exists in the company for less than 61 days)?
IF((([TermDate]-[HireDate])*-1) >= 61,0,1)-incorrect
Slicer
5. What is a slicer?
It is an on-canvas visual filter.
Final Quiz
Try 1:
1. What visual would you use to display a single value?
Card
2. Which of the following visuals are not included as part of Power BI and must be included as custom visual?
Waterfall
3. Which of the following statements is false with respect to writing DAX expressions that reference Calculated Columns and Measures?
When referencing a measure in a DAX expression, you should prefer not to include table name.
4. Which of the following types of data can you source into Power BI?
All the options
5. Which of the following are filters of Power BI?
All the options
6. _______ area helps in navigating to various report pages.
Pages
7. How do you add a visual to a Dashboard in Power BI?
pin
8. When writing Dax expression for Calculated Measure, you can assume you DAX code automatically has which context for the table in which measure is defined
Row context
9. What is not an option for suggested values when defining a parameter?
Table
10. Which of the following DAX functions do not return a table?
Calculate
11. Which one is the basic building block of Power BI?
Dataset
12. The expression language used in Power BI?
DAX
13. In the formula
Total Cost = Sum(‘Fact'[Cost]),
What sort of calculation should Total Cost be as per best practice?
Measure
14. Basic flow in Power BI(Choose the best)
Get Data> Shape & Transform> Modelling> Visualizing
This study source was downloaded by 100000805987360 from CourseHero.com on 03-25-2021 08:28:05 GMT -05:00
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
15. What is the M language function to sort a column inquery editor?
Table.sort
16. Which Transform function would you use to operate the filename values into two separate columns, one for the filename and the other for the file extension? e.g., xml
Split Column - Split at Right-most delimiter
17. Select the different tools we have with Power BI.
All the options
18. Which data category setting will you use to geographically map column values to United States cities when the column contains values in the city-state format such as 
Dallas, TX and Tampa, FL?
City
19. When designing a query in Power BI Desktop to clean up data, what operation can be used to remove non-printable characters?
Trim(wrong), maybe sanitize
20. When designing a query in Power BI Desktop, what is the best datatype to use for column containing currency values?
Fixed Decimal number
Try 2:
21. Power BI has the capability to auto detect relations between tables based on column names
TRUE
22. What is the output of the below DAX expression? IF(ISLOGICAL(“true�), "Logical", "Illogical")
Illogical
23. What section do you go to transform and reshape data in Power BI?
Data editing
24. You can connect to both On-premises and Cloud sources within a single report
FALSE
25. You cannot edit or transform data once relations are established
FALSE
26. Which command in Power BI Desktop query editor is used to create a new query that uses the output of another query as its input source?
Reference
Try 3:
31. You can connect to both On-premises and Cloud sources within a single report
TRUE
32. What is not an option for suggested values when defining a parameter?
Query
33. Which data category setting will you use to geographically map column values to United States cities when the column contains values in the city-state format such as 
Dallas, TX and Tampa, FL?
State or province 
34. In the main Power BI Desktop window, which views can be used to create a new dimensional hierarchy?
Both Report and Data Views
35. Which Power BI visual is perfect for measuring performance against a target?
performer(wrong)
Try 4:
36. Which of the following is not a privacy level for a Power BI Data source
Protected
This study source was downloaded by 100000805987360 from CourseHero.com on 03-25-2021 08:28:05 GMT -05:00
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
What is an option to unpivot data in the query editor?
Unpivot columns
Power Map helps to see insights in 3-D map.
True
What is the shortcut to fill auto fill colour?
Alt+H+H
When designing a query in Power BI Desktop to clean up data, what operation can be used to 
remove non-printable characters?
Trim
Which visualization will you choose for cashflow during the ups and downs of all months in a 
financial year?
Waterfall chart
Which Power BI visual is perfect for measuring performance against a target?
Performer
When writing Dax expression for Calculated Column, you can assume you DAX code 
automatically has which context for the table in which column is defined
Column context
_______ area helps in navigating to various report pages.
Pages
You can connect to both On-premises and Cloud sources within a single report
True
Which of the following statements is false with respect to writing DAX expressions that 
reference Calculated Columns and Measures?
This study source was downloaded by 100000805987360 from CourseHero.com on 03-25-2021 08:28:05 GMT -05:00
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
When referencing a measure in a DAX expression, you should prefer not to include table name. – doubt
When referencing a measure in a DAX expression, you can optionally include the table name. 
Which of the following are filters of Power BI?
All the options
When writing Dax expression for Calculated Measure, you can assume you DAX code 
automatically has which context for the table in which measure is defined
Row contextWhat section do you go to transform and reshape data in Power BI?
Data Editing
Which visualization will you choose for cashflow during the ups and downs of all months in a 
financial year?
Waterfall chart
Which of the following DAX functions do not return a table?
Calculate
What visual would you use to display a single value?
Card – incorrect
Scatter plot
Select the different tools we have with Power BI.
All
Basic flow in Power BI(Choose the best)
Which command in Power BI Desktop query editor is used to create a new query that uses the 
output of another query as its input source?
Reference
This study source was downloaded by 100000805987360 from CourseHero.com on 03-25-2021 08:28:05 GMT -05:00
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
When designing a query in Power BI Desktop to clean up data, what operation can be used to 
remove non-printable characters?
Sanitize
When designing a query in Power BI Desktop, what is the best datatype to use for column 
containing currency values?
Fixed decimal number
When writing Dax expression for Calculated Column, you can assume you DAX code 
automatically has which context for the table in which column is defined
Row context
This study source was downloaded by 100000805987360 from CourseHero.com on 03-25-2021 08:28:05 GMT -05:00
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
Powered by TCPDF (www.tcpdf.org)
https://www.coursehero.com/file/69411736/power-bi-outsetdocx/
http://www.tcpdf.org