final scmt 4633
Which of the following is a URL action option?
hover
The Format Shading tool will also change the background of your maps.
FALSE
Which limitation do you have when you create Pivot Tables from data models?
You cannot define a calculated field.
You would like to filter your Pivot Chart from five product rows to three rows. Where do you do this, and are there any changes made to your Pivot Table?
You do this in Categories on the Pivot Chart, and your Pivot Table changes to three product rows as well.
Reference lines can be created from _____.
parameters
What is a valid array name in Excel?
Sample_Name
What step should you perform before adding data from more tables, if you need to eventually aggregate the data by which table it originally came from?
Add a custom column to each table, set to the table name.
Continuous data charts require at least one blue pill.
FALSE
Which is true regarding publishing to the web?
Some items, like Arc GIS visualizations, cannot be published
How would you create a date table in Power BI for mortgage loan calculations, rather than loan periods that will use dates as the pivot coordinates?
Use the formula GENERATESERIES(DATE(start year, start month, start day), DATE(end year, end month, end date)).
When you share a report with other users, what access do they have, assuming there are no low-level security restrictions?
Users have the same access as you.
Why would you use explicit DAX measures rather than implicit measures in Power BI?
When you create pivot tables, implicit measures are often inaccurate.
In order to share within their organization, a user needs at least _____.
a Power BI Pro license
What is generated when you click "Publish"?
a link that can be sent in email, and an HTML link that can be pasted into a blog or website
What is Power BI?
a self-service business intelligence solution
When can a user create a mobile view?
after they've pinned a tile to the dashboard
What does "Data View" show?
all of the data in a dataset
Joins can be used to visualize null data and to _____.
all of these answers
Tooltips allow you to _____.
all of these answers
Which of the following is true about Tableau data extracts?
all of these answers
Why would you create a custom list to sort products in a Pivot Table?
because it is quicker and safer than manually sorting the products
You are interested in seeing the contribution of each of your five products to the total yearly sales over the past three years. How can you do this?
by selecting % of Grand Total under Show Values as in Value Fields Settings
How can a user create a refreshable data source?
by storing their file in the cloud
Reports in Power BI _____.
can include funnel charts, tree maps, geospatial maps and a variety of different visualizations
In which action will you use a sequence of four keyboard controls to perform the action?
converting a Pivot Table to a cell range
If a user wishes to subscribe another user to a dashboard or report, what do they need?
editing permissions to that dashboard/report
Creating a calculated field adds the field to your original data source.
false
You may have no more than three ELSEIF conditions within an IF...THEN statement.
false
What is an example of a Monte Carlo situation?
flipping a coin
What do geospatial visualizations require?
geospatial data (latitude, longitude)
The _____ value of a data set is the value that appears in the middle of the list when it is sorted into ascending or descending order.
median
Power BI Mobile can be downloaded onto _____.
mobile devices, smartphones, tablets
Which cardinality will you use to represent a bank customer in one table related to different bank accounts in a different table?
one to many
You can change the percentile cutoff value in a visualization by using a
parameter
Which users have the ability to apply a filter to all pages of a report?
report creator/owner
In a standard card visualization, a field added to the card is added at the _____.
right
When merging tables in Power BI Desktop, which join kind shows all rows from the second table, and matching from the first table?
right outer
The standard deviation of a population is the ____ of its variance.
square root
Which two tables, in order, will a DAX CALCULATE formula draw from to connect a loan period table to a dates table?
the data tables, and the pivot coordinates of the dates table
What is the cyclic component in a trend line when you are using a time-series for forecasting?
the way peaks and valleys vary around the trend line
Why would you use the DATEDIFF measure function with mortgage loan pivot table data?
to calculate the difference between two dates, both of which must be measures, by an interval such as months
Why would an analyst use colors to highlight data?
to communicate impartial data
You are creating formulas to calculate the remaining balance on a mortgage loan. Why would you use a parameter-harvesting function?
to convert a naked loan period column into a measure you can reference
Although efficiency means taking as few steps as possible, why should you first test an SQL query in an application such as Visual Studio.
to make sure the SQL code works
Which of the following date_part values is not usable with the DATEPART function?
weekendday
When will the Replace Values operation generate an error?
when replacing numeric values with letters
When should you always change values in a Pivot Table to the Accounting Number format?
when the values are over 1,000 dollars
You have just deleted Page 1 of your report. When is it permanently deleted?
when you save the report
When working with Macros, which of the following is the correct file name extension?
xlsm
Which equation is an example of a linear relationship between x and y?
y=ax+c
The expression [Revenue] - AVG([Revenue]) returns an error. Within which character pair must you enclose AVG([Revenue]) to fix the error?
{ }
You need to add another column to your data that simply sets all values to the text "complete". Which custom column formula should you use?
="complete"
What is the primary difference between creating a new workspace in Power BI vs a classic workspace?
A new workspace does not automatically generate an Office 365 group.
The data you imported has dates in the format, DailySales_1.1.2020. If you want the dates in your column to display as date only, what should you do?
Create a custom _ delimiter in Sort Column by Delimiter, which will leave only what is after the underscore.
How can a dashboard creator make a dashboard easier to view on a mobile phone?
Create a phone view for the dashboard.
There are six different ways to connect to data in Tableau.
FALSE
Which Excel function transforms a correlation coefficient into a z-score?
FISHER
What happens if you are not logged in to Facebook and try to connect to public information there?
Facebook requires you to log in first.
What is the result of using a GENERATESERIES function when you create a table?
It reduces the potential for human error.
Which option or options are available as a choice in the app workspace?
OneDrive Business
Your story-telling worksheet shows Products and Purchase Price. One of your managers would like to see total units purchased by product. Which path will you have to take?
Open Pivot Table Fields, drag Total Purchases up to the Fields area, then drag Quantity down into Columns.
Which function returns a separate rank for each row without skipping any numbers?
RANK_UNIQUE
To find the largest value in a table column down to the current row, use the _____ function.
RUNNING_MAX
What does the mobile app's Quick Access tab display?
Reports and dashboards
Which Excel function calculates the standard deviation of a sample distribution?
STDEV.S
Sales per capita replaces these two measures.
SUM(sales) and SUM(population)
You would like to print a Pivot Chart you have moved to its own chart sheet. If you click a Pivot Chart you have moved to its own chart sheet, then press Ctrl+P, which action will you take next?
Select Print Active Sheet from the options under Settings.
The loan payment chart you created on your dashboard has two separate time periods, and they are both being filtered by the same Select Date. If this is not what you want, how should you change it?
Select the chart, go to the Format bar, select Edit Interactions, and then select the cross-through icon.
The data you selected for a visualization includes geospatial data, so Power BI created a map. You wish to present your data in columns and rows. What should you do?
Select the visualization then click on the Table visualization.
How is previewing a CSV file before loading it different than previewing an Excel file?
The CSV preview allows controlling the data type detection.
What is an easy way to have Power BI keep a user up to date on the status of critical values in their dashboards?
Set alerts.
Years can be converted from Dimensions to Measures
TRUE
How can a user remove a "favorite" item from their favorites list?
Unmark it on Favorites list.
To return a zero if a calculation returns a null value, use the ZN function.
ZN
Which workspaces does a user have access to in the Power BI mobile app?
all workspaces
How can a user view their uploaded data immediately in Power BI?
by clicking "View Dataset"
You would like a slicer filtered by product category, but you would like the caption to read Product Category. How can you do this?
Select the Slicer, go to the Options tab, then type Product Category in the text box below Slicer Category.
When you are making filter selections in the rows of your Pivot Table, what does a solid square box in Select All tell you?
Some, but not all, of the rows have been selected in your filter.
Which data type is used to store text values?
String
Select the correct macro that shows the details when clicking on a button.
Sub m_Data() Sheets("Data").Select Range("A13").Select Seletion.ShowDetail = True End Sub
When connecting to a data source in Power BI, _____ is found under the Databases category and _____ is found under Online Services.
Sybase; GitHub
A calculated field must be created to select dimensions.
TRUE
A calculation error will be produced if the Duration value units do not match the Measure value units.
TRUE
A visual highlighter acts as a filtering tool for users.
TRUE
Custom territories is one of the new features of Tableau 10.
TRUE
Floating legends allow for customized dashboard sizes.
TRUE
Pivoting data is as easy as highlighting columns and selecting 'Pivot' from the column dropdown in the data connection window.
TRUE
Source sheets filter the actions of Target sheets.
TRUE
The 'Drag table to union' tool allows you to join multiple sheets of data.
TRUE
The EXCLUDE keyword removes a level of detail from an LOD calculation.
TRUE
Use the CONTAINS function to determine if a character sequence occurs within a string.
TRUE
How does a user create a dashboard?
Take visualizations from reports and pin them as tiles.
How can adding a card visualization to your map help?
The card can show more details on data selected in the map.
Your Pivot Table shows products you purchase under headings in Column A, and 2019 in Column B. If you have not changed any settings, what happens when you select Show in Outline Form?
The individual products will move a column to the right.
Which must be true to carry out complex planned comparisons?
The null hypothesis is rejected.
What happens when you publish a PBIX file with a name that is already used?
The system will ask whether you want to replace the data set.
You are interested in joining data tables to show inflation rate by country within specified geographic regions. In order to join the tables, what must you have?
There must be a unique ID for each country in the Region key.
When you created a Pivot Table in a new worksheet, the table was blank. Why is this?
This is how a Pivot Table in a new worksheet appears.
After you're finished working with a visualization's interaction settings, what is best practice?
Turn off Editing Interactions.
How does a two-way ("two-factor") ANOVA provide results that are more meaningful than a one-way ANOVA?
Two-way ANOVA can produce interaction effects you would not see with a one-way ANOVA.
When connecting Power BI Desktop to a web data source pointing to a webpage with multiple tables, what can you preview?
You can preview all tables individually.
Why would you add a Timeline of months to the Pivot Table on a worksheet?
You can show a clickable summary of data without changing your Pivot Table.
Why should you take some time to experiment with different degrees of freedom ("df") in a t-distribution visualization?
You will be able to visualize and understand just about any distribution you will come across in your work.
Which statistical chart type would you use to visualize outliers in a data set?
a box-and-whisker chart
Which term is another name for planned comparisons?
a priori comparisons
What does the Excel function RAND generate?
a random number between 0 and 1
You've loaded a sample dataset that includes reports and dashboards. If you later delete the sample dataset, Power BI will also _____.
delete the reports and dashboards
You have a set of test scores with values ranging from 1 to 100, and want to plot the scores in 5 intervals of 20 points each. Which Excel chart should you use?
histogram
When will a user see their default dashboard?
immediately upon opening Power BI
What is the central purpose of a Tableau filter?
include or exclude data from a view
A scatter plot shows the average life expectancy for each country in the United Nations. After creating a regression line for this plot, which combination of F and P values indicate that the line is a close fit to the data?
large F and small P
If you want the fastest way of importing data into Power BI, which type of data will you use?
live data
Which model should be used to describe a relationship where a multiplicative change in x will result in an additive change in y?
logarithmic regression
You have data showing the amount of time a student driver spends with an instructor, and whether or not the student passes the driving test. This is an example of which type of regression?
logistic
To find the month name of dates listed in table A, you build a lookup table B that lists the month name for every date. Which relationship do you have between table A and table B?
many to one
Which should you always avoid doing when you are defining your Pivot Tables layouts?
merging and centering cells with labels
Tableau 10 requires that you create a _____ and a _____ to display a single State across two separate databases.
parameter and a calculated field
Which statistical method is used to remove the association of two variables with a third variable, to determine the true correlation between the first two variables?
partial correlation
What does a correlation coefficient of -1 represent?
perfect negative correlation
One attribute of Power BI reports is that they are _____.
printable and exportable by users
A graph of five athletes' track scores shows an overall improvement as the amount of trials increases, but after a while, the scores dip, due to fatigue. This single change of trend direction represents which type of equation?
quadratic
Of the various statistics available when you perform a multiple regression in Excel, which statistic indicates how well your regression equation fits the data when you have multiple factors?
the R-squared, which is the square of the correlation coefficient between one variable and the combination of other variables
If a print a report from Power BI Service using Export, the print job will include _____.
the current page
Why is it beneficial to color your backgrounds when designing layout containers?
to quickly confirm you've positioned the charts in the correct place
The CEILING function always rounds a number up if the decimal component isn't zero.
true
You can use the plus sign (+) to add days to a date.
true
Where are the buttons located?
under the Developer tab
What are the four roles available in Power BI workspaces?
viewers, contributors, members, admins
Logarithms of base _____ are called common log.
10
Which of the following is a valid base for logarithms?
2
A free subscription to Power BI Pro lasts for how many days?
60
Your simulation mean is in cell F9, simulation variance in F10, and simulation standard deviation in F11. How can you find the simulation standard deviation with a Monte Carlo simulation?
=SQRT(F10)
What must be included when publishing an app? (choose one or more) A. Dataset B. Dashboard(s) C. Report(s) D. Owner's profile photo
A
Which statement is true regarding slicers?
A slicer can filter at both the page level and the report level.
Which statement is false regarding the applied steps showing in Power Query Editor?
Adding a step immediately changes the underlying data source.
Apps for the Power Platform are available from where?
AppSource
When we are creating the data flow, what is the step after Import?
Clean up
How can you create a Pivot Chart to display Purchases by Product for 2019?
Click any cell in your Excel table, then in the Pivot Chart Fields task pane, drag Category to Axis and drag Total Price to Values.
How can a user change the criteria by which values are sorted within a column (highest value -> lowest vs. lowest value -> highest)?
Click at the top of the column.
ABC Corp. sells hand tools in bulk at a lower price. How can you filter your Purchases Pivot Table to show the hand tools that are available at the discounted purchase price, listed by the vendor as Bulk?
Click on the Row Labels cell, then enter Bulk in the Search box.
You want to test goodness of fit with a data set of actual outcomes in cells C3 to C10, and expected outcomes in cells E3 to E10. What is the quickest way to do this in Excel?
Compute the p-value directly by using Excel's chi-square function.
In the three layer approach to the templates, where do action items fit?
Control
What is a recommended process for working with Power BI Desktop and Power BI Pro?
Create your work in Power BI Desktop, and then upload the file to Power BI Pro.
Which statement about formatting visualizations is true?
Different visualizations will have different formatting options available.
Column A of your table is Sales Region with product categories for each Region listed below. Column B is Quarterly Sales. How can you change the table to display the products in columns?
Drag Category from Rows to Columns in the Fields Area.
Your Pivot Table has sales by product in Rows B7 through G7, with 2017 in Row A6. How can you view sales by month?
Drag Date of Purchase into Rows in the Fields List area.
To tell Tableau how to handle any values that don't fit other rules in a CASE statement, use the _____ keyword.
ELSE
When you are creating conditional formulas, what is the only component in the formula that can have multiple conditions?
Else if
How do you enter three variables (one predicted variable, and two predictor variables) into Excel's Regression Analysis tool?
Enter one variable as the Y range, and the other two variables as the X range.
According to the author, total sales by state is an example of when to map data.
FALSE
Dates are correctly imported when listed as an 'Abc' Dimension.
FALSE
An insurance company has a set of data showing the number of claims paid per year from 1950 to 2015. Which Excel tool should be used to predict future events based on this historical data?
Forecast Sheet
What is an additional step a user must take in order to bring in data directly from a file that was not created in Excel, a CSV file, or Power BI desktop?
Get the data into Excel, a CSV or Power BI desktop model.
How can a user find out who has access to a report or dashboard?
Go to their workspace, click the Share button and choose Access.
Reducing data with the Power Query Editor would not include which of these actions?
Hide rows with null values.
To have Tableau compute the results of a calculation at the level defined by the dimensions displayed in the current view, use the _____ keyword.
INCLUDE
You are creating a Pivot Table for quarterly sales. Which advice should you keep in mind if you create a Pivot Table from a data list rather than from an Excel table?
If you add a row or a column, the change will not be added to the Pivot Table.
The Pivot Table for purchases you created was from an external data source. How can you drill down to see the data values for the individual purchase orders of packing boxes in Quarter 2?
If you double-click on the cell, a new worksheet will open and you will see the data for all your purchase orders in Quarter 2.
Your Pivot Table shows purchases by quantity for the five products you bought from ABC Corp. in 2019. How can you see the total dollar purchases for each product?
In Insert Calculated Field, define the formula =Quantity*Unit Price, then click Okay.
Under which tab can you find the option to add a slicer?
Insert
Interviews and surveys are examples of method input .
Interviews and surveys are ways of gathering input data.
How can you best describe the DAX Calculate function?
It is a supercharged sum-if function that can calculate counts, products, and other functions.
Why is a regression line known as the "line of best fit"?
It is the line that best minimizes the sum of the squared distances of the residuals from the data points on a scatterplot.
Your company is tracking sales data in Excel. What would be your recommendation on how to arrange this data for a multiyear analysis?
Keep all the data in one big sheet, with columns to denote the sale date and year.
Which function helps you to determine the number of characters in a string?
LEN
Which Excel function is used to determine the natural logarithm of a number?
LN
Which statement is true regarding the Power BI Desktop sign-in step?
Microsoft offers a trial period to use Power BI Pro features.
What should you check before changing a text column to a decimal number type?
Negative values use the minus symbol, not a hyphen.
Which of the following is true about Tableau's Top-N Analysis?
Parameters can be used to display a range of Top-N values.
How can a user keep a visual generated as a result of a Power BI Q&A session?
Pin it to their dashboard.
If a user wishes to work with multiple data sources and connect them through relationships, which tool is best-suited?
Power BI Desktop
Use _____ to display your Power BI report in presentation mode with live filtering.
Power BI app for Windows 10
Why is importing a PDF's data into Power BI considered a "hack" method?
Power Query does not directly support uploading PDFs, so you can instead open it as a Word document and save it as an HTML file.
When you perform correlation testing, why do you need both a correlation coefficient and an R value?
R values can only be a positive number, but correlations can be negative.
The school basketball team consists of 12 players, and they must be ranked by how many minutes per game each of them plays. Which Excel function will rank their time in ascending order?
RANK.AVG
What can you NOT do from the Power BI mobile app?
Remove a tile from a dashboard.
When you are transposing data tables, what do you need to do with promoted headers?
Remove them, perform the Transpose function, and then promote the headers again.
Why might a user wish to start their reports in Power BI Desktop vs Power BI Service?
Reports started in Power BI Desktop are "portable" and can be worked on in Power BI Service.
To divide a string into parts based on the occurrence of a specific character, use the _____ function.
SPLIT
To filter out the first initial of a person's name, you should use _____.
SPLIT
_____ colors are made up of one primary and one secondary color.
Tertiary
To signal the end of an IF...THEN statement, use the _____ keyword.
END
Which operator returns the remainder from a division operation?
%
Which choices are valid ways to create a dashboard? A. Go to Dashboards and select Create B. Create a dashboard from existing content C. Select New Dashboard from a SharePoint list D. Create a dashboard using visualizations from a report
A, B, D
Which of these methods can be used to create a new report that can be saved in Power BI? A. Copying and editing an existing report B. Downloading a Power BI report from SharePoint and re-uploading C. Using fields from a dataset to create visualizations D. Creating a visualization in Paint or Paint 3D and uploading to Power BI
A, C
You are creating a Sales report. The first page includes some visualizations illustrating national sales. Why might you choose to add a second page to this report? A. You have more national sales visualizations than fit well on page B. You need 10 visualizations, and only 6 are allowed per page C. The report will include regional sales visualizations. D. Reports are limited to one page.
A, C
You use Add a Tile to add content that doesn't come from Power BI. Using Add a Tile you can add text boxes, streaming content, and what else? (choose more than one) A. Images from the web B. Images from your computer C. Video from YouTube D. Web content for which you have a URL
A, C, D
As a general rule of thumb, data used in Power BI should be what? (choose more than one) A. Longer rather than wider B. Wider rather than longer C. More columns than rows D. More rows than columns
A, D
As the T.DIST.2T formula does not accept negative numbers as arguments, which additional formula should be used to calculate absolute value?
ABS
What is the purpose of using ANOVA?
ANOVA provides an analysis of the variance between means to test a null hypothesis.
If a user wishes to create a dashboard, where tool must they use? A. Power BI Desktop B. Power BI Service C. Power BI Mobile
B
Why would you pin a live report page to a dashboard? (choose more than one) A. to force users to access the dashboard through the report B. to allow users to cross-filter the visualizations as they would in the report C. so the visualizations will automatically update when the report updates D. so that filters added to the report are propagated to the dashboard
B, C, D
You run a polynomial regression to examine up-and-down changes in your company's business cycle. What is the most important factor to understand regarding your polynomial regression?
Consider the way the y variable changes direction with an increase in your x variable.
What do you need to consider if you use the BLANK function in Power BI?
BLANK will also pick up values of zero.
Which Excel function would you use to assess the difference between observed frequency data and expected frequency data?
CHISQ.TEST
Your Pivot Table shows Yearly Sales Dollars in columns and Products in Row A. You would like to see quarterly sales dollars. How will you do this?
Click on +/- Buttons in the Analyze contextual tab on the Ribbon, and then you can click the plus sign next to the year to show more detail.
The Purchase Order Pivot Table has sales for 2018 and 2019, sorted in order when they were added. How can you change the order to show the products alphabetically?
Click the filter arrow to the right of Row Labels, then select Sort A to Z.
To find the first day in a week, use the week date_part value and the _____ function.
DATETRUNC
You have a pivot table of three measures, with Measure 3 being the sum of Measures 1 and 2. Which statement is accurate about the way DAX measure logic will deal with them?
DAX will calculate Measure 3 independently of the other two measures.
To find the integer component of a division operation's result, use the _____ function.
DIV
You need to import XML data as a base to your report, where do you go to get that data?
Data tab -> from Other Sources
