Welcome to your Data/Engineering Name Phone Email What is data engineering? Analyzing data patterns Designing data visualizations Managing and processing data pipelines Predicting future trends based on data All of the above Which of the following tasks is NOT a part of data engineering? Data collection Data visualization Data transformation Data storage All of the above What is the process of cleaning, normalizing, and transforming raw data to make it suitable for analysis? Data integration Data warehousing Data preparation Data visualization All of the above What is the purpose of a data warehouse in data engineering? Real-time data processing Data storage for business analytics Data transformation for machine learning Data visualization for stakeholders All of the above Which of the following joins can be used to perform the cartesian product of two tables Cross Join Full outer join Left join Inner join None of the above As the analytics manager of a 50-person e-commerce company selling mobile phones, you received a product file from a manufacturer to ensure all their products are listed on your site. However, a query on your Phone table shows no matches. What steps do you take to resolve this? Go back to the manufacturer and ask them to send a correct list with codes in your format. Conclude none of their inventory is currently available on your site. Ask one of your analysts if there is a table which maps your codes to your manufacturer codes. Go back to the manufacturer and get them to send a list with the product name instead of the product code, and use this to match against your products names. All of these would be good decisions. Which of the following regarding APIs is not true? APIs are often accompanied by documentation which explains how to use the API. Good APIs provide a clear and easy way for someone to obtain data from another system. Most APIs require some kind of authentication to be able to actually obtain real data. The data format returned by APIs is normally tabular, such as csv or tsv. If you were calling an API to update some data, you would use the PUT method. None of the above Generally speaking, in a standard relational database, which is true? A primary key in one table cannot be a foreign key in another table. Most data is stored as a string (varchar) which maximises flexibility. Data is stored in tables, with columns or fields representing features of the data. Data is stored in tables, with each column including a JSON object representing a feature of the data. Connecting to databases is always done via a GUI such as MySQL Workbench, or pgAdmin. Which of the following is NOT an aggregate function in SQL? AVG COUNT ORDER BY SUM MIN You are given a table named "Countries", how can you return all the records from this table sorted descending by "Name"? SELECT * FROM Countries SORT Name DESC SELECT * FROM Countries ORDER Name DESC SELECT * FROM Countries SORT BY Name SELECT * FROM Countries ORDER BY Name DESC SELECT * FROM Countries SORT BY Name DESC None of the above how do you select all the records from a table named "Apollo" where the "Name" is alphabetically between (and including) "Ali" and "Mohamed"? SELECT * FROM Apollo WHERE Name>'Ali' AND Name<'Mohamed' SELECT * FROM Apollo WHERE Name BETWEEN 'Ali' AND 'Mohamed' SELECT Name>'Ali' AND Name<'Mohamed' FROM Apollo The following SQL is which type of join? Equi-join Natural join Outer join Cartesian join Which of the following statements is true concerning subqueries? Involves the use of an inner and outer query. Cannot return the same result as a query that is not a subquery. Does not start with the word SELECT. All of the above. What type of join is needed when you wish to include rows that do not have matching values? Equi-join Natural join Outer join All of the above. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible. True False In Python, you have defined a tuple as: tup = (1, 2, 3, 4, 5). Now, you want to update the value of the third item, 3, to 10. Which of the following options will you choose? tup(3) = 10 tup[2] = 10 tup[3] = 10 tup(2) = 10 All of the above None of the above What will the following code output? [1, 4, 9, 16, 25] [1, 4, 9, 16, 25, 36] [2, 4, 6, 8, 10] What does the zip() function in Python do? Combines two lists into a dictionary. Combines two lists into a list of tuples. Concatenates two lists into a single list. Reverses the order of elements in a list. What will be the output of the following code? [1, 2, 3, 4] [1, 2, 3] [1, 2, 3, 4, 4] [1, 2, 3, 4, 4, 4] Time's up