Question 11

When creating a new Cloud Dataproc cluster with the projects.regions.clusters.create operation, these four values are required: project, region, name, and ____.
  • Question 12

    You designed a database for patient records as a pilot project to cover a few hundred patients in three clinics.
    Your design used a single database table to represent all patients and their visits, and you used self-joins to generate reports. The server resource utilization was at 50%. Since then, the scope of the project has expanded. The database must now store 100 times more patient records. You can no longer run the reports, because they either take too long or they encounter errors with insufficient compute resources. How should you adjust the database design?
  • Question 13

    Your company uses a proprietary system to send inventory data every 6 hours to a data ingestion service
    in the cloud. Transmitted data includes a payload of several fields and the timestamp of the transmission. If
    there are any concerns about a transmission, the system re-transmits the data. How should you
    deduplicate the data most efficiency?
  • Question 14

    Your company's customer_order table in BigOuery stores the order history for 10 million customers, with a table size of 10 PB. You need to create a dashboard for the support team to view the order history. The dashboard has two filters, countryname and username. Both are string data types in the BigQuery table. When a filter is applied, the dashboard fetches the order history from the table and displays the query results. However, the dashboard is slow to show the results when applying the filters to the following query:

    How should you redesign the BigQuery table to support faster access?
  • Question 15

    You're training a model to predict housing prices based on an available dataset with real estate properties. Your plan is to train a fully connected neural net, and you've discovered that the dataset contains latitude and longtitude of the property. Real estate professionals have told you that the location of the property is highly influential on price, so you'd like to engineer a feature that incorporates this physical dependency.
    What should you do?