PROFESSIONAL-CLOUD-DEVELOPER · Question #75
PROFESSIONAL-CLOUD-DEVELOPER Question #75: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DEVELOPER to reveal the answer and full explanation for question #75. The question stem and answer options stay visible for context.
Question
You have a data warehouse built on BigQuery that contains a table with array fields. To analyze the data for a specific use case using Standard SQL, you need to read all elements from the array and write them with all other non-array fields in a table. You don't want to lose any records if they don't match records in the array fields. What should you do?
Options
- APerform SELECT * FROM tablename.
- BPerform UNNEST and JOIN with the table to get these results.
- CPerform UNNEST and INNER JOIN with the table to get these results.
- DPerform UNNEST and CROSS JOIN with the table to get these results.
Unlock PROFESSIONAL-CLOUD-DEVELOPER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DEVELOPER questions. Unlock PROFESSIONAL-CLOUD-DEVELOPER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.