Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DA-100 > DA-100 > Flashcards

DA-100 Flashcards

1
Q

You have a Microsoft Excel workbook with a spreadsheet named Sales. You want to use the Sales spreadsheet in a Power BI dashboard report. How should you prepare the data on Sales spreadsheet?

A. In Power BI service, import the data from the Sales spreadsheet.
B. In Microsoft Excel, publish the Sales spreadsheet to the Power BI service.
C. In Microsoft Excel, convert the data in the Sales spreadsheet to a flat table.
D. In the Power BI service, upload the Excel workbook.

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01.

You want to be able to use Microsoft R scripts in your visualization.

You install SQL Server R Services on SQL01.

Does this action allow you to use Microsoft R scripts in your visualization?

A. Yes, it does
B. No, it does not

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01.

You want to be able to use Microsoft R scripts in your visualization.

You download and install Microsoft R Open on the computer that has Power BI Desktop installed. Does this action allow you to use Microsoft R scripts in your visualization?

A. Yes, it does
B. No, it does not

A

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01.

You want to be able to use Microsoft R scripts in your visualization.

You download and install Visual Studio on the computer that has Power BI Desktop installed. Does this action allow you to use Microsoft R scripts in your visualization?

A. Yes, it does
B. No, it does not

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You have a table in Power BI Desktop that contains the following data:

You want to create a custom column that only displays the last four digits of the SSN column and masks all the other digits.

Which Power Query M formula should you use?

A. Text.Replace([SSN], Text.Start([SSN],6), “xxx-xx”)
B. Text.ReplaceRange([SSN], 1, 1, “xxx-xx”)
C. Replacer.ReplaceText([SSN], [SSN], “xxx-xx”)
D. Text.TrimStart([SSN], 6)

A

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

You have a Power BI model that has a date table with a date column that displays the date in the format: 2019-12-01

You want the date column to display the date in the format of December 01, 2019. Which DAX formula should you use?
A. FORMAT(‘Date’[Date], @”MMM & “ “ & “DD” & “, “ & “YYYY”)

B. FORMAT(‘Date’[Date], “MMM”) & “ “ & FORMAT(‘Date’[Date], “DD”) & “, “ & FORMAT(‘Date’[Date], “YYYY”)

C. FORMAT(‘Date’[Date], “M”) & “ “ & FORMAT(‘Date’[Date], “D”) & “, “ & FORMAT(‘Date’[Date], [Year])

D. FORMAT(‘Date’[Date], “MMMM DD, YYYY”)

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

You have the two Power Query M queries in Power BI Desktop. The one query retrieves a table named Customers from a Microsoft SQL Server database while the other query retrieves a table named _Customers from an Oracle database

Both the Customers and the _Customers tables have the same columns. You need to combine the data from the two tables.
Which Power Query function should you use?

A. Combine Tables
B. Merge Queries
C. Merge Columns
D. Append Queries

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You have a table named Sales. Sales has a column named CustomerID. The CustomerID column contains a few non-numeric values.

You want to replace the non-numeric values in the CustomerID column with the number 0.

A. From Query Editor, select the CustomerID column and click Replace Values. Then enter null in the Value To Find dialog box and 0 in the Replace With dialog box.

B. From Query Editor, open Advanced Editor and add the following query step: Table.ReplaceNullValues([Sales], {{“Customer_ID”, 0}})

C. From Query Editor, select the CustomerID column and click Sort ascending. Then replace the null values with 0.

D. From Query Editor, select the CustomerID column. Then select Fill > Down.

A

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You want to use Power Query Editor to quickly ascertain the percentage of empty values in each column.

You open the Column profile Data Preview option

Does this action allow you to ascertain the percentage of empty values in each column?

A. Yes, it does
B. No, it does not

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You want to use Power Query Editor to quickly ascertain the percentage of empty values in each column.

You open the Column distribution Data Preview option

Does this action allow you to ascertain the percentage of empty values in each column?

A. Yes, it does
B. No, it does not

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

You want to use Power Query Editor to quickly ascertain the percentage of empty values in each column.

