Assistant Consulting Manager Interview Questions and Answers

Append adds new data to the end of a dataset, while merge combines two datasets based on a common key.

• Append adds rows to the end of a dataset, while merge combines rows from two datasets based on a common key column.

• Append is useful for adding new observations to an existing dataset, while merge is used to combine datasets with related information.

• Append does not require a common key, while merge requires a common key to match rows from both datasets.

• Example: Appending a new...read more

Joins 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 tables

All returns all values in a table, while Allexcept returns all values except those specified in the argument.

• All returns all values in a column or table.

• Allexcept returns all values in a column or table except those specified in the argument.

• Example: All(Table[Column]) returns all values in the specified column.

• Example: Allexcept(Table, Table[Column]) returns all values in the table except those in the specified column.

Data Gateways are software or hardware solutions that enable secure and efficient transfer of data between different systems or networks.

• Data Gateways act as intermediaries between data sources and data destinations

• They help in translating data formats, protocols, and security measures to ensure smooth data transfer

• Examples include Amazon API Gateway, Microsoft Azure Data Gateway, and IBM DataPower Gateway