LDAP - database access

When we enable LDAP authentication users will actually access the underlying database as the LDAP user or still (as with Google) all users would access the database using some one "service account" account that is used for metabase?

Depends, if your database is postgres or snowflake you can use the new impersonation feature, which sets a role for each query Advanced permissions impersonation