You open the Column quality Data Preview option

Does this action allow you to ascertain the percentage of empty values in each column?

A. Yes, it does
B. No, it does not

A

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You are creating a Power BI report that connects to a Microsoft Excel data source. You create a parameter named DS that specifies the file name and path for the data source.

You want your query to use the DS parameter instead of a hard-coded copy of the location within your query definitions.

What should you do?

A. In the Power Query M code, replace references to the Excel file with the DS parameter.
B. In your query definitions, modify the source step to use the DS parameter as the file path.
C. Create a new query that use the DS parameter.
D. Import the Microsoft Excel data to Power BI.

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You have a Power BI model that contains tables named Sales and Date. The Sales and Date tables are shown in the exhibit:

The tables have the following relationships:

• Sales[Due_Date] and Date[Date]
• Sales[Ship_Date] and Date[Date]
• Sales[Order_Date] and Date[Date] The active relationship is on Sales[Due_Date].
You want to create measures to calculate the number of orders by Ship_Date and the number of orders by Order_Date.

Your solution must not result in duplicated data and must not require the loading additional data. Which two actions could you take? Each correct selection is a complete solution.

A. Create a calculated table and then create a measure that uses the calculated table.
B. Create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.
C. Create two copies of the Date table named ShipDate and OrderDate. The create a measure that uses the ShipDate and OrderDate tables
D. Create measures that use the CALCULATE, COUNT, and FILTER DAX functions.

A

Answer: BD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Your company has a Power BI dashboard that contains different visualizations of sales. You enable Q&A on the dashboard.

You want to provide users with a sample of questions that they can ask when using Q&A. What should you do?

A. In Power BI Settings, configure Subscriptions
B. In Power BI Settings, configure Workbooks
C. In Power BI Settings, configure Dashboards
D. In Power BI Settings, configure Datasets

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You have a Power BI model that contains tables named Sales and Customers. The Sales and Customers tables are shown in the exhibit:

There is a relationship between the Sales and Customers tables.
You want to rank the customers based on their total sales amount. You run the
RANKX(ALL(Customers), SUMX(RELATEDTABLE(Sales), [Sales_amount])) DAX formula.

Does this action produce the desired outcome?

A. Yes, it does
B. No, it does not

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You have a Power BI model that contains tables named Sales and Customers. The Sales and Customers tables are shown in the exhibit:

There is a relationship between the Sales and Customers tables. You want to rank the customers based on their total sales amount.
You run the
RANK.EQ(Sales[Sales_amount], Customers[Customer_ID]) DAX formula.

Does this action produce the desired outcome?

A. Yes, it does
B. No, it does not

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

You have a Power BI model that contains tables named Sales and Customers. The Sales and Customers tables are shown in the exhibit:

There is a relationship between the Sales and Customers tables.
You want to rank the customers based on their total sales amount. You run the
RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customers), [Sales_amount])) DAX formula.

Does this action produce the desired outcome?

A. Yes, it does
B. No, it does not

A

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

You have a Microsoft Excel workbook that has a Power Pivot model with the tables show in the following exhibit:

The model has the following relationships:

  • Sales to Product
  • Sales to Salesperson

You create a new Power BI file and import the Power Pivot model.

You want to create a report that displays the count of products sold by each salesperson. What should you do before you can create the report?

A. Create a one-to-one relationship between Product and Salesperson.
B. For each relationship, change the Cross filter direction to Both.
C. For each relationship, change the Cardinality to One to one (1:1).
D. Create a many-to-one relationship between Product and Salesperson.

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

You have a Microsoft SQL Server database with the tables show in the following exhibit:

You create a Power BI model with the following relationships:

  • Sales to Product
  • Sales to Salesperson

You plan to add a table named Date to the model. The table will have columns for the date, year, month, and end of the last month, and will include data from January 1, 2018 to December 31, 2020.

The Date table and the Sales table will have a relationship. You need to create the columns for the Date table.

Which DAX functions should you use? To answer, drag the appropriate DAX function to the answer area. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

You have a Power BI model for your company’s sales data. You have a measure that calculates the year-to-date sales.

