The correct answer is To hold temporary tables table variables and intermediate result sets used while queries run.

In an Azure SQL Managed Instance tempdb is the workspace for transient objects and intermediate results that queries produce during execution. It stores temporary tables table variables and worktables that support operations such as sorting hashing and spooling. Because tempdb is recreated on service restart it is intended for short lived query processing state rather than for durable user data.

To record transactional history and durable log records is incorrect because transactional history and durable log records are written to a database's transaction log for recovery and durability. Tempdb is not used for persistent logging and it is not part of a database recovery chain.

To maintain user account credentials and access control is incorrect because login information and security metadata are kept in the master database or managed through Azure AD and server level settings. Tempdb does not hold persistent security or account configuration.

To persist user created tables and stored procedures is incorrect because user objects that must persist are created in user databases. Tempdb can host temporary objects for a session but those objects are transient and are removed at session end or when the instance restarts.

Full AWS Practitioner Certification Question