Meta Solutions Architect interview questions

SQL Coding (45 minutes): The goal of this interview is to determine whether you can build, manipulate, and perform efficient data retrieval of databases using SQL. Please be prepared to solve questions involving SQL constructs, Data Transformation and Optimization Concepts. LANGUAGES When using SQL, you can expect to be assessed on some subset of the following: Ability to complete data processing, manipulation, and analysis tasks using SQL Ability to use joins, subqueries; knowledge of aggregate and analytical functions Working knowledge of the differences between joins (left, inner, outer, etc.) Ability to work with case statements, union and union all Work with concepts including Distinct, Random Sampling, De-Duplication, Optimization Apply the results of your analysis to make product decisions or suggestions Basic data visualization commands