Quest Global Technical Architect Interview Questions and Answers

DELETE is used to remove rows from a table while keeping the table structure intact. DROP is used to remove an entire table from the database.

• DELETE is a DML (Data Manipulation Language) command, while DROP is a DDL (Data Definition Language) command.

• DELETE can be rolled back, while DROP cannot be rolled back.

• Example: DELETE FROM table_name WHERE condition; DROP TABLE table_name;

Autocalender creates a date table automatically, while duplicate creates a copy of a table and reference creates a linked table in Power BI.

• Autocalender automatically generates a date table based on the data in your model.

• Duplicate creates a copy of a table with the same data and structure.

• Reference creates a linked table that shares the same data as the original table.

• Autocalender is useful for quickly creating date t...read more

Design a user access control system with granular control for pages, controls, data, and response masking.

• Implement role-based access control (RBAC) to assign permissions to users based on their roles.

• Utilize attribute-based access control (ABAC) for more fine-grained control over access to specific pages, controls, and data.

• Implement data masking techniques to ensure sensitive information is not exposed in responses.

• U...read more

Optimizing sparse array access involves using data structures like hash maps or trees to efficiently store and retrieve values.

• Use a hash map to store only non-null values and their corresponding indices.

• Implement a tree-based data structure like a binary search tree or a trie for faster access to sparse array elements.

• Consider using a compressed sparse row (CSR) format for large sparse arrays to reduce memory usage an

Designing MakeMyTrip application

• Identify user requirements and create a user-friendly interface

• Integrate APIs for flight, hotel, and cab bookings

• Implement secure payment gateway and user authentication

• Ensure scalability and performance optimization

• Provide personalized recommendations based on user history

Virtual DOM is a lightweight copy of the actual DOM in React, used for efficient updates.

• Virtual DOM is a concept where a lightweight copy of the actual DOM is created in memory.

• When changes are made to the virtual DOM, React compares it with the actual DOM to identify the minimal number of updates needed.

• This process helps in optimizing performance by reducing the number of actual DOM manipulations.

• Example: When a use...read more

Implementing passwordless system involves using alternative authentication methods.

• Use email or SMS verification codes

• Implement biometric authentication

• Utilize hardware security keys

• Implement OAuth or OpenID Connect for single sign-on

• Leverage FIDO2 standards for passwordless authentication

To create a cookieless system, use alternative methods like local storage or URL parameters for tracking user data.

• Use local storage to store user data on the client side

• Utilize URL parameters to pass data between pages

• Implement server-side session management for user authentication

• Consider using JSON Web Tokens (JWT) for secure data transmission

S.O.L.I.D principles are a set of five design principles in object-oriented programming to make software designs more understandable, flexible, and maintainable.

• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should b...read more