What is the name of this activity?
Not implemented as a UX library, yet.

3rd Party Solution: https://github.com/apl-devs/AppIntro

DIY: You can create your own UI and can leverage ViewPager for the effect.