You need to provide a FullName (FirstName + ' ' + LastName) for every employee in BigQuery while minimizing cost. How do you make that data available?

Creating a view in BigQuery is the most cost-effective and efficient solution. Views are logical tables defined by a SQL query; they don't store data themselves, so there are no storage costs for the FullName column. BigQuery only processes the view's query when it's accessed, minimizing compute costs by avoiding unnecessary data duplication and updates. Adding a new column and running an UPDATE would incur storage costs for the new column and compute costs for the update operation. A Cloud Dataflow job or exporting to CSV and processing with Dataproc are significantly more complex and expensive, involving data movement, external processing, and re-ingestion, which are overkill for a simple string concatenation.