You're designing a real-time data warehouse for InstaLogix Inc. , and you're using Google BigQuery streaming inserts to ingest data. Although each record contains a unique identifier and an event timestamp, there's no guarantee that duplicate records won’t arrive. To ensure accurate interactive query results, you want to exclude duplicate entries. Which type of query should you use to reliably deduplicate the data during querying?