Ultimate access to all questions.
As a Data Engineer at a multinational corporation, you are tasked with integrating and analyzing employee performance data to support HR decision-making. The data is stored in two distinct formats within your Databricks environment: a JSON string containing employee details ('id', 'name', 'department', 'salary') and a table named 'performance_reviews' with fields ('employee_id', 'review_date', 'performance_rating'). Your objective is to parse the JSON string into a structured table and join it with the 'performance_reviews' table for comprehensive analysis. Given the importance of accuracy and efficiency in your analysis, and considering the need to include all employees in the results, even those without performance reviews, which of the following Spark SQL queries would you use? Choose the two most correct options from the five provided.