Google Flashcards

1
Q

How many Google searches a day?

A

4B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is google’s annual Revenue

A

250B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How many google pages indexed?

A

30 Trillion

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How much is a google avg. cost per click?

A

50 cents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How many monthly users on Facebook?

A

3B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What do AARRR metrics stand for?

A
Acquisition
Activation, 
Retention, 
Referral, 
Revenue.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the size of a photo?

A

2mb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How many internet users?

A

4.5B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the avg. size of an apt.?

A

1000 sq feet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the avg. size of a house ?

A

2000 square feet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How many Daily Youtube video views a day?

A

4B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

CIRCLE?

A
Comprehend (Who, Why, How, What?)
Identify Customer (Personas)
Report Needs (User Stories)
Cut through prioritization (ROI Est)
List Solutions
Evaluate Tradeoffs
Summarize Reccomendation
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Google Revenue from Ads?

A

200B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Youtube Monthly Users

A

2B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Gmail monthly users?

A

1.5B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Facebook Ad Revenue

A

55B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Whatsapp Monthly Users

A

1.5B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

CPM (Cost per 1,000 Impressions)

A

5-40 USD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Cost per Click

A

.5-3 USD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

CTR?

A

0.5-3%

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

API stands for?

A

Application programming interface

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is Recursion?

A

A method of solving a computational problem where the solution depends on solutions to smaller instances of the same problem

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is a Key Value Database?

A

A database like Firestore that does not use relationship based tables but rather keys and documents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What 3 Major factors can impact Latency and response time for a website?

A

Inadequate server resources
Page Weight
Distance from client to server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Crawl?

A

When search engines send bots to your website in order to gather intel on pages that exist and don’t exist in order to determine what content should be displayed or removed on search engines.

26
Q

FTP?

A

“File Transfer Protocol.” Method of exchanging files from one computer to another. This is also how websites are uploaded to the Internet.

27
Q

Redirects?

A

Automatic forwards from one URL to another — usually from an old website URL to the same page on a new website (these are called 301 Redirects). Other redirects may pivot between two domains (e.g., idealist.com redirects to idealist.org), a shortened URL to the full URL (e.g., bit.ly URLs), and geotargeted URLs.

28
Q

What are primary Keys?

A

is a column in the table is a unique entity (trees in SeeTree), best to pull data quickly

29
Q

What are Foreign Keys?

A

Foreign keys-Column the value in the column is a primary key of a different table. Grove ID in a Tree table is a foreign key.

30
Q
Give an example of each of these relationships:
One to many
Many to one
Many to many
One to one
A

One to many: People to Address
Many to One: Employees to an department
Many to Many: Students to Different Classes
One to One: Boss and his Office

31
Q

How does google search algorithm work?

A

Page Rank: Google checks how many links there are to a page and ranks its importance based on that. It’s like wisdom of the crowds.

32
Q

What is a DNS?

A

DNS(Domain Name System) is a database that maintains the name of the website (URL) and the particular IP address it links to.

33
Q

What is a TCP connection?

A

Transmission Control Protocol transfers data packets between two endpoints like your computer(client) and the server. It is a three step process

  1. Client sends request to Server if it is available
  2. If the server has open ports that can accept and initiate new connections, it’ll let the client know
  3. The client will get feedback, connection will be made and data can be transfered
34
Q

What is “Sharding”

A

Sharding is a method of splitting and storing a single logical dataset in multiple databases. By distributing the data among multiple machines, a cluster of database systems can store larger dataset and handle additional requests.

35
Q

What is a load balancer?

A

A load balancer is a device that acts as a reverse proxy and distributes network or application traffic across a number of servers. Load balancers are used to increase capacity (concurrent users) and reliability of applications.

36
Q

What is a Json

A

JavaScript Object Notation, is a lightweight format for storing and transporting data, is often used when data is sent from a server to a web page, is “self-describing” and easy to understand

37
Q

What is “Concurrent Programming”

A

concurrent programming is a technique in which two or more processes start, run in an interleaved fashion through context switching and complete in an overlapping time period by managing access to shared resources e.g. on a single core of CPU.

38
Q

What is Operational Transformation?

A

Operational Transformation (OT) is a technology to provide consistency maintenance and concurrency control in real-time collaborative editing systems. The correctness of OT is critical due to its foundation role in supporting a wide range of real world applications.

39
Q

What is the weakness of using Column data Bases like BQ for applications?

A

It is not good for updating data, meaning in bq you can’t go into a cell and write a different number. You can only delete a certain amount of rows per day in bq.

40
Q

Where is it best to keep business logic?

A

In cloud function

41
Q

What is a CDN?

A
content delivery network
A CDN (content delivery network), also called a content distribution network, is a group of geographically distributed and interconnected servers. They provide cached internet content from a network location closest to a user to speed up its delivery.
42
Q

What is Network Protocol?

A

A network protocol is a set of established rules that dictate how to format, transmit and receive data so that computer network devices – from servers and routers to endpoints – can communicate, regardless of the differences in their underlying infrastructures, designs or standards.

43
Q

List 7 common data types:

