Exam (elaborations)
DA-100, DA-100, Data analyst Latest Exam And Answers 2024
- Course
- Institution
DA-100, DA-100, Data analyst Latest Exam And Answers 2024
[Show more]
Seller
Follow
Content preview
DA-100, DA-100, Data analyst LatestExam And Answers 2024
D. Split the Date column into two columns, one that contains only
the time and another that contains only the date. - correct
answers✅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.
· B. Remove the Subject and Body columns during the import. -
correct answers✅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. Group the impressions by Ad_id, Site_name, and
Impression_date. Aggregate by using the CountRows function.
,DA-100, DA-100, Data analyst Latest
Exam And Answers 2024
B. Create one-to-many relationships between the tables. - correct
answers✅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.
· D. web content - correct answers✅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
,DA-100, DA-100, Data analyst Latest
Exam And Answers 2024
· D. Column quality - correct answers✅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
· C. Enable Column profiling based on entire dataset.
· E. Select Column profile. - correct answers✅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.
, DA-100, DA-100, Data analyst Latest
Exam And Answers 2024
· E. Select Column profile.
1. Remove Column
2. List.Select
3. Text.EndsWith - correct answers✅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.
1. Convert the list to a table
2. Expand the columns
3. Set the data types - correct answers✅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
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 Ammelia. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. 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