Microsoft Certified Power Platform Functional Consultant Associate · Free Practice Question Medium
Question 48
Identify the missing word(s) in the following sentence within the context of Microsoft Power Platform.
Scenario: The Red Lion National Bank is an offshore firm managed by Felix Manning and Wilson Fisk. The bank is migrating to Microsoft Dataverse and has hired you to ask an Expert Consultant to oversee their IT team and to assist as needed.
At this time, the IT team is planning the structure of a Dataverse standard table which has 10,212 columns. You being the Expert Consultant, plan to advise the group that … [?]
-
A
there is likely a better way to design the table since having that many columns is excessive.
-
B
their plan exceeds the physical limits of a Dataverse table (10,000 columns maximum).
-
C
their plan seems sound so far, the number of columns will be dependant on the number of rows as well.
-
D
their plan seems sound so far since there is no limit to the number of columns on a Dataverse table.
Reveal correct answer
Correct answer: A
Explanation
Define columns in Microsoft Dataverse
Columns are a way to store a discrete piece of information within a record in a table. Columns have types, meaning that you can store data of a certain type in a field that matches that data type.
For example, if you have a solution that requires dates, then you would store the date in a field with the type of Date. Similarly, if you want to store a number, then you store the number in a field with the type of Number.
The number of columns within a table varies from a few columns to a hundred or more. If you need more than a few hundred columns in a table, you might want to reconsider how you are structuring data storage for your solution because, likely, there is a better way.
Every database in Microsoft Dataverse starts with a standard set of tables and each standard table has a standard set of columns.
Tip: Always use standard tables and columns when possible. You can rename a table if that makes the table more understandable in the context of your solution. Always review the list of standard tables and make sure a standard table will not meet your needs before you create a new table.
A. Having 10,212 columns in a Dataverse standard table is excessive and may indicate a need for a better design approach. It is recommended to consider restructuring the table to improve performance and maintainability.
B. The statement that the plan exceeds the physical limits of a Dataverse table with a maximum of 10,000 columns is incorrect. Dataverse does not have a hard limit of 10,000 columns, so the plan does not violate any physical constraints.
C. The number of columns in a Dataverse table should not be solely dependent on the number of rows. It is important to consider the overall design, performance implications, and usability of the table structure. Having a large number of columns can impact query performance and data management.
D. While there is no explicit limit to the number of columns on a Dataverse table, having 10,212 columns may still raise concerns about the table's design, performance, and usability. It is advisable to review and optimize the table structure.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
