PL-900 Practice Question: Manage the Microsoft Power Platform environment
A Power Platform administrator is reviewing the capacity of a production environment. The environment has a database size of 2 GB, file storage of 10 GB, and log storage of 1 GB. The tenant has a total of 10 GB of database capacity, 50 GB of file capacity, and 2 GB of log capacity. The administrator notices that the production environment is consuming a disproportionate amount of database capacity. Which action should the administrator take to identify the largest tables in the environment?
⚠ Common exam trap
The trap here is assuming that record counts or maker portal properties directly reflect storage size, or that the TDS endpoint can be used for administrative metadata queries.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
In the Power Platform admin center, select the environment, then go to Analytics > Dataverse, and view the 'Table size' report.
The Power Platform admin center includes Dataverse analytics that provide detailed storage usage reports. The 'Table size' report specifically lists each table and its size, enabling administrators to pinpoint which tables are consuming the most database capacity. This is the intended and supported method for storage analysis at the table level.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use the Microsoft Dataverse API to retrieve metadata for all tables and calculate their sizes using the 'RetrieveTotalRecordCount' message.
Why it's wrong here
The 'RetrieveTotalRecordCount' message returns the number of records in a table, not the storage size. While record count can correlate with size, it does not provide the actual storage consumption, which depends on record size and data types. This method is also more complex and does not directly give the size in MB.
- ✗
In the Power Apps maker portal, open each table and check the 'Table properties' for the 'Storage size' field.
Why it's wrong here
The Power Apps maker portal does not display the storage size of individual tables in the table properties. Storage size is an administrative metric available through the Power Platform admin center analytics. Makers cannot see this information in the maker portal, making this approach ineffective.
- ✓
In the Power Platform admin center, select the environment, then go to Analytics > Dataverse, and view the 'Table size' report.
Why this is correct
The Power Platform admin center provides Dataverse analytics that include storage usage by table. The 'Table size' report shows the size of each table in the environment, allowing administrators to identify which tables consume the most database capacity. This is the correct tool for analyzing table-level storage consumption without writing custom queries.
- ✗
Run a SQL query against the Dataverse database using the TDS endpoint to select table names and their sizes from the sys.tables view.
Why it's wrong here
The TDS endpoint allows read-only SQL access to Dataverse data, but it does not expose system views like sys.tables or storage size information. Querying such views is not supported and will fail. Additionally, the TDS endpoint is intended for reporting on data, not for administrative storage analysis.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 701-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.