top of page
Microsoft - Dynamics 365
Interview Preparation - Tables & Columns
Learn how to prepare for Dynamics 365 CRM interviews by exploring Tables & Columns, including table types, column data types, configuration, customization, and data management through practical, real-world scenarios and topic-wise interview questions.
Dynamics 365 CRM – Power Apps: Tables & Columns – Interview Questions
PowerNexus Academy | Topic-Wise Interview Preparation
Below are 40 interview questions on Tables and Columns in Dynamics 365 CRM and Power Apps, organized into five sections. These questions cover table fundamentals, table types, column types, configuration, data management, and practical business scenarios relevant to Dynamics 365 CRM and Power Platform developers.
The questions are suitable for beginners, intermediate developers, and experienced professionals preparing for Microsoft Dynamics 365 CRM and Power Platform technical interviews.
Tables Fundamentals in Dynamics 365 CRM :
-
What is a table in Dynamics 365 CRM, and why is it used?
-
What is the difference between a table and an entity in Dynamics 365 CRM?
-
What are the different types of tables available in Microsoft Dataverse?
-
What is the difference between standard tables and custom tables in Dynamics 365 CRM?
-
What is the difference between user-owned, team-owned, and organization-owned records?
-
What are the key components of a table in Microsoft Dataverse?
-
How do you create a custom table in Power Apps?
-
What is the difference between a table's display name, plural name, schema name, and logical name?
-
What is the purpose of the primary name column and primary ID column in a Dataverse table?
-
What happens when you delete a custom table in Dynamics 365 CRM?
Types of Tables and Table Configuration :
-
What is the difference between standard, activity, virtual, and elastic tables in Microsoft Dataverse?
-
What is an activity table, and how is it different from a regular table?
-
What is a virtual table, and when should it be used in Dynamics 365 CRM?
-
What is an elastic table in Dataverse, and how does it differ from a standard table?
-
What is the purpose of enabling attachments and notes for a table?
-
What is the difference between enabling auditing and change tracking for a table?
-
What is the purpose of enabling a table for queues in Dynamics 365 CRM?
-
What are the implications of enabling activities for a custom table?
Columns Fundamentals and Data Types :
-
What is a column in Dynamics 365 CRM, and how is it different from a field?
-
What are the different column data types available in Microsoft Dataverse?
-
What is the difference between Single Line of Text and Multiple Lines of Text columns?
-
What is the difference between Whole Number, Decimal Number, Floating Point Number, and Currency columns?
-
What is the difference between Choice, Choices (multi-select), and Yes/No columns?
-
What is the difference between a Lookup column and a Choice column?
-
What is the difference between Customer, Owner, and standard Lookup columns?
-
What is the difference between Date Only and Date and Time columns?
-
What is the difference between User Local and Time Zone Independent date/time behavior?
-
What is the difference between simple, calculated, formula, and rollup columns in Dataverse?
Column Configuration and Data Management :
-
How do you create a custom column in an existing Dataverse table using Power Apps?
-
What is the difference between Business Required, Business Recommended, and Optional column requirement levels?
-
What is the difference between a global choice and a local choice in Dataverse?
-
What is the purpose of default values in Dataverse columns, and how do you configure them?
-
Can you change the data type of an existing column after creating it? What are the limitations?
-
What is the difference between deleting a column and removing a column from a form?
-
What happens to existing records when you change a column's requirement level from Optional to Business Required?
Real-Time Scenario-Based Interview Questions :
1. Custom Table Creation: A company wants to maintain employee training details, including Employee Name, Course Name, Training Date, and Training Status. How would you create and configure a custom table and its columns in Power Apps?
2. Choice Column Configuration: A business wants to maintain a Case Priority column with Low, Medium, High, and Critical values. Would you use a Choice column or a Lookup column, and why?
3. Calculated and Rollup Columns: A company wants to automatically calculate the total value of all related orders for a customer. Which type of column would you use, and how would you configure it?
4. Column Data Type Changes: A developer created a Single Line of Text column to store customer age, but the business now requires numeric validation and calculations. How would you handle this requirement without losing existing data?
5. Column Security and Visibility: A company maintains employee salary information in a custom Dataverse table. Only HR managers should be able to view and update the Salary column. How would you configure this requirement using Dataverse column-level security?
Interview Preparedness
Strengthen your Entities & Fields knowledge through practical interview questions, real-world project scenarios, technical discussions, and personalized guidance to confidently prepare for your next job opportunity.
✓ Live Instructor Training
✓ Hands-on Practice
✓ Real-World Projects
✓ Interview Preparation
✓ Doubt Clarification
bottom of page
