Power BI questions

. How do you create intermediate calculations and data that you want stored as part of the model rather than as part of a query? A. Use a calculated table B. Select the Enter Data button C. Select the New Measure button D. Select the New Parameter button

A. Use a calculated table

What type of expression do you use to extract data from Microsoft SQL Server? A. DAX B. T-SQL C. MDX

B. T-SQL

How do you use an inactive relationship in a single measure? A. Change the active relationship in the Modeling tab. B. Use the USERELATIONSHIP function. C. Delete one relationship

B. Use the USERELATIONSHIP function.

3 main within desktop

Data view Report view Model (selected visual)

When doing transformations (transpose data)

Power query editor

If you have two queries that have different data but the same column headers, and you want to concatenate the results into one query with all the combined rows, which operation should you perform? A. Append B. Merge C. Combine Column

A. Append

Which two functions will help you compare dates to the previous month? A. CALCULATE and PREVIOUSMONTH B. TOTALYTD and PREVIOUS MONTH C. CALCULATE and TOTALTYD

A. CALCULATE and PREVIOUSMONTH

What is cardinality? A. Cardinality is the direction that the data flows in a relationship between two tables. B. Cardinality is the granularity of the data. C. Cardinality is how long it takes for the data to load. D. Cardinality is a type of visual element.

A. Cardinality is the direction that the data flows in a relationship between two tables.

What can you do to improve performance when you are getting data in Power BI? A. Do some calculations in the original data source B. Only pull data into the Power BI service, not Power BI Desktop C. Use the Select SQL statement in your SQL queries when you are pulling data from a relational database. D. Combine date and time columns into a single column Check your answers

A. Do some calculations in the original data source

What is the difference between a fact table and a dimension table? A. Fact tables contain observational data while dimension tables contain information about specific entities within the data. B. Fact tables contain information about specific entities while dimension tables contain information about observational data. C. There is no difference. D. 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.

A. Fact tables contain observational data while dimension tables contain information about specific entities within the data.

What benefit do you get from analyzing the metadata? A. The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset. B. The benefit of analyzing the metadata is to get familiar with your data. C. The benefit of analyzing the metadata is to know the number of rows, columns and tables being loaded into your model.

A. The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.

Which of the following selections are not best practices for naming conventions in Power BI? A. Rename columns to have spaces in them. B. Abbreviate column names. C. Replace values that have integers with human readable results.

B. Abbreviate column names.

You're creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect? A. Import B. Connect live C. Direct Query

B. Connect live

What does data granularity mean? A. Data granularity is the filter direction is associated with the relationship between two columns B. Data granularity is the level of detail that is represented in the data C. Data granularity is a many-to-many relationship. D. Data granularity is a type of schema design

B. Data granularity is the level of detail that is represented in the data

Is it possible to create a relationship between two columns if they are different DATA TYPE columns? A. Yes, if cardinality of the relationship is set to Many-to-Many. B. No, both columns in a relationship must be sharing the same DATA TYPE. C. Yes, the above is fully supported in latest version of Power BI desktop

B. No, both columns in a relationship must be sharing the same DATA TYPE.

Which tool would you use to extract the day of the week from a set of dates? A. Navigator view B. Power Query editor C. New Measure D. New Parameter

B. Power Query editor

How do you get Power BI Desktop to find relationships in data after it has been imported? A. Open the Power Query Editor B. Select Manage Relationships and then Autodetect C. Select the New Parameter button to map the relationship D. Use the Performance Manager

B. Select Manage Relationships and then Autodetect

What is the benefit of using a report tooltip? A. To give users additional information about a report visual, such as the author and date/time it was created. B. To provide additional detail that is specific to the context of the data that is being hovered over. C. To give users the ability to export data from the visual

B. To provide additional detail that is specific to the context of the data that is being hovered over.

Do you need to import custom visuals each time you want to use them when you are developing a new report? A. No, custom visuals are always available for selection under the Visualization pane. B. Yes, custom visuals must be imported from AppSource each time you start developing a new report. C. No, custom visuals only need to be imported once and will always remain in Power BI for future use in a new report.

B. Yes, custom visuals must be imported from AppSource each time you start developing a new report.

Which of the following options is not one of the four components in the Q&A visualization? A. The question box, where users enter their question and are shown suggestions to help them complete their question. B. A pre-populated list of suggested questions C. Automatic creation of a custom tooltip D. An icon that users can select to convert the Q&A visual into a standard visual. E. An icon that users can select to open Q&A tooling, which allows designers to configure the underlying natural language engine.

C. Automatic creation of a custom tooltip

What is one method for creating a visual? A. Drag a field from the Fields list onto the Visualizations pane B. Drag a field from the Fields list onto the Model view canvas C. Drag a field from the Fields list onto the Report view canvas D. Drag a field from the Fields list onto the Data view canvas

C. Drag a field from the Fields list onto the Report view canvas

What is the best way to import tabular data from a website into Power BI? A. Download data from the website and then import to Power BI B. Transfer data from the website to OneDrive and then import to Power BI C. Select Get Data and point to the URL D. Use the Query Editor to find and edit the web-based data

C. Select Get Data and point to the URL

What is a risk of having null values in a numeric column? A. That function SUM of data will be incorrect. B. That function MAX of data will be incorrect. C. That function AVERAGE of data will be in

C. That function AVERAGE of data will be incorrect.

Why would a table show the same value, like "Sales", for every country? A. Because the Revenue data is corrupted B. Because the column is assigned with the wrong data type C. Because there is no relationship between the Sales and Country fields. D. Because the column is sorted incorrectly

D. Because the column is sorted incorrectly

How do you get Power BI to separate date data into year, quarter, month, and day? A. Open the Query Editor B. Select the New Parameter button C. Select the New Measure button D. You don't need to do anything, it is automatic

D. You don't need to do anything, it is automatic

Example: the supply chain team wants to know the top 10 selling products are. You can accomplish this task in one of three ways:

Q&A visual Top N Filter DAX formula

Transformation (with power query)

adding, copying, removing data pivot data merging data filter data add/merge columns

Why would you want to override the default context? A. To create measures that behave according to your intentions, regardless of what the user selects. B. To create measures that do not summarize or average. C. To create new relationships

A. To create measures that behave according to your intentions, regardless of what the user selects.

What can be achieved by removing unnecessary rows and columns? A. It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact. B. Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model. C. Deleting unnecessary rows and columns can damage the structure of the data model

B. Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model.

If your months were sorted alphabetically, how could you sort them by month order? A. Click the Edit Queries button. B. Add a slicer to your visual C. Change the visualization type D. Apply the MonthNo category sort option

D. Apply the MonthNo category sort option

one-to-many

create a bridge in the data