Landmark Group Interview Questions and Answers

Q1. Tell me About yourself
Add your answer
Q2. Explain your current role
Add your answer
Q3. A few scenarios were given and question were asked around that . (RCA, Prioritization, Metrics)
Add your answer

Product Case study . Question was there has been significant increase in the returns at your ecommerce platform . Find out Why and then solve this problem

Q1. Explain Order Return Flow
Ans. 
Order Return Flow is the process of handling returns of products by customers.
• Customer initiates return request

• Return request is reviewed and approved

• Customer ships the product back

• Product is inspected upon return

• Refund or replacement is processed
Answered by AI
Add your answer
Q2. Explain Item inventory system
Ans. 
An item inventory system is a database or software used to track and manage the stock of items in a business.
• Tracks quantity of each item in stock

• Records item details such as name, description, price, and supplier

• Allows for easy search and retrieval of items

• Updates inventory levels in real-time

• Generates reports on inventory levels and sales
Answered by AI
Add your answer

Q1. Wxaplinnyour project
Add your answer
Q2. How would you build a pipeline to connect http source and bring data in adls
Ans. 
Build a pipeline to connect http source and bring data in adls
• Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source

• Transform the data as needed using tools like Apache Spark or Azure Databricks

• Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis
Answered by AI
Add your answer
Q3. Dimension and fact tabel difference
Ans. 
Dimension tables store descriptive attributes while fact tables store quantitative data.
• Dimension tables contain attributes that describe the business entities, such as customer, product, or time.

• Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.

• Dimension tables are denormalized and have a one-to-many relationship with fact tables.

• Fact table...read more
Answered by AI
Add your answer
Q4. Write slq query to get employee having 2manager
Ans. 
Use a self join to find employees with 2 managers in SQL query.
• Use a self join on the employee table to join the table with itself.

• Count the number of distinct managers for each employee.

• Filter the results to only include employees with 2 managers.
Answered by AI
Add your answer
Q5. Get second highest salary usingSQL
Ans. 
Retrieve the second highest salary from a salary table using SQL queries.
• Use the DISTINCT keyword to eliminate duplicate salaries.

• Order the salaries in descending order and limit the results.

• Example SQL query: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

• Alternatively, use a subquery: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
Answered by AI
Add your answer

Q1. What are bad debts, and how do they impact financial statements?
Ans. 
Bad debts are uncollectible accounts receivable that negatively affect financial statements.
• Bad debts arise when customers fail to pay their outstanding invoices.

• They are recorded as an expense on the income statement, reducing net income.

• On the balance sheet, bad debts decrease accounts receivable, impacting total assets.

• For example, if a company has $10,000 in receivables and estimates $1,000 as bad debt, it will rep...read more
Answered by AI
Add your answer
Q2. What is the concept of absorption?
Ans. 
Absorption refers to the process of incorporating fixed and variable costs into product pricing.
• Absorption costing includes all manufacturing costs in product costs.

• Example: If a company produces a gadget, both direct materials and overhead costs are included in the price.

• It contrasts with variable costing, which only includes variable costs.

• Absorption costing is required by GAAP for external financial reporting.
Answered by AI
Add your answer

Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
Add your answer
Q2. Difference between Vlookup and Xlookup ?
Ans. 
Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.
• Vlookup searches vertically in a table and returns a value from a specified column.

• Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

• Vlookup requ...read more
Answered by AI
Add your answer
Q3. Difference between Subquery and CTE. Which is better?
Ans. 
Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.
• Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

• CTE is defined using the WITH keyword and can be referenced multiple times in a query.

• CTEs are more readable and easier to maintain compared to subqueries.

• Subqueries are useful when t...read more
Answered by AI
Add your answer
Q4. No of records returned after applying left and inner join on 2 tables.
Ans. 
Understanding record counts from left and inner joins helps in data analysis and decision-making.
• A left join returns all records from the left table and matched records from the right table.

• An inner join returns only the records that have matching values in both tables.

• Example: If Table A has 5 records and Table B has 3 matching records, a left join will return 5 records, while an inner join will return 3.

• If there are ...read more
Answered by AI
Add your answer
Q5. Pivot the table in SQL using case when statements.
Ans. 
Pivoting a table in SQL using case when statements
• Use the CASE WHEN statement to create new columns based on specific conditions

• Use the SUM or COUNT function to aggregate data in the pivoted table

• Group by the remaining columns to ensure correct aggregation

• Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;
Answered by AI
Add your answer

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Online java assessment test - java, java 8, spring boot, microservices