10+ Concorde Group Interview Questions and Answers

Export services refer to the sale of services to customers located outside the country of the service provider.

• Export services involve providing services to customers in foreign countries

• Taxation on export services may vary based on the country's tax laws

• Export services can include consulting, IT services, marketing, etc.

• Export services are often subject to VAT or GST exemptions

Possible reasons for dropping Whatsapp engagement

• Changes in user behavior or preferences

• Technical issues or bugs affecting user experience

• Competition from other messaging apps

• Lack of new features or updates

• Privacy concerns or data breaches

• Decrease in active user base

• Shift towards alternative communication methods

Networking protocols and their respective port numbers are essential for communication between devices.

• HTTP - Port 80

• HTTPS - Port 443

• FTP - Port 21

• SMTP - Port 25

• SSH - Port 22

• DNS - Port 53

KYC Associate is responsible for verifying the identity of customers and ensuring compliance with anti-money laundering (AML) regulations.

• KYC Associate verifies customer identities and ensures compliance with AML regulations.

• AML stands for Anti-Money Laundering, which refers to the laws and regulations designed to prevent money laundering and terrorist financing.

• KYC and AML are closely related processes in the financial industry.

• KYC involves collecting and verifying customer ...read more

GSTR-1 and GSTR-3B are two types of GST returns filed by businesses in India.

• GSTR-1 is a monthly or quarterly return that contains details of outward supplies of goods or services.

• GSTR-3B is a monthly summary return that provides details of outward and inward supplies along with the payment of taxes.

• Both GSTR-1 and GSTR-3B are important for businesses to comply with GST regulations and ensure accurate tax reporting.

• Filing GSTR-1 helps in reporting sales and filing GSTR-3B hel...read more

Design a parking lot system at a low level

• Divide system into components like parking spots, ticketing system, payment system

• Implement data structures like queues for managing parking spots

• Use algorithms like least recently used for spot allocation

• Consider scalability and performance in design

Different forms of TDS include salary, interest, rent, commission, and professional fees.

• TDS on Salary

• TDS on Interest

• TDS on Rent

• TDS on Commission

• TDS on Professional Fees

System design of large scale system involves designing the architecture, components, and interactions of a complex software system.

• Identify the requirements and constraints of the system

• Break down the system into smaller components/modules

• Design the interactions between components using APIs and protocols

• Consider scalability, reliability, and performance

• Use distributed systems principles for fault tolerance and load balancing

Network Load Balancer is ideal for TCP traffic, while Application Load Balancer is best for HTTP/HTTPS traffic.

• Network Load Balancer operates at the connection level (Layer 4), distributing traffic based on IP protocol data.

• Application Load Balancer operates at the application level (Layer 7), distributing traffic based on content of the request.

• Network Load Balancer is better suited for applications that require static IP addresses, while Application Load Balancer is more fl...read more

DHCP assigns IP addresses to devices on a network, while DNS resolves domain names to IP addresses.

• DHCP dynamically assigns IP addresses to devices on a network

• DNS resolves domain names to IP addresses

• DHCP is used for automatic IP address configuration

• DNS is used for translating domain names to IP addresses

• DHCP operates at the network layer (Layer 3)

• DNS operates at the application layer (Layer 7)

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN returns rows when there is a match in one of the t...read more

Window functions are used to perform calculations across a set of table rows related to the current row.

• Window functions are used in SQL to perform calculations on a set of rows related to the current row.

• They allow you to perform calculations like ranking, moving averages, and cumulative sums.

• Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().