PL-300 Quiz
What is the row limit when creating R visuals? 100,000 rows 150,000 rows 500,000 rows 1,000,000 rows
150,000 rows
What is the maximum number of dashboards allowed in an App? Zero - they are not allowed in an App. 1 2 10 20 100 200 1000 There is no limit.
200 That's right. You can have up to 200 dashboards in an App.
What is a role-playing dimension? A role-playing dimension can filter a related fact in different ways. A role-playing dimension can only filter a related fact table based on one column. A role-playing dimension is referring to a duplicated dimension table that is used with different columns.
A role-playing dimension can filter a related fact in different ways.
Which of the following functions removes filter context? CALCULATE ALL FILTER All of the above
ALL Instead of adding filter context, ALL removes it; use it when you need unfiltered values that won't react to changes in filter context (i.e. % of Total, where the denominator needs to remain fixed)
Which of the following is not a best practice when using the Q&A visual? Fix incorrect data types Add axis labels to all the charts Add missing relationships between tables Add synonyms to tables and columns
Add axis labels to all the charts Best practices are: Use new Q&A tooling to interact with queries and make improvements; add missing relationships between tables; rename tables and columns; fix incorrect data types; normalize your model (single table or column per question); add synonyms to tables and columns.
You have a line chart with the sales amount over the last year. You want to add an average line to the chart to quickly see which months have been above average and which months below average. If that is possible, how can you achieve that? Create a measure using the AVG() function and place it in below the sales amount in the Values area. Create a measure using the AVERAGE() function and place it in the secondary values area. Add the average line by navigating to the Analyze tab and place a measure that is using the AVERAGE() function into constant line area. Add the average line by going to the average line section in the Analyze tab and adding "Average line" there.
Add the average line by going to the average line section in the Analyze tab and adding "Average line" there.
What can be useful to create unique IDs and form relationships between tables? Adding a column from examples Grouping data Adding an index column Appending queries
Adding an index column Index columns contain a list of sequential values that can be used to identify each unique row in a table, which is why they are often used to create unique IDs and form relationships between tables.
You have a row-level security that is based on the state and the years. One user is included in the two groups: State = "Florida" Year = 2022 What data can this user see in the related report? Nothing, the user will get an error message. All data from Florida and all data from 2022. Only the data that is related to Florida from the year 2022. All data from all states and all years.
All data from Florida and all data from 2022. If a user is in multiple groups they will be able to see the data from both (or multiple) groups combined. Thus, all data from Florida and all data from 2022 will be visible to the user. This was discussed in Lecture 108: Configure row-level security group membership
What is a requirements for a column to be used to mark a table as a date table? The column has to be of the data type date. The column can only contain unique values and contains all date values. Cannot contain null values. All the above.
All of the above
Which of the following functions returns a table? TOPN FILTER DATEADD All of the above
All of the above All of these functions return tables.
What is the purpose of data profiling in Power Query? Provide a visual way to explore data Get a sense of your dataset composition To solve column quality issues All of the above
All of the above Data profiling tools like column quality, column distribution, and column profile provide a visual way to explore data and get a sense of your dataset composition, while the contextual menus allow you to solve column quality issues.
Which of the following sources can Power BI connect to? SQL Database Google Analytics R scripts All of the above
All of the above Power BI can connect to virtually any type of data source, including (but not limited to) SQL databases, R scripts, and Google Analytics.
Which of the following is a benefit of pinning a live page? Slicers are imported Functionality is preserved Updates to the report are reflected All of the above
All of the above The Pin Live Page option pins an entire report to a dashboard while also importing slicers, preserving functionality, and reflecting any updates to the report.
Which of the following statements is true regarding filter flow? By default, the filter direction will point from the "one" side of the relationship to the "many" side When you filter a table, the filter context is passed along to all related "downstream" tables. Filters cannot flow "upstream" All of the above
All of the above The filter directions (arrows) in each relationship will point from the "one" side of the relationship (lookups) to the "many" side (data) by default. When you filter a table, that filter context is passed along to all related "downstream" tables (following the direction of the arrow). Filters cannot flow "upstream" (against the direction of the arrow).
Which of the following options is part of Power BI's accessibility features? Themes Layer order Tab order All of the above
All of the above These are all part of Power BI's different accessibility features that allow consumers to easily navigate reports.
If you import or create your own date table, which of these requirements must it meet? Must contain all the days for all years represented in the model Cannot contain duplicate dates Must have at least one field set as a Date or DateTime datatype All of the above
All of the above To import or create your own date table, it must meet all 3 of these requirements, and all times must be identical (i.e. 12:00).
What is the tool used to combine two table with the same data structure (esp. the same columns names)? Append queries. Merge queries. Combine queries. Unpivot columns.
Append queries.
Which of these operations adds rows to an existing table? Group By Pivoting Merging Queries Appending Queries
Appending Queries Appending queries allows you to combine (or stack) tables that share the exact same column structure and data types, which adds rows to the existing table
Which content type can you use to distribute content to a broad audience in your organization? Dashboards. Reports. Workspaces. Apps.
Apps App are used to distribute content to a broad audience in your organization.
Which visualization type would be most effective when comparing sales data from different categories? Bar chart Pie chart Line chart Scatter chart
Bar chart
You need to create a visual that displays the progress against the sales goals. You have three measures: - Bonus = 450 - Units sold = 323 - Amount of units = 600 What do you need to do to visualize the following gauge? Bonus to Minimum value, Units sold to Target value, Amount of units to Maximum value Bonus to Maximum value, Units sold to Value, Amount of units to Target value Bonus to Target value, Units sold to Value, Amount of units to Maximum value Bonus to Target value, Units sold to Minimum value, Amount of units to Maximum value
Bonus to Target value, Units sold to Value, Amount of units to Maximum value
Brian and Chloe are working on a workspace - Brian is the Admin, Chloe is a Viewer. Brian creates an App and gives David permissions to see it. Who can view the App? David only. Brian and David. Brian, Chloe and David.
Brian, Chloe and David. That's right. Brian and Chloe have automatic access to the app, as they have access to the workspace.
Which of the following functions modifies and overrules any competing filter context? CALCULATE SUMX RELATED REPLACE
CALCULATE CALCULATE modifies and overrules any competing filter context!
What should we do if the file location of an already connected source file has changed? Change the file path in the data source settings. Remove the source connection and create a new one. The source connection will be updated automatically. It is not possible to update the file location.
Change the file path in the data source settings. If the name or the location of a source file has changed we can fix that by adjusting the file path in the data source settings.
Which Power Query tool can you use when you know the outcome of a column you want but don't know which transformation(s) to use? Column from examples Conditional column Custom column Index column
Column from examples Columns from examples allow you to add new columns by providing an example value
Which data profiling tool provides detailed column statistics and value distribution for a selected column Column quality Column distribution Column profile Column statistics
Column profile Column profile provides a more holistic view of data within a selected column by providing a sample distribution of the data and column statistics.
Which data profiling tool can you use to check the number of errors in a column? Column quality Column distribution Column profile Column quality & column profile
Column quality & column profile Column quality shows the percentage of values within a column that are valid, have errors, or are empty; column profile provides this information in the column statistics as well.
Which data profiling tools does Power Query have? Column from examples, custom column, and conditional column Column quality, distribution, and profile Index column and duplicate column Format, extract, and parse
Column quality, distribution, and profile The VIEW tab includes data profiling tools like column quality, distribution, and profile
What is the purpose of the Power Query editor? Create visualizations. Create a data model using relationships. Enhancing the modeling using DAX calculations. Connecting different data sources and transform the data.
Connecting different data sources and transform the data. The Power Query Editor's purpose is to connect to different data sources and transform the data into the shape you want.
What turns a collection of independent tables into a data model? Connecting the tables via relationships, based on their common fields Connecting to the tables in a single Power BI file Merging the tables into a single "master" table Giving the tables related names
Connecting the tables via relationships, based on their common fields In a data model, tables are connected via relationships, based on their common fields
Francis wants to be able to have access to a workspace, and to be able to create reports in this workspace based on existing datasets. What is the MINIMUM workspace role he needs to have? Admin Member Contributor Viewer
Contributor
I'm looking to create an app and share it among 200 specific individuals in my organisation (which has 300 people). What is the best way to do this? You can only have 100 users in an app, so you have to create two apps. Create an app for 100 users, and then share what reports others need. Create a group containing these 200 people, and use this group in the permissions section It can't be done. 100 users for an app is the limit. Give access to the Entire organization, and only send the link to the 200 individuals.
Create a group containing these 200 people, and use this group in the permissions section That's right. So you are only having permission shared across one group, which just happens to have 200 members.
Which of the following functions allows you to calculate running totals? DATESYTD DATEADD DATESINPERIOD All of the above
DATESINPERIOD DATESINPERIOD allows you to calculate running totals. DATESYTD is allows you to calculate performance to-date, and DATEADD allows you to calculate for a previous period.
If you create a bookmark to set a certain filtering on a given page which of the following options need to be checked? Selected visuals Display Data Current page
Data
What does DAX stand for, in the context of Power BI? Data Analysis Expressions Data & Analysis Exchange Data Aggregation Expressions Dogs Against Xylophones
Data Analysis Expressions
You plan to publish your SSAS Tabular (live connection) data model to Power BI Service. What must be used in order for this to be possible? Data Gateway Dual Storage Mode Parameters Admin Privileges
Data Gateway Data Gateways are required for on-premises data sources, like SSAS Tabular live connections.
When should you use DirectQuery? The source data never changes Company policy states no data source restrictions Dataset is too large to be stored in-memory All of the above
Dataset is too large to be stored in-memory Use DirectQuery when the dataset is too large to be stored in-memory, when the source data changes frequently & reports must show the most recent data, and when the company policy states data can only be accessed from the original source.
What object could you add to a dashboard if the user would like an interactive way to sort and filter the data using dates? Categorical Slicer Date Slicer Top N Filter Report Level Filter
Date Slicer Slicers provide an interactive way for users to sort and filter a report, and date slicers are exclusively for date fields.
Which visual allows you to break down a measure across multiple dimensions? Decomposition Tree Line Chart Key Influencers Treemap
Decomposition Tree The decomposition tree visual allows you to perform exploratory analysis by successively breaking down a measure across multiple dimensions.
On which table is usually the one-side in a one-to-many relationship? Dimension table. Fact table. There is usually a one-to-one relationship between fact and dimension tables. None of the above.
Dimension table. Since the values are unique in the primary key of the dimension table and this is the column used to create the relationship, there is the one-side usually at the dimension table.
What connectivity mode should we use if you want to ensure to always see the most up-to-date data? DirectQuery Import
DirectQuery With DirectQuery no data is copied or imported into the Power BI file but the data is queried directly from the underlying data source, so you are always seeing the latest data.
Your customer requires that users can use a certain data point from a visual on one page and get more details on that data on another page that is filtered to that specific data point. What tool can you use? Drill down Drill through Hierarchies Page navigation
Drill through
Which of the following is not an option when editing report interactions? Filter Highlight None Drill through
Drill through Report interactions allow you to define how filters applied to one visual impact the others. The options are: filter, which produces a fully filtered chart; highlight, which produced a chart that highlights the filtered segments; and none, in which the chart remains unfiltered. Drill through is a separate type of filter.
What allows users to jump to different report pages while simultaneously filtering based on the specific item selected? Drill through filters Tooltips R visuals Page filters
Drill through filters Drill through filters allow users to jump to different report pages (like bookmarks), while simultaneously filtering based on the specific item selected
What is a common use case for parameters in the Query Editor? Dynamically change the data source. Enable What-if scenarios. Create multiple transformations in one step. Enable to interactions between queries.
Dynamically change the data source.
Which table is likely a dimension table? Employees Transactions Sales None
Employees That's right. This table does not contain any transactions or event data but the data is more static.
You have imported a dataset of 2,000 rows. You have a list of countries that should be included in the dataset. What are the steps that you need to do to you check if exactly these countries are contained in the dataset? Enable column profiling based on entire dataset and select column profile in the view tab. Leave the default settings for column profiling and select column profile in the view tab. Enable column profiling based on entire dataset and select column distribution in the view tab. Leave the default settings for column profiling and select column quality in the view tab. Convert the relevant column into a list and select column quality.
Enable column profiling based on entire dataset and select column profile in the view tab. Only with column profile we can see the exact list of values in a column.
If you get data from an Azure SQL database you need to have an on-premise data gateway install on the relevant server to be able to refresh the data. True or false?
False Since this is a database that is hosted on Azure, you don't need to install an on-premise data gateway.
In a one-to-many relationship cardinality, what is the "many" attached to? Primary key Foreign key Index column Lookup table
Foreign key Cardinality refers to the uniqueness of values in a column, and whenever there is only one instance of each value, then it is a primary key, if there are many instances then it is a foreign key.
Which tool can you use with minimal effort to leverage artificial intelligence to find hidden insights in your data? R Script visual Get insights Forecasting Key Influencer visual
Get insights
Which Power Query tool can you use to roll-up daily transaction data into monthly transactions Merging Queries Appending Queries Group By Pivot Columns
Group By Group by allows you to aggregate your data at a different level (like daily data into monthly).
Which interaction method is selected in this visual? Filter Highlight None
Highlight The icon in the middle is selected which is the icon of "Highlight".
When would you need to access the Data Source Settings? If you need to connect to a new data source If you need to edit and existing query If the file name or location changes All of the above
If the file name or location changes Connections to local files reference the exact path, so if the file name or location changes, you will need to change the source via the Data Source Settings
In which storage mode are tables solely stored in-memory and queries fulfilled by cached data? Import DirectQuery Dual Native
Import Once you connect to data, the Query Editor lets you shape & transform the data to meet your needs, then load that model into Power BI Desktop
Which of the following actions requires you to be signed in to Power BI? Importing custom visuals Linking bookmarks Editing report interactions All of the above
Importing custom visuals Importing custom visuals from files, your organization, or the AppSource marketplace requires you to sign in to Power BI.
Which of these DAX function categories loops through the same calculation on each row of a table, then aggregates the results? Logical Functions Filter Functions Stats Functions Iterator Functions
Iterator Functions Iterator (or "X") functions allow you to loop through the same calculation on each row of a table, and then apply some sort of aggregation to the results (SUM, MAX, etc.).
What visual could you use if you wanted to understand the factors that drive a specific metric? Decomposition Tree Line Chart Key Influencers Treemap
Key Influencers The key influencers visual helps you understand the factors that drive a specific metric.
What function is often used to create semi-additive measures? RELATED USERELATIONSHIP LASTDATE SUM
LASTDATE
If you want to include a forecast in your visual, which type of visual should you use? Line chart Bar chart Scatter chart Area chart
Line Chart Forecasts are only possible in line charts. This was discussed in Lecture 81: Forecast feature
On which of the following chart types can you add a forecast based on a specific number of periods? Scatter charts Line charts Clustered column charts All of the above
Line charts Only line charts have forecast in the chart analytics options.
In your report you need to import two tables called Employees and Supervisor. The Employee_id uniquely identifies the rows in the Employee table and the Supervisor_id uniquely identifies the rows in the Supervisor table. You have to create a table that has one row per employee but also the relevant supervisor of the respective employee. How can you achieve that? Append the two tables. Transpose the two tables. Unpivot all columns in the Supervisor table except the employee_id and combine the tables. Merge the two tables.
Merge the two tables. Combining tables is possible in two ways: merging and appending. If you want to add columns to an existing table using a common column (Supervisor_id) you should use the merging tool.
Which of the following statements is NOT true regarding the use of merged tables instead of data models? Merging creates redundant data Merging uses more memory Merging uses more processing power Merging keeps metrics and dimensions in separate tables
Merging keeps metrics and dimensions in separate tables Merging data by pulling all the attributes into the fact table itself creates redundant data and utilizes significantly more memory and processing power than creating relationships between multiple small tables.
Which of the following sources lets you connect your data to other business applications? Microsoft Dataverse Microsoft Dataplatform Microsoft Dataflows Microsoft Excel
Microsoft Dataverse The Dataverse is a cloud-based storage options for your organization's data that you can connect to business applications like Power Apps, Power Automate, and Power Virtual Agents
Based on the conditional column above, what Price Range value would be given to a Unit_Price of 500? Low Mid High Unclassified
Mid Conditional columns allow you to define new fields based on logical rules (IF statements). In this example, the value of 500 is greater that 100, but less than 1000, which is why the output is "Mid".
The Q&A visual lets you explore data "in your own words" using what? DAX M Code Natural language queries SQL
Natural language queries Q&A in lets you explore your data "in your own words" using natural language queries.
Which of the following sources lets users connect to a set of pre-wired connections? PBIDS Files JSON Files Dataflows SSAS Tabular
PBIDS Files Power BI Data source files contain a single set of pre-wired data source connection settings allowing users to easily connect and speed up the "Get Data" process
You have created a report with a bar chart to visualize the revenue by region. The users need to see the sales quantity if they hover over a specific data point. What do you need to do to set that up? Place the field sales quantity in the drill through area. Place the field sales quantity in the tooltip area. Place the field sales quantity in the visual filter area. Place the field sales quantity in the additional info area.
Place the field sales quantity in the tooltip area.
What is usually better in terms of optimizing the data model? PowerQuery is usually better than DAX columns, and transforming data on the source level (e.g. database level) is better than transforming data in PowerQuery (the earlier in the lifecycle the better). DAX columns are usually better than using PowerQuery, and transforming data PowerQuery is better than transforming data on the source level (e.g. database level (the later in the lifecycle the better).
PowerQuery is usually better than DAX columns, and transforming data on the source level (e.g. database level) is better than transforming data in PowerQuery (the earlier in the lifecycle the better).
What is the name of a column or field used to uniquely identify each row of a table? Primary key Foreign key Native key Unique key
Primary key Primary keys uniquely identify each row of a table, and match the foreign keys in related data tables.
Which column of the dimension table is used to create a relationship to the fact table? Foreign key Primary key The date column None
Primary key Usually we use the primary key of the dimension table and the foreign key of the fact table to create a relationship between facts and dimensions.
I want to publish my report. Which of these options is no longer available by default? Embed - Securely embed this report in a website or portal Export to PowerPoint - Export this report as a PowerPoint presentation Export to PDF - Export this report to a PDF file Publish to web - Embed this report for public access by anyone on the Internet Embed in SharePoint Online - Get a link to securely embed this report in a SharePoint page
Publish to web - Embed this report for public access by anyone on the Internet That's right. You will need the Admin to switch this on for any new embed codes.
Which of the following fields would typically find in a data table? Product name Retail price Quantity Sold Product Brand
Quantity Sold Data tables contain measurable metrics about the business, like quantity sold, while lookup tables provide descriptive attributes about each dimension in your model, like product name, product brand, and retail price.
You are importing data from large csv files with data of your support ticket system. The csv files have the following fields: Ticket_id, responsible_id, create_time, solved_time, message_text. You need to analyze the efficiency of the ticket system. The topics of the subject is not important and the users should not be able to read the messages. What should you do? The solution should minimize the size of the data model. Set up row-level security (RLS) to enable only the users to read the messages that they are responsible for. Remove the message_text column. Hide the tables in the model view or report view.
Remove the message_text column. To minimize the size of the data model we should try to remove unnecessary rows and columns. We always want to avoid redundant data.
Which of the following filter options applies to all visuals across all pages of the report? Visual level Page level Report level Drill through
Report level Report level filters apply to all visuals across all pages of the report.
If you want to display a relationship between the score a student achieved in a test and the number of hours a student studied for a test, which of the following visualization types could be a good fit? Clustered column chart Bar Chart Scatter chart Pie Chart
Scatter Chart A scatter chart is ideal if you want to display relationships or a correlation between two (or more) fields. This was discussed in Lecture 63: Scatter chart, waterfall chart and maps
Which of the following sources contains sites, document libraries, and folders? SharePoint Online Microsoft Dataverse Power BI Libraries Filing Cabinets
SharePoint Online SharePoint Online organizes information into sites, document libraries, folders, and files within folders.
What can you do with the DATEADD function? Create calculate values on a year-to-date basis. Create a table for an entire year on a daily basis. Add a date column with a specified format (for example weekdays). Shift the context in a given measure by a specified interval.
Shift the context in a given measure by a specified interval.
Which of the following is a common use case for scatter charts? Show changes in values over time Show patterns in large sets of data Show comparisons across categories All of the above
Show patterns in large sets of data Common use cases for scatter charts include showing patterns in large sets of data, showing linear & non-linear trends, performing cluser analysis, and identifying outliers.
Which of the following objects cannot be pinned as an individual tile to a dashboard? Filled Maps Tables Slicers Bar Charts
Slicers Slicers cannot be pinned to a dashboard individually, they need to be pinned as part of a live page.
Where should you create calculated columns to reduce model size and improve performance? Source data Power Query Data model They all achieve the same results
Source data Creating calculated columns as close to the source as possible helps reduce data model size and improve performance.
You are importing data from a large csv file with 2 million data rows of your support ticket system. The csv file has the following fields: Ticket_id, responsible_id, create_time, solved_time. create_time and solved_time are date/time fields in the following format: 01-01-2022 12:24 What should you do? The solution should minimize the size of the data model but you still need to have access to all the information. Split the columns in two separate fields, one with the date and the other one with the time. Change the data type of the two columns to date to reduce the model size. Change the data type of the two columns to text to reduce the model size. Change the data type of the two columns to time to reduce the model size.
Split the columns in two separate fields, one with the date and the other one with the time. Microsoft recommends splitting up date and time into separate columns for better compression rates. This will preserve all information.
What happens "under the hood" whenever you apply a transformation in Power Query? The same transformation is applied to the source data The changes are permanent and cannot be modified The Query Editor writes the corresponding DAX code for the applied step The Query Editor writes the corresponding M code for the applied step
The Query Editor writes the corresponding M code for the applied step Data Mashup, or M code, is the formula language that drives Power Query. Whenever you use UI tools to apply a transformation, the corresponding M code is automatically generated.
What allows you to design changes to your report such as using corporate colors? Bookmarks Themes Templates Report-level filters
Themes
Which of the following is NOT true about CALCULATE modifiers? They are used to change filter context They are used to access inactive table relationships They allow you to drag and drop fields rather than write DAX from scratch They are used to change the way filters propagate
They allow you to drag and drop fields rather than write DAX from scratch Quick measures allow you to drag and drop fields rather than write DAX from scratch. The rest are all use cases for CALCULATE modifiers.
Which of the following is NOT true about measures? They are evaluated based on row context They reference entire tables or columns They aren't visible within tables They recalculate in response to any change to filters within the report
They are evaluated based on row context
What do bookmarks accomplish in Power BI? They save a query for use in other reports They save a subsegment of your data table as a separate file They save a pre-filtered view of your report They save your chart as a template
They save a pre-filtered view of your report Bookmarks allow you to create pre-filtered views of your reports, which you can then link to an object using it's action properties.
How can you use parameters when connecting to data? To connect to a JSON file To change data source values dynamically To create "What-If" scenarios To shape and transform data in the Query Editor
To change data source values dynamically Parameters are a useful way to change data source values dynamically in Power Query. These parameters are different from the "What-If" parameters created in the Power BI Desktip front-end.
What can the column distribution be used for? To identify errors To identify empty values To identify primary keys All of the above
To identify primary keys Use column distribution to identify primary keys within your lookup tables when the number of distinct values is equal to the number of unique values.
What is the Query Editor used for? As a cloud-based storage option for your organization's data To shape & transform data, then load it into Power BI To create relationships between data and lookup tables To create measures & calculated columns using DAX
To shape & transform data, then load it into Power BI Once you connect to data, the Query Editor lets you shape & transform the data to meet your needs, then load that model into Power BI Desktop
Which filter setting would you use if you wanted to return the top 3 categories by total profit? Basic Advanced Top N Dynamic
Top N Top N options allow you to filter the top "n" amount of items by a specified value or measure.
To sync slicers, they need to contain the same fields. True or false? True False
True You can only sync slicers that contain the same fields.
If you use the connectivity mode "Import" a local copy of your data created. True. False.
True.
Which of these functions can be used to activate inactive relationships? RELATED RELATEDTABLE USERELATIONSHIP ACTIVATE
USERELATIONSHIP The USERELATIONSHIP function allows you to determine which relationship to use between to tables, including inactive relationships.
You work as an analyst at Cat Slacks and you've just been handed a csv file with yearly sales by department. After connecting to it in Power BI, you notice that each year has its own column. Which Power Query tool can you use to turn the multiple "Year" columns into rows? Pivot Unpivot Transpose Group By
Unpivot "Pivoting" is a fancy way to describe the process of turning distinct row values into columns ("pivoting") or turning columns into rows ("unpivoting").
Which of these is NOT a data model best practice? Use a star schema with many-to-many relationships Contain relationships with one-way filters (vs. bidirectional) Contain tables that each serve a specific purpose, including data (fact) tables and lookup (dim) tables Only include the data you need for analysis (no redundant or unnecessary records or fields)
Use a star schema with many-to-many relationships A well designed model is critical and ideally should use a star schema with one-to-many (1:*) relationships, NOT many-to-many
In what field do measures typically "live" in a visual? Rows Columns Values Filters
Values Measures are numerical, calculated values that can be analyzed in the "values" field of a report visual.
Which of the following filter options applies only to the specific visual in which it is defined? Visual level Page level Report level Drill through
Visual level Visual level filters apply only to the specific visual in which they are defined.
When would you use a tool from the Transform tab over the Add Column tab? When you want to overwrite the values of existing columns When you want to keep the values of existing columns When you want to create new columns Both B & C
When you want to overwrite the values of existing columns The Transform tab includes tools to modify existing columns by overwritting its values
Which of these statements is NOT true about merging queries? Merging queries allows you to join tables based on a common column Merging adds columns to an existing table You should merge tables whenever possible You can merge queries by different join kinds (left outer, inner, etc.)
You should merge tables whenever possible Just because you can merge tables, doesn't mean you should. It's better to keep tables separate and define relationships between them in your data model.
Which two blocks make up the M code that runs your query? do & while if & then for & each let & in
let & in Opening the advanced editor allows you to see the M code that makes up your query, which consists of two blocks: let (the definition of all variables) & in (the output of your query)