Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You are working as a Data Engineer and your company has asked you to use Big Query.
The requirement is to fetch the data from a table named “customer” having 1000 columns, and you can skip the following columns as those are not needed for the solution if needed –
A11, B11, B6, C7, D9, E1, P1, Q2, R2, Z5
You were asked to consider the solution to be cost-effective. (Single Option)
A. Use Select * FROM `customer`
B. Use Select * EXCLUDE (A11, B11, B6 , C7, D9, E1, P1,Q2, R2,Z5) FROM `customer`
C. Use Select * EXCEPT (A11, B11, B6 , C7, D9, E1, P1,Q2, R2,Z5) FROM `customer`
D. Use Select A11, B11, B6 , C7, D9, E1, P1,Q2, R2,Z5 FROM `customer`
Correct Answer: C
- Option C is CORRECT because we can use EXCEPT to skip or remove the unwanted columns, this is useful as well in terms of cost-saving.
Note: This will not delete your columns, this is only for the SELECT to view the table.
- Option A is incorrect because this query will fetch all the columns and this is not a cost-effective solution.
- Option B is incorrect because EXCLUDE is not a valid option.
- Option D is incorrect because this query will select only (A11, B11, B6, C7, D9, E1, P1, Q2, R2, Z5) and in the requirement, we need to skip these columns.
For more information on the Big Query- SQL EXCEPT, please visit the below URL:
Comments are closed, but trackbacks and pingbacks are open.