Assessment Summary
0 of 10 Questions completed
Questions:
Information
You have already completed the assessment before. Hence you can not start it again.
Assessment is loading…
You must sign in or sign up to start the assessment.
You must first complete the following:
Results
Results
0 of 10 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 10
1. Question
Near real-time fraud detection
Your company stores transaction data in an Azure SQL database. You need to build a Power BI report to flag potentially fraudulent transactions, and new records must be visible in the report within about five minutes of being written.
Which data connectivity mode should you choose?CorrectIncorrect -
Question 2 of 10
2. Question
No native connector (Cassandra scenario)
You want to connect Power BI Desktop to a Cassandra database, but you discover that there is no dedicated Cassandra connector in the Get Data list.
Which connector should you use instead?CorrectIncorrect -
Question 3 of 10
3. Question
Cleaning a date/time text column
A CSV file of customer complaints has a column called Logged with values like:
2018-12-31 at 08:59
You want to analyze complaints by date using Power BI’s built-in date hierarchy.
What is the most appropriate first transformation in Power Query?CorrectIncorrect -
Question 4 of 10
4. Question
Joining Customer and Address tables
You import two tables into Power Query:
- Customers: CustomerID, Name, Phone, Email, AddressID
- Addresses: AddressID, AddressLine1, City, Region, Country, PostalCode
Each CustomerID is unique in Customers and each AddressID is unique in Addresses. You need a single query with one row per customer that also shows the City, Region, and Country.
What should you do in Power Query?CorrectIncorrect -
Question 5 of 10
5. Question
Reusing an existing model (dataset)
A Power BI report for the sales team already exists and imports data from an Excel file in SharePoint. The dataset includes several useful measures.
You want to build a new report using the same model and measures, with minimal development effort.
Which data source should you use for the new report?CorrectIncorrect -
Question 6 of 10
6. Question
Dataflow with daily refresh
A BI developer has created a Power BI dataflow that uses DirectQuery to an on-premises SQL Server, and the Enhanced Compute Engine is enabled. You now want to build a report from this dataflow with these goals:
- Minimize online processing and calculation time
- Ensure the report includes data up to yesterday
- Keep visuals responsive for users
Which approach should you take when connecting the report to the dataflow?
CorrectIncorrect -
Question 7 of 10
7. Question
Refreshing Excel on a file server
You have a Power BI report that imports a table from an Excel file stored on a Windows file server. After publishing the report, you want the data to refresh every four hours from that on-premises file.
What must you configure first?CorrectIncorrect -
Question 8 of 10
8. Question
Reducing model size without slowing queries
You have a Power BI semantic model running in Import mode called Model1. The dataset has grown large, and you want to reduce its size but not make report queries slower.
What is the best action?CorrectIncorrect -
Question 9 of 10
9. Question
Keeping only the year
In Power Query, you preview a column called Date and decide you only need the year (for example, 2024) for reporting. You want to meet this requirement with minimal ongoing maintenance.
What should you do?CorrectIncorrect -
Question 10 of 10
10. Question
Simplifying a connection for another user
You created a Power BI Desktop report (PBIX) using an Azure SQL Database as the source. Another analyst needs to create their own report using the same connection details, and you want to make it as easy as possible for them to connect.
Which file type should you create and share with them?CorrectIncorrect