QTM 250

True or False. Admin is an example of a primitive role?

False

For classification problems in ML, you want to maximize the False Positive Rate (predict that the user will return and purchase and they don't) and minimize the True Positive Rate (predict that the user will return and purchase and they do).

False (vice versa)

In the podcast they mention " commercial APIs" for gender classification using computer vision. What is an example of a company offering such a service? (You will have to google to find it)

An example of a company using commercial APIs for gender classification using computer vision is Microsoft.

True or False. Compute Engine pricing is based on a daily rate for the instance.

False

True or False. Facial detection and facial recognition are the key capabilities of the Cloud Vision API used to detect what an image is and classify it.

False

True or False. Managing GCP users through Google Groups allows an administrator to manage team identities centrally.

False

True or False. The Cloud Video Intelligence API only supports the annotation of MPEG4, MP4, and AVI video formats.

False

True or False. When using Cloud Shell you must also install the Cloud SDK locally to manage your projects and resources.

False

True or False. s3config is a command-line option for the Cloud SDK?

False

Use FROM to specify what fields (columns) you want to pull from your dataset.

False

What does the following query return? SELECT pluralityFROM 'publicdata.samples.natality'WHERE year > 2000 LIMIT 10

First ten entries from the "plurality" column where the year of birth is greater than 2000

Which of the following best describes a major advantages GCP has over other cloud providers?

Google owns one of the largest networks in the world. All regions and zones are connected on the same network

What does it mean for a system to be elastic?

The system can add and remove resources based on need

When comparing on-premises, IaaS, PaaS, and managed services, which option requires the least amount of work for the user in terms of security?

Managed service

GCP has many storage options. Which would be the best option for unstructured storage?

Cloud Storage

What is the `numericCode` for the country of Algeria?

012

Copy and paste the list of the three letter country codes of the countries that border Algeria. Do not include the square brackets.

'TUN', 'LBY', 'NER', 'ESH', 'MRT', 'MLI', 'MAR'

Convert 112 from decimal to binary

1110000

Convert F2 from hexadecimal to binary.

11110010

How many keys are in the dictionary returned for the country of Algeria?

24

What is the largest object that you can store in Cloud Storage?

5 TB

Cloud Bigtable provides a NoSQL based managed service option. Which one of the following is a valid use case for this service?

A backend for an Internet of Things (IoT) system.

Cloud Datastore is a NoSQL based managed service. Which statement best describes Cloud Datastore?

A document store

Which option would you select if you want to write your own model leveraging Tensorflow in a managed environment?

AI Platform

What is the purpose of an API?

APIs simplify the way disparate software resources communicate

ASCII is an acronym for what?

American Standard Code for Information Interchange

Projects form part of the Google Cloud Platform (GCP) resources hierarchy. Which of the following is true concerning projects?

All resources must be associated with a project

What is the main purpose of a service account?

Allow for service-to-service interaction with GCP.

Which statement best describes TensorFlow?

An open source language to build machine learning models.

Google Kubernetes Engine is built on the open-source Kubernetes system. Which of the following statements best describes what Kubernetes is?

An orchestration engine to manage containers.

The internet is the standard communication channel that APIs use to transmit requests and responses between programs. The client-server model is the underlying architecture that web-based APIs use for exchanging information. The ________ is a computing device (e.g. a smartphone, laptop, etc.) that makes a request for some computing resource or data. The request needs to be formatted in the agreed upon protocol. The __________ has data and/or computing resources stored on it. Its job is to interpret and fulfill requests.

Answer 1: client Answer 2: server

You are looking for a managed API service to provide an API frontend to your legacy systems? Which of these services would meet your needs?

Apigee Edge

Time-to-market is highly valuable to you and you want to be able to focus on writing code without ever having to touch a server, cluster, or infrastructure. Which service suits your needs?

App Engine

You want to use App Engine, but you will need to use a custom runtime. Which of the following is the best option?

App Engine Flexible

What does API stand for?

Application Programming Interface

Select the service that is a managed data warehouse in GCP.

BigQuery

Which of the following storage options is not a database?

BigQuery

Which of the following statements regarding BigQuery is accurate?

BigQuery is a NoOps managed service.

I am thinking of a country. Its name starts with the letter B. Among all such countries, it has the greatest number of borders. Which country am I thinking of?

Brazil

What service leverages the Apache Beam SDK to perform ETL operations?

Cloud Dataflow

You are in need of a service that can process both streaming and batch data, but you don't want to manage the infrastructure. Which of the following is the best solution?

Cloud Dataflow

Which of the following is a managed solution to run Spark, Pig, Hive, and MapReduce in a batch environment with a managed cluster?

Cloud Dataproc

Regions are independent geographic areas on the same continent. Which of the following is a regional service?

Cloud Datastore

You have non-relational data and want a serverless database without having to worry about nodes or cluster management. Which service would best suit your needs?

Cloud Datastore

You are looking for a managed API service for your cloud-based services? Which of these services would meet your needs?

Cloud Endpoints

What service is used to supply encryption keys when users want to manage their own keys?

Cloud Key Management System

You have a requirement to identify parts of speech from unstructured text. Which of the following machine learning APIs should you use for this purpose?

Cloud Natural Language API

GCP has different options for SQL-based managed services. Which of these options is horizontally scalable and globally available?

Cloud Spanner

There are two APIs that apply to speech. If you need to create a lifelike interaction with users to support a customer service application, which of the two Speech APIs would you use?

Cloud Text-to-Speech

What Is cloud computing? From the statements below, choose the one that best summarizes all aspects of cloud.

Cloud computing is the on-demand delivery of compute power, database storage, applications, and other IT resources through a cloud services platform via the Internet with pay-as-you-go pricing.

Google Cloud Platform (GCP) provides a variety of service choices. Which of the following services is infrastructure as a service (IaaS)?

Compute Engine

What best describes the purpose of quotas? (Choose 2)

Configuration used to prevent billing surprises. Configuration used to prevent over consumption due to malicious attacks.

How would you configure billing notifications in GCP?

Configure budgets and alerts.

None of the pre-defined instance types fit your application. What do you do?

Create a custom virtual machine that fits your needs

Which statement regarding GCP and data encryption is accurate?

Data is encrypted at rest and in transit.

Which of the following is the container format used with Google Kubernetes Engine?

Docker

Which of the following statements best describes Cloud AutoML?

Enables users with limited ML expertise to train models specific to their business needs.

Which are access points to data or computing resources hosted on a server and they take the form of an HTTP URI?

Endpoint

Cloud Identity and Access Management (Cloud IAM) allows you to manage privileges. What do these privileges apply to?

Google Cloud Platform (GCP) resources

BiqQuery charges $5 per GB scanned.

False

Consider the query below: #standardSQL SELECT (v2ProductName) AS ProductName FROM `data-to-insights.ecommerce.all_sessions` GROUP BY ProductName ORDER BY ProductName Which part of the previous query deduplicates the records?

GROUP BY

What is the difference between repository and project in GitHub?

GitHub is a Git repository hosting service, but it adds many of its own features. While Git is a command line tool, GitHub provides a Web-based graphical interface. It also provides access control and several collaboration features, such as a wikis and basic task management tools for every project.

Which of the following is the protocol used by REST APIs?

HTTPS

What type of service best describes Google Kubernetes Engine?

Hybrid

Explain the importance of cloud computing to a friend or relative.

I talked to my dad about the importance of cloud computing on the phone over the weekend to try and explain why I chose to take this class. Since my dad is on the older side and tries to avoid using technology he doesn't understand, I tried to explain the power of the cloud in simple terms, and in a way he could relate to. I explained that the cloud offers many benefits such as increased collaboration, pay-as-you-go features (clients are getting exactly what they pay for), resource pooling (multiple people can share the same resources/space and distribute resources as needed) and complete control over your documents, to name a few. The cloud is able to blend hardware and software over a network to deliver a service, such as Gmail.com, which is used by millions, and Google Docs, which has become an increasingly popular document service for students and businesses alike.

A file format that is lightweight, easy to read, and fast to parse.

JSON

In what format will a majority of the APIs return data in?

JSON

What code can Cloud Dataflow be written in?

Java, Python (and Go)

Which of the following virtual disk types is ephemeral?

Local SSD

Recall, in the Qwiklab on BQML there were two types of models to choose from. Suppose that you will create a Machine Learning model in BigQuery to predict whether or not a new user is likely to purchase in the future. If you are bucketing visitors into "will buy in future" or "won't buy in future", which model should you use?

Logistic regression

Which of the following statements most accurately describes machine learning?

Machine learning is a way to derive predictive insights from data.

Which of the following database engines does Cloud SQL support? (Choose 2)

MySQL PostgreSQL

What Cloud Storage storage class would be an inexpensive option for backups that you test once a month?

Nearline

Google Cloud provides resources in multi-regions, regions, and zones. What best describes a zone?

One or more data centers

The Google Cloud Platform (GCP) hierarchy helps you manage resources across multiple departments and multiple teams within an organization. Which of the following is at the top level of this hierarchy?

Organization

When setting up user/role pairings in GCP, which of the following is true?

Permissions are inherited and the least restrictive permission will be inherited.

What do primitive roles grant permissions to?

Projects

Every GCP service you use is associated with a project. Which of the following statements regarding projects are correct? (Choose 2)

Projects are the basis for enabling and using GCP services. Each project is a separate account, and each resource belongs to exactly one.

Which of the following is the most common API format in GCP?

REST

How would you configure the Cloud SDK to work on your laptop?

Run the gcloud init command

What does SQL stand for?

Structured Query Language

Here is a quote from the podcast "in both, MLP and computer vision, there tends to be a focus on precision, recall" Why could a machine learning model have high precision and accuracy overall, yet still be biased? Explain in your own words.

There might still be bias in machine learning models because we may unintentionally expose our models to bias. It is near impossible to separate ourselves from our biases, which may eventually become part of the technology we are creating. Machine learning bias can come about in various forms from mathematical, technical, and social inputs/algorithms that are unable to capture certain aspects of data. These might include latent, selection and interaction biases. A solution to these biases may be more inclusive data sets that incorporate different world views and intersections of data such as age, gender, race, etc.

Google provides quick start templates for Cloud Dataflow. Why would you use them?

To rapidly deploy data pipelines without programming expertise.

Adding LIMIT 10 to your query won't reduce the cost of the query.

True

Consider the following query. SELECT start_station_name FROM `bigquery-public-data.london_bicycles.cycle_hire` GROUP BY start_station_name Answer True or False: Without the GROUP BY, the query would have returned the full 24,369,201 rows. GROUP BY will output the unique (non-duplicate) column values found in the table.

True

In Bigquery, projects contain datasets, and datasets contain tables

True

True or False. Cloud Shell code editor is one of the developer tools built into the GCP console.

True

True or False. Data can be loaded into BigQuery using the BigQuery Web UI, the BigQuery API, or the BQ command line.

True

True or False. Machine learning uses standard algorithms because it allows you to use the same code on different datasets to generate different models.

True

True or False. Python is a runtime option for Cloud Functions.

True

True or False. Stackdriver metrics can be used to trigger an autoscaling event.

True

True or False. The Cloud Translation API supports language detection in cases where the source language is unknown.

True

True or False. You can use existing SQL skills to query data in Cloud Spanner.

True

There are a number of best practices that should be applied to identity and access management. Which of the following does Google recommend?

Use the "principle of least privilege" when distributing permissions.

How would you test a Google API and learn how it works?

Use the APIs Explorer that is part of the GCP console.

What is the purpose of a folder?

Used to organize projects

SELECT FROM `data-to-inghts.ecommerce.rev_transactions` LIMIT 1000

We have not specified any columns in the SELECT

Which of the following can trigger Cloud Functions?

Webhook

EXAMPLE: A sentiment-analysis model is trained to predict whether book reviews are positive or negative based on a corpus of user submissions to a popular website. The majority of reviews in the training data set reflect extreme opinions (reviewers who either loved or hated a book), because people were less likely to submit a review of a book if they did not respond to it strongly. As a result, the model is less able to correctly predict sentiment of reviews that use more subtle language to describe a book. Is this an example of bias in ML? If yes, what kind? If no, why not?

Yes. Reporting Bias.

What is wrong with the query below (Select all that are true): #standardSQL SELECT geoNetwork_city, SUM(totals_transactions) AS total_products_ordered, COUNT( DISTINCT fullVisitorId) AS distinct_visitors, SUM(totals_transactions) / COUNT( DISTINCT fullVisitorId) AS avg_products_ordered FROM `data-to-insights.ecommerce.rev_transactions` WHERE avg_products_ordered > 20 GROUP BY geoNetwork_city ORDER BY avg_products_ordered DESC

You cannot filter on aliased fields within the `WHERE` clause You cannot filter aggregated fields in the `WHERE` clause (use `HAVING` instead)

In the query that you ran to train your model, a WHERE clause condition is being used to filter and train on only the first 9 months of session data in your 12 month dataset. Why?

You need to save some unseen data points for model evaluation and testing.

Suppose that you create a new GCP bucket and upload a picture, sheep.jpg, to the bucket. If you want a link to the picture so that you may, for instance, share the picture with a friend, you must:

configure permissions on your object so that it is publicly accessible

In one of the Qwiklabs you use the Natural Language API text classification method to classify news articles by creating a Natural Language API classifyText request and calling the API with __________

curl

Which command line tool can be used to manage Cloud Storage?

gsutil