Supply Chain Associate Interview Questions and Answers

To disable automatic sorting in a Pivot table, go to the Pivot table options and uncheck the 'Sort automatically' option.

• Open the Pivot table in Excel.

• Go to the 'PivotTable Analyze' or 'Options' tab.

• Click on the 'Options' button in the 'PivotTable' group.

• In the 'PivotTable Options' dialog box, go to the 'Data' tab.

• Uncheck the 'Sort automatically' option.

• Click 'OK' to apply the changes.

Truncate is a DDL command that removes all rows from a table, while delete is a DML command that selectively removes rows.

• Truncate is faster than delete as it doesn't generate any log entries.

• Truncate cannot be rolled back, while delete can be.

• Truncate resets the identity of the table, delete does not.

• Truncate does not fire triggers, delete does.

• Truncate releases the storage space, delete does not.

To remove duplicates in Excel, use the Remove Duplicates feature under the Data tab.

• Select the range of cells or columns that contain the data.

• Go to the Data tab and click on the Remove Duplicates button.

• Choose the columns to check for duplicates and click OK.

• Excel will remove the duplicate values and keep only the unique values.

• You can also choose to highlight the duplicate values instead of removing them.

Mean, median, and mode are statistical measures used to describe the central tendency of a dataset.

• Mean is the average of a set of numbers, calculated by summing all the values and dividing by the total count.

• Median is the middle value in a dataset when arranged in ascending or descending order.

• Mode is the value that appears most frequently in a dataset.

• Mean is sensitive to outliers, while median is not.

• Mode can be used to identify the most common value or category in a datas...read more

Stored procedures are precompiled SQL statements that are stored in a database and can be executed multiple times.

• Stored procedures are used to encapsulate a set of SQL statements into a single unit.

• They can be used to improve performance by reducing network traffic.

• Stored procedures can be parameterized, allowing for dynamic execution.

• They provide a level of security by controlling access to the underlying database objects.

• Stored procedures can be called from other SQL state...read more

RLS in Power BI stands for Row-Level Security.

• RLS is a feature in Power BI that allows you to restrict data access at the row level based on user roles.

• It helps in ensuring that users only see the data that is relevant to them.

• RLS can be implemented by defining roles and rules in Power BI Desktop or Power BI service.

• For example, you can create a role that only allows access to sales data for a specific region.

• RLS is useful in maintaining data privacy and security in organizat...read more

A warranty is a guarantee provided by a manufacturer or seller regarding the condition of a product and its repair or replacement.

• Warranties can be either express (written) or implied (understood).

• For example, a one-year warranty on electronics covers defects in materials or workmanship.

• Extended warranties offer additional coverage beyond the standard period, often for a fee.

• Warranties typically do not cover damage from misuse or normal wear and tear.

• In the automotive industr...read more