bcm

For this exercise you will create a web page that embeds a photo carousel based on a Flickr gallery (Flickr API details here: https://www.flickr.com/services/api/flickr.galleries.getPhotos.html).

1. Create a web page (the embedding page) that embeds the content of a second web page (the embedded page) in an iframe. The embedded page should allow the user to submit the ID of a Flickr gallery.
2. When the user submits a gallery ID, the embedded page should fetch photos from the identified Flickr gallery and display them in thumbnail form in a photo carousel.
3. When the user clicks on a thumbnail in the carousel to select it, the embedding page should be updated to display metadata about that photo, including the owner's name, the date it was taken, and the number of times the photo has been viewed.
4. When the user clicks on a selected thumbnail to deselect it, the corresponding photo metadata should be cleared from the embedding page.

Hint: If you find yourself making more than one request to the

bcm

For this exercise you will create a simple application to insert a record into a relational database through a short stateful web flow.

First, create a database table that holds records representing people.

• A person record has a unique identifier and the following additional attributes:
  • name (string)
  • age (integer)
  • date of birth (date)
  • email address (string)
• Email address has a unique constraint (case-insensitive).

bcm

This exercise consists of developing a distributed Extract-Transform-Load (ETL) application.

Your application should ingest the data from a source relational database system and use a distributed data processing tool such as Apache Hadoop or Apache Spark to compute some statistics and output them in a form that can be loaded into some destination storage system for consumption.

Please write your application in Python, Java, Scala or Kotlin. The application must be buildable from the command line; it should not require an IDE to build or run.

The exercise should generally not take more than 3 or 4 hours, although you're free to take as much time as you'd like to work on it. If you don't finish within a few hours, that's okay; submit what you've got anyway.

Source database