Exam (elaborations)
DA-100 Analyzing Data with Microsoft Power BI Test Bank
- Course
- Institution
DA-100 Analyzing Data with Microsoft Power BI Test Bank
[Show more]
Seller
Follow
tutorsection1
Reviews received
Content preview
DA-100 Analyzing Data with Microsoft Power BI TestBank
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. - ANSWER D. Split the Date column into two
columns, one that contains only the time and another that contains only the date.
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. - ANSWER ·
B. Remove the Subject and Body columns during the import.
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. -
ANSWER 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.
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 - ANSWER · D. web content
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 - ANSWER · D. Column quality
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?
· 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. - ANSWER · C. Enable Column profiling based on entire
dataset.
· E. Select Column profile.
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. - ANSWER
1. Remove Column
2. List.Select
3. Text.EndsWith
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: - ANSWER
1. Convert the list to a table
2. Expand the columns
3. Set the data types
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. - ANSWER · A. Merge the
Customer and Address tables.
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. - ANSWER · B. Create a parameter and update the
queries to use the parameter.
You have a data model that contains many complex DAX expressions. The
expressions contain frequent references to the RELATED and RELATEDTABLE
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller tutorsection1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now