Term 1 of 24
Which of the following selections are not best practices for naming conventions in Power BI?
Rename columns to have spaces in them.
Abbreviate column names.
Replace values that have integers with human readable results.
Term 2 of 24
Do you need to import custom visuals each time you want to use them when you're
developing a new report, not an existing report?
No, custom visuals are always available for selection under the Visualization pane.
Yes, custom visuals must be imported from AppSource each time you start developing a
new report.
No, custom visuals only need to be imported once and will always remain in Power BI for
future use in a new report.
Term 3 of 24
What can you do to improve performance when you're getting data in Power BI?
Remove unnecessary columns and rows
Export database files to CSV to load
Combine date and time columns into a single column
Term 4 of 24
What is a risk of having null values in a numeric column?
That function SUM of data will be incorrect.
That function MAX of data will be incorrect.
That function AVERAGE of data will be incorrect.
,Term 5 of 24
What is cardinality?
Cardinality is the measure of unique values in a table.
Cardinality is the granularity of the data.
Cardinality is how long it takes for the data to load.
Cardinality is a type of visual element.
Term 6 of 24
Which one of the following options is the most important key benefit of data analysis?
Decisive analytics
Informed business decisions
Complex reports
Term 7 of 24
What is the difference between a fact table and a dimension table?
Fact tables contain observational data while dimension tables contain information about
specific entities within the data.
Fact tables contain information about specific entities while dimension tables contain
information about observational data.
There is no difference.
Dimension tables tell you about specific roles in Power BI while fact tables tell you
information about facts that are associated with those roles in Power BI.
Term 8 of 24
Which two functions will help you compare dates to the previous month?
CALCULATE and PREVIOUSMONTH
TOTALYTD and PREVIOUS MONTH
CALCULATE and TOTALTYD
, Term 9 of 24
Which data role enables advanced analytics capabilities specifically through reports and
visualizations?
Data scientist
Data engineer
Data analyst
Term 10 of 24
You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When
the data refreshes in the cube, you would like to see it immediately in the Power BI report. How
should you connect?
Import
T-SQL
Live connection
Term 11 of 24
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 will reduce a dataset size and its good practice
to load only necessary data into your data model.
Deleting unnecessary rows and columns can damage the structure of the data model.
Term 12 of 24
When connecting to a SQL Server database to get data, what language should you use to
extract data?
DAX
T-SQL
MDX
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper selftest. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor $9.00. Je zit daarna nergens aan vast.