Ivy Atlas Copco Quiz

Which of the following is true about a foreign key?

• • It must be unique within its table.

• It is a Primary key of another table.

• • It is always a composite key.

• • It cannot contain NULL values.

If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?

• Append

• Combine Column

• Merge

• Lookups

Horizontal combining of queries in Power Query is known as___

• Appending

• Combining

• Merging

• Union

What is the difference between a "Power" Pivot Table and a regular Pivot Table?

• "Power" PivotTables allow you to analyze data across multiple tables and sources

• "Power" Pivots can analyze much larger data sets

• "Power" PivotTables allow you to create Data modelling

• All of the above

Given the following tables, identify which one is the Data table and which are the lookup tables.

• Orders is the Data table; Customers and Products are lookup tables.

• Orders is the lookup table; Customers and Products are Data tables.

• Products is the Data table; Orders and Customers are lookup tables.

• Customers is the Data table; Orders and Products are lookup tables.

Using Production Dataset, which of the following tables should be appended to combine their data

• Customer Details and Product Price

• Product Price and Orders

• Product Quality and Product

• Order Archive and Orders

Using the production dataset to create a relationship between orders and customers, which column should be used as a key?

• Order_ID

• Customer_ID

• Product_ID

• Customer_key

Using the production dataset, if you want to link product details to order details, which columns would you use to create the relationship?

• Order_ID in order table and Customer_ID in Production table

• Product_ID in production Quantity and Order_ID in order table

• Product_ID in Product table and Product_ID in Orders table

• None of these

In the Production Dataset, how many one-to-one relationships are typically present?

• 1

• 0

• 2

• 3

Using Production table , can you fetch the customer's name from the Order Details table if you connect it to the Customer_info table?

• Yes, directly from the Order Details table

• No, you need to join it with the Customers table

• Yes, by joining with the customer_info table

• No, the Order Details table doesn't have customer names