You want to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?

A.	TOTALYTD
B.	PARALLELPERIOD
C.	SAMEPERIODLASTYEAR
D.	PREVIOUSYEAR
E.	DATEADD
A

Answer: C

21
Q

You have a Microsoft SQL Server database that contains the tables as show in the exhibit:

You want to modify the model to report on the number of orders. How would you calculate the number of orders?

A. Create a calculated measure that uses the COUNTA(‘Orders’[Order_id]) DAX formula.
B. Create a calculated column that uses the COUNTA(‘Orders’[Order_id]) DAX formula.
C. Create a calculated column that uses the SUM(‘Orders’[Order_id]) DAX formula.
D. Create a calculated measure that uses the SUM(‘Orders’[Order_id]) DAX formula.

A

Answer: A

22
Q

You have run two queries that have produced two different result sets. You want to concatenate the result sets into one query with all the combined rows.

Which operation should you perform?

A. Append
B. Merge
C. Combine columns

A

Answer: A

23
Q

You have a Power BI model that contains tables named Sales and Customers. The Sales and Customers tables are shown in the exhibit:

There is a relationship between the Sales and Customers tables. There are no reporting requirements on [Customer_ID].

You need to optimize the data model.

What should you configure for [Customer_ID] column?

A. Delete the [Customer_ID] column.
B. Hide the [Customer_ID] column.
C. Sort the [Customer_ID] column.
D. Change the datatype on the [Customer_ID] column.

A

Answer: B

24
Q

You plan to create a report in Power BI Desktop. You have the following tables.

