This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the following questions.
You want to assign a coadministrator for your Azure Database for PostgreSQL flexible server, so that someone else has access if you aren't available. You would like them to be able to do anything and everything on the server. What role should be assigned to the user account?
azuresu
pg_read_all_settings
azure_pg_admin
Your company is required to encrypt sensitive data stored on disk. As the result of an internal audit, you realize that sensitive data is being held on your Azure for PostgreSQL flexible server. What should you do?
Nothing - your data is already encrypted.
Migrate your data to Azure Cosmos DB for PostgreSQL so that data can be encrypted with your own keys.
Set two server parameters and restart the server.
What does the following query do? CREATE ROLE "[email protected]" WITH LOGIN SUPERUSER;
Creates a new user with sign in and superuser permissions.
Creates a new user with sign in and admin permissions.
Returns an error message.
You must answer all questions before checking your work.
Was this page helpful?