20+ Consultant Engineer Interview Questions and Answers

The quantity of work that can be done with 1 bag of cement varies depending on the type of work.

• 1 bag of cement can be used to lay approximately 70-80 standard bricks

• 1 bag of cement can be used to plaster approximately 10-12 square meters of wall

• 1 bag of cement can be used to create approximately 3-4 cubic meters of concrete

• 1 kg of putty/paint can cover approximately 10-12 square meters of wall

To scale the app database over India, consider sharding, replication, and using cloud services.

• Implement sharding to distribute data across multiple servers based on geographic location or other criteria.

• Set up replication to ensure data consistency and availability in different regions.

• Utilize cloud services like AWS or Azure to easily scale resources based on demand.

• Optimize queries and indexes to improve database performance.

• Consider using a content delivery network (CDN) ...read more

The 3 basic components of a database are data, schema, and software. An RCA for a DB being down involves identifying the root cause of the issue.

• Data: the actual information stored in the database, such as customer records or product details.

• Schema: the structure that defines how the data is organized and related to each other, including tables, fields, and relationships.

• Software: the database management system (DBMS) that allows users to interact with the data, such as MySQL...read more

The eave height of a pre-engineered building with vertical connection of column and rafter can be found using trigonometry and the dimensions of the building components.

• Calculate the vertical distance between the top of the column and the bottom of the rafter using trigonometry

• Add this vertical distance to the height of the column to get the eave height

• Ensure to consider any additional factors such as roof slope or overhangs in the calculation

Understanding IT infrastructure involves analyzing network architecture, hardware, software, security measures, and data management.

• Reviewing network diagrams and documentation to understand the layout and connections

• Analyzing server configurations and virtualization setups

• Assessing security protocols and measures in place

• Examining software applications and licenses used

• Understanding data storage and backup solutions implemented

I am proficient in English and Spanish.

• English

• Spanish

A multi-level parking system schema design involves creating a database to manage parking spots and their availability.

• Create a database to store information about parking spots, levels, and availability

• Design a user interface for customers to view available spots and reserve them

• Implement a system to track the entry and exit of vehicles

• Incorporate sensors or cameras to monitor parking spot availability

• Consider integrating payment processing for parking fees

We have used a combination of containerization and orchestration tools like Docker and Kubernetes for our microservices architecture.

• We have followed the principles of domain-driven design to identify the boundaries of our microservices.

• We have used RESTful APIs for communication between microservices.

• We have implemented fault tolerance and resilience patterns like circuit breakers and retries.

• We have used event-driven architecture for asynchronous communication between micro...read more

Start tiling from the center of the wall and work your way outwards.

• Find the center point of the wall and mark it.

• Start tiling from the center point and work your way outwards.

• Use a spirit level to ensure the tiles are straight.

• Leave space for grouting between tiles.

• Cut tiles to fit around fixtures and edges.

• Finish with a row of half tiles at the top or bottom.

grep is a Linux command used to search for a specific pattern in a file or multiple files.

• Used to search for a specific pattern in a file or multiple files

• Can be used with regular expressions for more complex searches

• Can be used with other commands like find and xargs for more advanced searches

• Examples: grep 'hello' file.txt, grep -r 'hello' /path/to/directory

I have handled a variety of materials including steel, concrete, wood, and plastics.

• Steel

• Concrete

• Wood

• Plastics

Before tiling at bath/toilets, it is important to prepare the surface properly to ensure a long-lasting and durable finish.

• Ensure the surface is clean and free of any debris or dust.

• Check for any cracks or damage and repair them before tiling.

• Apply a waterproofing membrane to prevent water damage.

• Allow the surface to dry completely before tiling.

• Use the appropriate adhesive and grout for the type of tiles being used.

• Consider using a tile leveling system to ensure a flat and e...read more

Governing criteria for substructure design

• Soil properties and bearing capacity

• Loads and forces acting on the substructure

• Environmental factors such as seismic activity and wind loads

• Building codes and regulations

• Construction materials and techniques

• Accessibility and maintenance requirements

The governing criteria for superstructure design include safety, durability, functionality, and aesthetics.

• Safety considerations include load capacity, wind resistance, and earthquake resistance.

• Durability considerations include corrosion resistance and maintenance requirements.

• Functionality considerations include the intended use of the structure and the needs of its occupants.

• Aesthetics considerations include the visual impact of the structure on its surroundings.

• Other fact...read more

SQL query format includes SELECT, FROM, WHERE clauses and can include JOIN, GROUP BY, ORDER BY clauses.

• Start with SELECT clause to specify columns to retrieve

• Followed by FROM clause to specify table(s) to retrieve data from

• WHERE clause is used to filter data based on specified conditions

• JOIN clause can be used to combine data from multiple tables

• GROUP BY clause is used to group data based on specified columns

• ORDER BY clause is used to sort data based on specified columns

Sharding and partitioning are both techniques used in database management to improve performance and scalability by dividing data into smaller chunks.

• Sharding involves splitting a database into smaller, independent databases called shards, each responsible for a subset of the data.

• Partitioning involves dividing a database into smaller segments called partitions, each containing a subset of the data based on a defined criteria such as range or hash value.

• Sharding is typically ...read more

Design schema for a movie booking system.

• Create tables for movies, theaters, users, bookings, and payments.

• Use foreign keys to establish relationships between tables.

• Include attributes like movie title, showtime, seat number, user details, booking status, payment details, etc.

• Consider implementing a booking algorithm to handle seat selection and availability.

• Ensure data integrity and normalization for efficient data retrieval and storage.

Superstructure design methodology involves analyzing loads, selecting materials, and determining structural systems.

• Analyze loads and determine design criteria

• Select appropriate materials based on strength, durability, and cost

• Determine structural systems such as beams, columns, and trusses

• Consider factors such as seismic activity, wind loads, and temperature changes

• Use computer-aided design software to model and test designs

• Ensure compliance with building codes and regulatio...read more

Calculation of weight for a tapered column involves determining the volume of each section and multiplying by the density of the material.

• Calculate the volume of each section of the tapered column using appropriate geometric formulas.

• Determine the weight of each section by multiplying the volume by the density of the material.

• Sum up the weights of all sections to get the total weight of the tapered column.

The OSI model is a conceptual framework that standardizes the functions of a communication system into seven layers.

• The seven layers of the OSI model are: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

• Each layer has a specific function and interacts with the layers above and below it.

• The Physical layer deals with the physical transmission of data.

• The Data Link layer provides error-free transmission over a physical link.

• The Network layer handl...read more

The missing dimensions in a cutting diagram can be calculated using basic geometry principles.

• Identify the known dimensions in the cutting diagram

• Use geometric formulas to calculate the missing dimensions

• Consider angles and proportions in the diagram

• Double check calculations to ensure accuracy

Indexing strategy is a method of organizing and optimizing data retrieval from a database.

• Choose appropriate data structures for indexing

• Consider the size and complexity of the database

• Regularly analyze and optimize the indexing strategy

• Examples: B-tree, hash index, bitmap index