The Date table is marked as a date table. DateID is the date data type. Your report must include an annual sales growth percentage measure. Which DAX expression should you use?
A. CALCULATE(SUM(Sales[SalesAmount), SAMEPERIODLASTYEAR(‘Date’[DateID])

B. SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(‘Date’[DateID])) /

CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR (‘Date’[DateID])

C. CALCULATE(SUM(Sales[SalesAmount)), DATESYTD(‘Date’[DateID]))

D. SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(‘Date’[DateID])

A

Answer: B

25
Q

You have five sales office. Each office has a single sales person.

You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by the sales person. Each sales person must see only the data from their office.

You publish the dataset to the company website, set RLS role membership, and distribute the dataset and related reports to the sales persons.

A sales person reports that data is missing from the dataset that she can view. You need to verify what data the salesperson currently sees.
What should you do?

A. Use the Test as role option to view data as the salesperson’s user account.
B. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
C. Instruct the salesperson to open the report in Microsoft Power BI Desktop.
D. Use the Test as role option to view data as the Sales role.

A

Answer: D

26
Q

You have several Power BI visualizations that you want to embed in a public website. Which two visualizations can you embed into the website?
NOTE: Each correct selection is worth one point.

A. Visualizations that use row-level security (RLS)
B. Visualizations that use datasets stored in Microsoft OneDrive for Business
C. Custom visualizations
D. Visualizations that contain reports shared to your user account
E. Q&A for Power BI visuals
F. Visualizations that use report-level DAX measures.

A

Answer: BC

27
Q

You have a workspace that contains a dashboard named Sales Data. The Sales Data dashboard displays data from two datasets.

Users complain that natural language queries on the dashboard often returns on results. You want users to be able find data by using natural language queries.
You open the settings of the workspace and modify the Language Settings. Does this action allow users to find data by using natural language queries?
A. Yes, it does
B. No, it does not

A

Answer: B

28
Q

You have a workspace that contains a dashboard named Sales Data. The Sales Data dashboard displays data from two datasets.

Users complain that natural language queries on the dashboard often returns on results. You want users to be able find data by using natural language queries.
You open the properties of the datasets and modify the Q&A and Cortana settings. Does this action allow users to find data by using natural language queries?
A. Yes, it does
B. No, it does not

A

Answer: A

29
Q

You have a workspace that contains a dashboard named Sales Data. The Sales Data dashboard displays data from two datasets.

Users complain that natural language queries on the dashboard often returns on results. You want users to be able find data by using natural language queries.
You open the properties of the Sales Data dashboard, modify the Q&A settings. Does this action allow users to find data by using natural language queries?

A. Yes, it does
B. No, it does not

A

Answer: B

30
Q

You have a Microsoft Excel spreadsheet that contains a table named Sales. You want to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?

A. From the Power BI service, import the data from the Excel workbook.
B. From Excel, publish the workbook to the Power BI service.
C. From the Power BI tab in Excel, pin the table.
D. From the Power BI service, upload the Excel workbook.

A

Answer: C

31
Q

You have a dashboard that has Q&A enabled.

When a user runs the query “count of clients” in Q&A, the user does not receive any results. However, when the user runs the query “count of subscribers”, the user receives the expected results.

You want the user to receive the same results when using either query. Which action should you take?

A. In the dashboard, enable and configure Data classification.
B. In your data model, add synonyms to tables and columns.
C. In Power BI, create featured questions.
D. Add a description of “subscribers” to the dashboard.

A

Answer: B

32
Q

You are creating a visual that will rank product categories by sales revenue. Your solution must ensure that data is not sent outside of your Microsoft Power BI tenant.

What should you do?

A. Use default or any custom visuals from the marketplace.
B. Use default or certified custom visuals.
C. Use default visuals or custom visuals uploaded from a .pbiviz file.
D. Use only default visuals.

A

Answer: B

33
Q

You have a report that contains several visualizations. One of the visualizations is a KPI visualization.

You need to filter all the visualizations in the report except the KPI visualization. Which two actions should you perform? Each correct answer is part of the solution. (Choose two.)

NOTE: Each correct selection is worth one point

A. Add the same slicer to each page and configure Sync slicers.
B. Edit the interactions of the KPI visualization.
C. Configure a page-level filter.
D. Edit the interactions of the slicer that is on the same page as the KPI visualization.
E. Configure a report-level filter.

A

Answer: AB

34
Q

You are using Microsoft Power BI. You want to add multimedia objects that are published to Microsoft Stream to the Power BI dashboard.

What action should you take?

A. Add a Video tile
B. Add a Custom streaming data tile
C. Add a Web content tile
D. Add an Image tile

A

Answer: B

35
Q

You are developing a report page in Microsoft Power BI Desktop. Some of your users will use a screen reader to consume the report. You want these users to consume report in a chronological order. What action should you take?

A. In Microsoft Power BI Desktop, configure the tab order
B. In Microsoft Power BI Desktop, configure the layer order
C. In Microsoft Power BI Desktop, configure the bookmark order
D. In Microsoft Power BI Desktop, configure the sort order

A

Answer: A

36
Q

You have a Power BI model that contains tables named Sales and Customers. The Sales and Customers tables are shown in the exhibit:

There is a relationship between the Sales and Customers tables. The Sales table contains more than one million records.
You want to import a sample of the data from the Sales table. What action could you take?

A. In the Power BI model, create a calculated table.
B. In the Power Query Editor, transform the Sales table.
C. In the Power Query Editor, filter the Sales table by Sales_Date.
D. In the Power Query Editor, create a column by using Column From Examples.

A

Answer: C

37
Q

You have the tables show in the following exhibit:

More than 10 million Sales records are generated every month.

You want to create an analytics system displays the number of sales per day, per product, and per sales person. You also want to ensure that the data model is as small as possible.

You create the following many to one relationships:

• Sales to Product
• Sales to Salesperson What should you do next?
A. For each relationship, change the Cross filter direction to Both.
B. Group the sales by Order_Date, Product_id, and Salesperson_id. Then aggregate by using the CountRows function.
C. Create a new group on the Sales_Amount column and set the Group type to Bin.
D. Create a new hierarchy that summarizes the data by the Sales_Amount column.

A

Answer: B

38
Q

Your company has a Microsoft Excel file that stores purchase data. The Excel file has a date and time column named Date_Time. The Date_Time column contains data in the format:

2020-08-13 13:46:83

You want to use a built-in date hierarchy to analyze the purchase data by the date. How should you prepare the data in the Date_Time column?
A. Create a script that removes the time portion of the Date_Time column.
B. Add a new column named Date and use regular expressions to trim the data to the first 10 characters.
C. Add a new column named Date using the following formula: TransformColumnTypes(Source,{{“Date_Time”, type datetime}})
D. Add a new column by example that starts with 2020-08-13. Set the data type of the new column to Date.

A

Answer: D

39
Q

You have a dataset that contains sales data by sales person.

You want to create a visual that shows the top 5 performing sales persons based on their total sales value.

You create a visual with a Top N filter.

Does this action show the top 5 performing sales persons based on sales value?

A. Yes, it does
B. No, it does not

A

Answer: A

40
Q

You have a table maned Sales that contains sales data by sales person.

You want to create a visual that shows the top 5 performing sales persons based on their total sales value.

You use the following DAX function:

TOPN(5, Sales, orderBy (SalesPerson, TotalSales))

Does this action show the top 5 performing sales persons based on sales value?

A. Yes, it does
B. No, it does not

A

Answer: B

41
Q

Your company has a data model for its sales data. The sales data has a column named Date. You want to view the data by week.
What action should you take to quickly view sales data by week?

A. Create a new aggregation that summarizes by date.
B. Create a new group on the Date column and set the Group type to List.
C. Create a new group on the Date column and set the Group type to Bin.
D. Create a new hierarchy that summarizes by date.

A

Answer: C

42
Q

You have a user named MiaHamm. MiaHamm is a member of a security group named PowerBI Users.

MiaHamm has access to a workspace.

You want to prevent MiaHamm from exporting data from the visualizations in the workspace. You open Microsoft 365 Admin center and remove MiaHamm from the All Users security group.
Does this action prevent MiaHamm from exporting data from the visualizations in the workspace?

A. Yes, it does
B. No, it does not

A

Answer: B

43
Q

You have a user named MiaHamm. MiaHamm is a member of a security group named PowerBI Users.

MiaHamm has access to a workspace.

You want to prevent MiaHamm from exporting data from the visualizations in the workspace.

You open Microsoft 365 Admin center and modify the properties of the PowerBI Users security group.

Does this action prevent MiaHamm from exporting data from the visualizations in the workspace?

A. Yes, it does
B. No, it does not

A

Answer: A

44
Q

You have an app workspace named Sales Analysis in the Power BI service. You have the following requirements:
• Manage users that have access to the app workspace

Your solution must require the least amount of administrative effort. What should you do?

A. In the Microsoft 365, select Users.
B. In the Power BI, select Tenant settings.
C. In the Power BI, select Usage metrics.
D. In the Microsoft 365, select Members.

A

Answer: D

45
Q

You have Power BI report that is published to your company’s public website.

You want the report on the website to update automatically when the data is refreshed. What should you do in the Power BI service?

A. Publish the app workspace to the entire organization. In the website, use the URL of the app workspace.
B. Share the report. In the website, use the URL of the dashboard.
C. Publish the report to the web. In the website, use the embed code URL.
D. In the website, use the URL of the report.

A

Answer: C

46
Q

Your company has a Power BI workspace with several shared dashboards.

You need to provide a user named user1@company.com with the permissions to edit and publish dashboards.

What should you do?

A. Modify the members of the app workspace.
B. Configure security for the dataset used by the app.
C. Modify the Access settings of the dashboards.
D. In workspace, select Update, and then configure the Access settings.

A

Answer: C

47
Q

You are creating a Power BI report based on data from an Azure Analysis Services cube. You want the Power BI report to update as soon as data in the cube is refreshed.
How should you connect to the Azure Analysis Services cube?

A. Import
B. Connect Live
C. Direct query

A

Answer: B

48
Q

Your company has a Microsoft Power BI workspace.

You are required to grant a user that has a user account named MiaHamm with the permissions required to create and publish Power BI apps.

You must not provide the MiaHamm account with excessive permissions. What role should you assign to the MiaHamm account?

A. Admin
B. Member
C. Contributor
D. Viewer E Owner

A

Answer: B

DA-100 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions