Knowledge check

Completed

Choose the best response for each of the following questions.

Check your knowledge

1.

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

2.

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.

3.

What does the following query do? CREATE ROLE "kerry@allen.dev" 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.