Motorica Interview Questions and Answers

Convert small letters to capital and caps to small in a string

• Iterate through each character in the string

• Check if the character is a small letter or a capital letter

• Convert small letters to capital and caps to small using ASCII values

Dashboard is a visual display of key metrics and trends, while a report is a detailed collection of data and analysis.

• Dashboard provides a high-level overview, while a report dives deeper into specific data points

• Dashboards are interactive and allow for drill-down capabilities, reports are static

• Dashboards are typically used for monitoring and decision-making, reports are used for in-depth analysis

• Example: A dashboard may show sales performance by region with interactive filt...read more

I have 2 years of experience in data analytics, including working with large datasets and using tools like Python and SQL.

• 2 years of experience in data analytics

• Proficient in working with large datasets

• Skilled in using Python and SQL for data analysis

Joins are SQL operations that combine rows from two or more tables based on related columns.

• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the left table. Example: SELECT * FROM A RIGHT ...read more

Lead and lag are SQL functions used to access data from a previous or subsequent row in a result set.

• Lead function is used to access data from a subsequent row in the result set.

• Lag function is used to access data from a previous row in the result set.

• Both functions can be used to compare values between rows or calculate differences.

• Example: SELECT lead(column_name) OVER (ORDER BY column_name) FROM table_name;

The WHERE clause in SQL filters records based on specified conditions.

• Used to specify conditions for filtering records in a query.

• Example: SELECT * FROM Employees WHERE Age > 30;

• Can combine multiple conditions using AND/OR.

• Example: SELECT * FROM Products WHERE Price < 100 AND Stock > 0;

• Supports various operators like =, <>, >, <, LIKE, IN, etc.

ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.

• ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

• It supports a wide range of data sources, including Azure Blob Storage, Azure SQL Database, and on-premises data sources.

• You can use ADF to ingest data from various sources, transform the data using compute services such as A...read more