Which of the following are covered in the 70-778 exam? (Choose three)
Modeling and visualizing data
Connecting and transforming data
Dashboards,
... [Show More] reports, and apps
Datasource maintenance and refresh schedules
Modeling and visualizing data
Connecting and transforming data
Dashboards, reports, and apps
Upon signing in to the Power BI web service, which of the following do you download?
A. Power BI Mobile
B. Power BI Desktop
C. Data Gateway
D. Power BI for Excel
Power BI Desktop
Which button loads the selected worksheet(s) into RAM? (Random Access Memory)
A. Open
B. Edit
C. Load
D. Import
Load
To provide a custom SQL query in your database connection, you must expand which window?
A. Import
B. Advanced
C. Query
D. Custom SQL
Advanced
Where can you add more users to be allowed to use the data gateway?
A. The Administrators tab under Manage Gateways
B. The Users tab under Manage Gateways
C. The Users tab of the Add Datasource page under your Gateway
D. The Dataset settings under each report
The Users tab of the Add Datasource page under your Gateway
Imported data connections allow for which of the following? (Choose three)
Faster performance
Up to the second visualization refreshes
No limitations to functionality
Data compression
Faster performance
No limitations to functionality
Data compression
Which of the following is the scripting language of Power Query?
A. PowerQL
B. SQL
C. M
D. DAX
M
The Using Locale feature allows you to adjust how Power Query parses a column based on the standard of a geographical region. True or false?
A. True
True
Remove Duplicates will remove duplicate records across all columns in the data set. True or false?
A. True
B. False
False
To split a column on a period (.) delimiter, which of the following should you select?
A. Period
B. Sentence End
C. Custom
D. Semicolon
Custom
Basic arithmetic can be processed by clicking on which dropdown?
A. Trigonometric
B. Standard
C. Statistic
D. Arithmetic
Standard
Unpivot Other Column will unpivot only the selected column. True of false?
A. True
B. False
False
To create a new column based on a selected column and selected example, which of the following should you select?
A. Conditional Column
B. Custom Column
C. Column from Example
D. Column with Custom Function
Column from Example
Filtering data in Power Query gives you the same flexibility as building a custom conditional column. True or false?
A. True
B. False
False
Parameters show up in which section of PowerQuery?
A. Transform tab
B. Applied steps
C. Queries
D. Data preview
Queries
An inner join will return which data?
A. All data from the right sheet and matches from the left
B. All data from the left sheet and matches from the right
C. Only data that has an exact match in both sheets
D. All data
Only data that has an exact match in both sheets
To convert a column in a query to a standalone list, which of the following should be selected?
A. Statistics
B. Get Data
C. Convert to List
D. Add as New Query
Add as New Query
Which of the following attempts to get data from a column and can handle errors if any arise?
A. if then
B. raise error
C. switch
D. try
try
Clicking on Format > Clean will have which effect on your text columns?
A. Lowercases each word
B. Capitalizes each new word
C. Removes non-printable characters
D. Removes unnecessary spacing
Removes non-printable characters
A solid line in the relationships pane represents which of the following?
A. A one-to-many relationship
B. A one-to-one relationship
C. A two-way relationship
D. An active relationship
An active relationship
You can change the format of a date or number column by clicking on which of the following first?
You can change the format of a date or number column by clicking on which of the following first?
A. Text Transform
B. The column name in the Fields pane
C. Format
D. Transform
The column name in the Fields pane
Citing columns in DAX is written in which format?
A. 'Table'[Column]
B. dbo.table.column
C. Table:Column
D. Table.Column
'Table'[Column]
In DAX, the SUBSTITUTE function is case sensitive. True or false?
A. True
B. False
True
To calculate an average measurement row by row, which of the following should be used?
A. ROWAVERAGE
B. AVG
C. AVERAGE
D. AVGX
AVGX
The RELATED function only works if there are relationships already in place in the data model True or false?
A. True
B. False
True
In DAX, which of the following is the correct syntax for the IF function?
A. IF(Expression, Then, Else)
B. IF expression THEN value ELSEIF expression THEN value ELSE value
C. VAR RETURN IF expression THEN value ELSEIF expression THEN value ELSE value
D. CASE IF expression THEN value ELSEIF expression THEN value ELSE value END
IF(Expression, Then, Else)
If you want SWITCH to evaluate if an expression is true, where should you place TRUE()?
A. The last line
B. The first line
C. At the beginning of the expression
D. At the end of the expression
The first line
To load variables in to an IF function, which of the following is required?
A. LOAD
B. BEGIN
C. VAR
D. RETURN
RETURN
When you add categories or dimensions to a visualization, why are calculated columns you've created adjusted based on the category?
A. Filter level context
B. Data level context
C. Row level context
D. Categorical context
Filter level context [Show Less]