Question 96

Which SQL keyword can be used to reduce the number of columns processed by BigQuery?
  • Question 97

    Your company is loading comma-separated values (CSV) files into Google BigQuery. The data is fully imported successfully; however, the imported data is not matching byte-to-byte to the source file.
    What is the most likely cause of this problem?
  • Question 98

    You are choosing a NoSQL database to handle telemetry data submitted from millions of Internet-of- 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, high availability and low latency are required.
    You need to analyze the data by querying against individual fields. Which three databases meet your requirements? (Choose three.)
  • Question 99

    Your team is working on a binary classification problem. You have trained a support vector machine (SVM) classifier with default parameters, and received an area under the Curve (AUC) of 0.87 on the validation set.
    You want to increase the AUC of the model. What should you do?
  • Question 100

    Which of these statements about BigQuery caching is true?