A
  1. Integer (int)
  2. Floating Point (float)
  3. Character (char)
  4. String (str or text)
  5. Boolean (bool)
  6. Array
  7. Date/time/timestamp
44
Q

What is an integer?

A

It is the most common numeric data type used to store numbers without a fractional component (-707, 0, 707).

45
Q

What is a Floating Point?

A

It is also a numeric data type used to store numbers that may have a fractional component like monetary values do (707.07, 0.7, 707.00).

46
Q

What is a Character?

A

It is used to store a single letter, digit, punctuation mark, symbol, or blank space.

47
Q

What is a string?

A

It is a sequence of characters and the most commonly used data type to store text. Additionally, a string can also include digits and symbols, however, it is always treated as text.

A phone number is usually stored as a string (+1-999-666-3333) but can also be stored as an integer (9996663333).

48
Q

What is boolean?

A

It represents the values true and false. When working with the boolean data type, it is helpful to keep in mind that sometimes a boolean value is also represented as 0 (for false) and 1 (for true).

49
Q

What is an Array?

A

Also known as a list, an array is a data type that stores a number of elements in a specific order, typically all of the same type.

Each element of an array can be retrieved using an integer index (0, 1, 2,…), and the total number of elements in an array represents the length of an array.

For example, an array variable genre can store one or more of the elements rock, jazz, and blues. The indices of the three values are 0 (rock), 1 (jazz), and 2 (blues), and the length of the array is 3 (since it contains three elements).

Continuing on the example of the music app, if you are asked to choose one or more of the three genres and you happen to like all three (cheers to that), the variable genre will store all three elements (rock, jazz, blues).

50
Q

What is Big O Notation?

A

Big O is a way to measure the speed and complexity of an algorythem to help you know how efficient it will be with transferring larger amounts of data. Compare a pidgeon carrying a USB 50 miles to an internet connection. For the pidgeon it doesn’t matter how much data is on the USB, but for the internet it does.

51
Q

What is SSO, and how does it work?

A

Single Sign On is a way to provide authentication of a user accorss domains. This is done by the SSO requests authentication from the service provider and receives a token of authentication.

52
Q

When are Bayesian methods more appropriate than “Artificial Intelligence” techniques for predictive analytics?

A

Bayesian methods require a priors that create very clear assumptions, where as AI learns and the priors are less clear. If there is a very clear prior that should be the basis of the prediction then it is a good option, but if the prior is not clearly defines AI can find it.

53
Q

What is the difference between C++ and Java?

A

C++ is platform dependent and Java in platform independent.

54
Q

What is encapsulation?

A

In object oriented programming, its the bundling of data, along with the methods that operate on that data, into a single unit. For example a property (car model) and a method (start, stop)

55
Q

What is abstraction?

A

In Object Oriented Programing this is hiding the complexity of the property and methods from the outside so it has a simpler interface. It alse makes it to you can make changes to the properties or methods and it will not impact the rest of the code.

56
Q

What is inheritance ?

A

In Object Oriented Programing it is a mechanism to remove redundant code, and allows the programmer to reuse the code in multiple places when it is needed

57
Q

What is Polymorphism?

A

In Object Oriented Programing, Polymorphism performs different things as per the object’s class, which calls it. With Polymorphism, a message is sent to multiple class objects, and every object responds appropriately according to the properties of the class.

58
Q

What is CAP Theorem?

A

Consistency. All reads receive the most recent write or an error.
Availability. All reads contain data, but it might not be the most recent.
Partition tolerance. The system continues to operate despite network failures (ie; dropped partitions, slow network connections, or unavailable network connections between nodes.)

If their is a partition problem and nodes cannot communicate it can either be consistent or available, it cant be both.

If the communication of 2 ATM machines breakdown, the ATM could either be consistent and say out of order because it will not know what the balance of the account it, or it can be available and work, but only update the balance of the account later with the other ATM that could cause a problem.

You can only have 2 of 3 at a given time

CA-Consistancy and Availability
CP-Consistancy and Partition
AP-Availability and Partition

59
Q

What are the advantages and disadvantages of CA databases, and what types are they?

A

CA databases enable consistency and availability across all nodes. Unfortunately, CA databases can’t deliver fault tolerance. In any distributed system, partitions are bound to happen, which means this type of database isn’t a very practical choice. That being said, you still can find a CA database if you need one. Some relational databases, such as PostgreSQL, allow for consistency and availability.

60
Q

What are the advantages and disadvantages of CP databases, and what types are they?

A

CP databases enable consistency and partition tolerance, but not availability. When a partition occurs, the system has to turn off inconsistent nodes until the partition can be fixed. MongoDB is an example of a CP database. I

61
Q

What are the advantages and disadvantages of CP databases, and what types are they?

A

AP databases enable availability and partition tolerance, but not consistency. In the event of a partition, all nodes are available, but they’re not all updated. For example, if a user tries to access data from a bad node, they won’t receive the most up-to-date version of the data. When the partition is eventually resolved, most AP databases will sync the nodes to ensure consistency across them. Apache Cassandra is an example of an AP database.