Brainscape's Knowledge GenomeTM

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


See full index

D365 > DA-100 > Flashcards

DA-100 Flashcards

1
Q

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
B. Remove the Subject and Body columns during the import.
C. From Model view, set the Subject and Body columns to Hidden.

A

B. Remove the Subject and Body columns during the import.

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

You have the tables shown in the following table.
https://imgur.com/a/BnQ6Mbb
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
✑ Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
✑ Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.

A. Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.
B. Create one-to-many relationships between the tables.
C. Create a calculated measure that aggregates by using the COUNTROWS function.
D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.

A

A. Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.
B. Create one-to-many relationships between the tables.

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

Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
A. video
B. custom streaming data
C. text box
D. web content

A

D. web content

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

You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
A. Show whitespace
B. Column profile
C. Column distribution
D. Column quality

A

D. Column quality

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

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
✑ First name
✑ Last name
✑ Email address
✑ State/Region
✑ Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.

A. Open the Advanced Editor.
B. Select Column quality.
C. Enable Column profiling based on entire dataset.
D. Select Column distribution.
E. Select Column profile.
A

C. Enable Column profiling based on entire dataset.

E. Select Column profile.

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

HOTSPOT -
You have an API that returns more than 100 columns. The following is a sample of column names.
✑ client_notified_timestamp
✑ client_notified_source
✑ client_notified_sourceid
✑ client_notified_value
✑ client_responded_timestamp
✑ client_responded_source
✑ client_responded_sourceid
✑ client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.

https://imgur.com/a/yOkpxtU

A
  1. Remove Column
  2. List.Select
  3. Text.EndsWith
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

DRAG DROP -
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in
Microsoft Power BI reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

  • Expand the columns.
  • Expand the records.
  • Add columns that use data type conversions.
  • Set the data types.
  • Convert the list to a table.
A
  1. Convert list to Table
  2. Expand Column
  3. Set Date type
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
✑ Customer ID
✑ Customer Name
✑ Phone
✑ Email Address
✑ Address ID
Address contains the following columns:
✑ Address ID
✑ Address Line 1
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
✑ Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?
A. Merge the Customer and Address tables.
B. Transpose the Customer and Address tables.
C. Group the Customer and Address tables by the Address ID column.
D. Append the Customer and Address tables.

A

A. Merge the Customer and Address tables.

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

You have the following three versions of an Azure SQL database:
✑ Test
✑ Production
✑ Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
A. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
B. Create a parameter and update the queries to use the parameter.
C. Create a query for each database server and hide the development tables.
D. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

A

B. Create a parameter and update the queries to use the parameter.

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

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
A. Change the data type of the Logged column to Date.
B. Apply the Parse function from the Date transformations options to the Logged column.
C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
D. Apply a transform to extract the first 11 characters of the Logged column.

A

C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

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

You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
A. Add a SQL statement.
B. Set Data Connectivity mode to DirectQuery.
C. Set the Command timeout in minutes setting.
D. Set Data Connectivity mode to Import.

A

B. Set Data Connectivity mode to DirectQuery.

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

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
A. Split the model into multiple models.
B. Hide unused columns in the model.
C. Merge tables by using Power Query.
D. Transpose.

A

C. Merge tables by using Power Query.

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

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?
A. Round the hour of the Date column to startOfHour.
B. Change the data type of the Date column to Text.
C. Trim the Date column.
D. Split the Date column into two columns, one that contains only the time and another that contains only the date.

A

D. Split the Date column into two columns, one that contains only the time and another that contains only the date.

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

DRAG DROP -
You are modeling data in a table named SalesDetail by using Microsoft Power BI.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order,
Select and Place:
https://imgur.com/a/WywxTCx

A

https://imgur.com/a/XFFAOKM

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

You create the following step by using Power Query Editor.
- Table.ReplaceValue(SalesLT_Address,”1318”,”1319”,Replacer.ReplaceText,{“AddressLine1”})
A row has a value of 21318 Lasalle Street in the AddressLine1 column.
What will the value be when the step is applied?
A. 1318
B. 1319
C. 21318 Lasalle Street
D. 21319 Lasalle Street

A

D. 21319 Lasalle Street

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

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
A. Change any DAX measures to use iterator functions.
B. Replace the default visuals with AppSource visuals.
C. Change the imported dataset to DirectQuery.
D. Remove unused columns from tables in the data model.

A

D. Remove unused columns from tables in the data model.

17
Q

You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year.
You grant users access to the dashboard by using the Viewer role on the workspace.
A user wants to receive daily notifications of the number shown on the card visual.
You need to automate the notifications.
What should you do?
A. Create a data alert.
B. Share the dashboard to the user.
C. Create a subscription.
D. Tag the user in a comment.

A

C. Create a subscription.

18
Q

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?
A. Yes
B. No

A

A. Yes

19
Q

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?
A. Yes
B. No

A

A. Yes

20
Q

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
A. Yes
B. No

A

B. No

21
Q

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You modify the source step of the queries to use DataSourceExcel as the file path.
Does this meet the goal?
A. Yes
B. No

A

A. Yes

22
Q

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?
A. Yes
B. No

A

B. No

23
Q

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a report-level filter that filters based on the order date.
Does this meet the goal?
A. Yes
B. No

A

B. No

24
Q

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?
A. Yes
B. No

A

B. No

25
Q

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
A. Apply the Parse function from the Date transformations options to the Logged column.
B. Create a column by example that starts with 2018-12-31.
C. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
D. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

A

D. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

26
Q

DRAG DROP -
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
https://imgur.com/a/679Dwzh
You need to prepare the data to support the following:
Visualizations that include all measures in the data over time

✑ Year-over-year calculations for all the measures
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
https://imgur.com/a/OvhJ0wc

A
  1. Use the first role as header
  2. Unpivot all the columns except the measure column
  3. Change the column attribute to year
  4. Change the datatype of year to date
27
Q

HOTSPOT -
You are creating a quick measure as shown in the following exhibit.
https://imgur.com/a/1mb7xZL
You need to create a monthly rolling average measure for Sales over time.
How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.

https://imgur.com/a/RVQ42xm

A

Base value: Total Sales

Date: Date

Period: Months

28
Q

You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
A. Change the Microsoft Power BI license type of the sales manager.
B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.
C. Request that the sales manager be added to the correct Azure Active Directory group.
D. Manage the permissions of the underlying dataset.

A

C. Request that the sales manager be added to the correct Azure Active Directory group.

D365 (9 decks)

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