Password policy sql authenticated SQL Server users

Hi,

When we create users in RDM we have RDM also create the users in the SQL Server database we use for RDM.
These users are created with the "enforce password policy" option enabled (as we want it).

For auditing reasons we have to supply evidence this option is always enable when creating

Does RDM create a sql authenticated SQL Server account by default with the "enforce password policy" on and if so is there an option to turn on or off (to have some evidence of this settings)?
Or is this something you let SQL Server handle (if I create a SQL Server account using Management Studio not only it the "onforce password policy" enabled but also the unwanted "Enforce password expiration" and "User must change password at next login")?

Regards,
Jan-Pieter