Exam (elaborations)
DA100 Power Bi- Test Practice Questions with 100% Correct Answers |Verified
- Course
- Institution
DA100 Power Bi- Test Practice Questions with 100% Correct Answers |Verified
[Show more]
Content preview
DA100 Power Bi- Test Practice Questions with100% Correct Answers |Verified
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. - ✔✔B
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. - ✔✔C
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. - ✔✔B
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. - ✔✔C
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. - ✔✔D
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 - ✔✔D
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. - ✔✔C
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. - ✔✔C
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?
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 Examsplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.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