- All Exams Instant Download
What should you do?
You have spent a few days loading data from comma-separated values (CSV) files into the Google BigQuery table CLICK_STREAM. The column DT stores the epoch time of click events. For convenience, you chose a simple schema where every field is treated as the STRING type. Now, you want to compute...
How should you build this pipeline?
An external customer provides you with a daily dump of data from their database. The data flows into Google Cloud Storage GCS as comma-separated values (CSV) files. You want to analyze this data in Google BigQuery, but the data could have rows that are formatted incorrectly or corrupted. How should...
How can you adjust your application design?
You need to store and analyze social media postings in Google BigQuery at a rate of 10,000 messages per minute in near real-time. Initially, design the application to use streaming inserts for individual postings. Your application also performs data aggregations right after the streaming inserts. You discover that the queries...
How would you query specific partitions in a BigQuery table?
How would you query specific partitions in a BigQuery table?A . Use the DAY column in the WHERE clauseB . Use the EXTRACT(DAY) clauseC . Use the __PARTITIONTIME pseudo-column in the WHERE clauseD . Use DATE BETWEEN in the WHERE clauseView AnswerAnswer: C Explanation: Partitioned tables include a pseudo column...
How can you get a neural network to learn about relationships between categories in a categorical feature?
How can you get a neural network to learn about relationships between categories in a categorical feature?A . Create a multi-hot columnB . Create a one-hot columnC . Create a hash bucketD . Create an embedding columnView AnswerAnswer: D Explanation: There are two problems with one-hot encoding. First, it has...
Which SQL keyword can be used to reduce the number of columns processed by BigQuery?
Which SQL keyword can be used to reduce the number of columns processed by BigQuery?A . BETWEENB . WHEREC . SELECTD . LIMITView AnswerAnswer: C Explanation: SELECT allows you to query specific columns rather than the whole table. LIMIT, BETWEEN, and WHERE clauses will not reduce the number of columns...
Which table name will make the SQL statement work correctly?
Your company is using WHILECARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error: # Syntax error : Expected end of statement but got “-“ at [4:11] SELECT age FROM bigquery-public-data.noaa_gsod.gsod WHERE age != 99 AND_TABLE_SUFFIX = ‘1929’ ORDER...
What should you do?
You work for an economic consulting firm that helps companies identify economic trends as they happen. As part of your analysis, you use Google BigQuery to correlate customer data with the average prices of the 100 most common goods sold, including bread, gasoline, milk, and others. The average prices of...
Which two actions should you take?
Your company produces 20,000 files every hour. Each data file is formatted as a comma separated values (CSV) file that is less than 4 KB. All files must be ingested on Google Cloud Platform before they can be processed. Your company site has a 200 ms latency to Google Cloud,...
What should you do?
You need to compose visualization for operations teams with the following requirements: - Telemetry must include data from all 50,000 installations for the most recent 6 weeks (sampling once every minute) - The report must not be more than 3 hours delayed from live data. - The actionable report should...
