KPMG India Interview Questions and Answers

Selling ice cream to an Eskimo and shampoo to a bald guy requires creativity and understanding of customer needs.

• For selling ice cream to an Eskimo, focus on the experience and the joy of eating ice cream rather than the temperature.

• Offer unique flavors that the Eskimo may not have tried before.

• For selling shampoo to a bald guy, highlight the benefits of using shampoo for scalp health and cleanliness.

• Suggest using the shampoo as a body wash or for cleaning other items like br...read more

The question covers topics related to SQL server, networking, and server OS installation.

• To create a table in SQL Server, use the CREATE TABLE statement.

• To take a backup in SQL Server, use the BACKUP DATABASE statement.

• To restore a backup in SQL Server, use the RESTORE DATABASE statement.

• BGP stands for Border Gateway Protocol, which is a routing protocol used in the Internet.

• To install a server OS step by step, follow the installation guide provided by the OS vendor.

• An outer ...read more

Active Directory is a directory service that stores information about objects on a network.

• It is used to manage users, computers, and other resources on a network.

• It provides a centralized authentication and authorization mechanism.

• It allows administrators to assign policies, deploy software, and apply updates to network resources.

• It uses a hierarchical structure of domains, trees, and forests to organize network resources.

• It is a key component of Microsoft's Windows Server o...read more

Use the 'kill' command followed by the process ID to terminate a process in Linux.

• Use 'ps' command to find the process ID of the process you want to kill

• Use 'kill' command followed by the process ID to terminate the process

• You can also use 'kill -9' followed by the process ID for a forceful termination

PATCH method in HTTP is used to partially update a resource on the server.

• PATCH requests are used to make partial updates to a resource

• It is typically used when you want to update only a few fields of an existing resource

• The PATCH request body contains the changes to be applied to the resource

JWT (JSON Web Token) is a compact, URL-safe means of representing claims to be transferred between two parties.

• JWT consists of three parts: header, payload, and signature.

• Header typically consists of the type of token and the signing algorithm being used.

• Payload contains the claims. Claims are statements about an entity (typically the user) and additional data.

• Signature is created by encoding the header, payload, a secret, and the algorithm specified in the header.

• JWTs are ty...read more

CORS is used to allow or restrict cross-origin requests in web applications.

• CORS is used to prevent malicious websites from making unauthorized requests to a different origin.

• It allows servers to specify who can access their resources by setting appropriate headers.

• CORS is important for security and privacy reasons in web development.

• Example: If a frontend application on domain A wants to make a request to a backend API on domain B, CORS must be implemented to allow this comm...read more

Building ETL pipelines using Airflow for data engineering projects.

• Define data sources and destinations

• Design data transformation processes

• Implement ETL workflows in Airflow

• Schedule and monitor pipeline executions

• Handle error handling and data quality checks