Walmart Infrastructure Engineer Interview Questions and Answers

Cost optimization in Big Query involves optimizing query performance, storage usage, and data transfer costs.

• Utilize partitioned tables to reduce query costs by scanning only relevant partitions

• Use clustering to organize data within partitions and improve query performance

• Optimize queries by using efficient SQL syntax and avoiding unnecessary operations

• Leverage caching to reduce repeated query costs

• Monitor and analyze ...read more

Various ways to ingest data in BigQuery include batch loading, streaming, and using third-party tools.

• Batch loading: Uploading data in bulk using tools like Cloud Storage or Data Transfer Service.

• Streaming: Sending data in real-time using APIs like Dataflow or Pub/Sub.

• Third-party tools: Using tools like Talend or Informatica for data ingestion.