- All Exams Instant Download
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...
Which three databases meet your requirements?
You are choosing a NoSQL database to handle telemetry data submitted from millions of Internetof-Things (IoT) devices. The volume of data is growing at 100 TB per year, and each data entry has about 100 attributes. The data processing pipeline does not require atomicity, consistency, isolation, and durability (ACID). However,...
What should you recommend they do?
Topic 4, Main Questions Set B Your company has recently grown rapidly and now ingesting data at a significantly higher rate than it was previously. You manage the daily batch MapReduce analytics jobs in Apache Hadoop. However, the recent increase in data has meant the batch jobs are falling behind....
Which methods can be used to reduce the number of rows processed by BigQuery?
Which methods can be used to reduce the number of rows processed by BigQuery?A . Splitting tables into multiple tables; putting data in partitionsB . Splitting tables into multiple tables; putting data in partitions; using the LIMIT clauseC . Putting data in partitions; using the LIMIT clauseD . Splitting tables...
