Now
I'm confused!
Vented attic w/floor insulation:

Vented cathedral ceiling insulation:

A cathedral ceiling is a finished sloped ceiling above conditioned space. Being condtioned space, you wouldn't be insulating the floor. If it's not conditioned space, but unvented, the "safest" approach is to use spray foam on the underside of the roof deck, or rigid foam & nailer layer above the roof deck.
Depending on your actual climate, you may/may-not be able to get away with insulating the attic floor. Another climate-dependent alternative would be to dense-pack cellulose against the roof deck, but you may need some amount of exterior side rigid insulation in colder climates:

....or....

Where are you?
In general, blown insulation will outperform fiber batts due to minimal voids. At high-R cellulose can be pretty hefty. At 12" settled depth you're talking 1.6-1.8lbs/ft, which can represent a significant dead-load for long spans & trusses. Be sure it's rated for it.
In the unvented attic, insulate the roof deck, but be sure it's done appropriately for your climate.