You're building a database for testing purposes that will be used less than 8 hours a day. It's expected to be 20 GB in size. What is your most cost-effective option?

Azure SQL Database Elastic Pools

You work for a small start-up company. The company is developing a system that it hopes will be used by many large corporations across the world. They have yet to win their first customer. Which Azure Database for PostgreSQL server should they select?

Azure Arc-enabled PostgreSQL Hyperscale.

What is the purpose of pgBouncer?

When pgBouncer is enabled, it ensures connections are reused.

When pgBouncer is enabled, it prevents more users connecting than the server can handle.

When pgBouncer is enabled, it stops connections from being reused.

For best performance on Azure Database for PostgreSQL, how should you manage connection handling?

Set max_connections to the minimum possible value.

Process-based connection handling.

What are the four main query processing components in PostgreSQL?

Parser, Planner, Executor, Rewriter.

Cost estimator, Parser, Executor, Rewriter.

What is the result of running the following statement? EXPLAIN ANALYZE INSERT INTO animal (ani_id, name, weight_kg, cat_id, enc_id) VALUES (28, 'Robin Robin', 0.5, 2, 4);

The query plan for the INSERT statement is displayed, and a new record is inserted into the animal table.

The query plan for the INSERT statement is displayed, but the new record statement will be rolled back and not inserted into the animal table.

The statement isn't syntactically correct and will throw an error.

You're working on a complex query. You would like to see the query optimizer's plan to help you understand why it's running slowly. What should you do?

Add the keyword EXPLAIN before the query statement.

Add the keywords EXPLAIN ANALYZE before the query statement.

Add the keyword ANALYZE before the query statement.

You've been asked to set up your company's Azure Database for PostgreSQL server. The database must be accessed from anywhere on the internet. Which setup option should you choose?

Flexible server with private networking access.

Flexible server with public networking access.

Hyperscale with private networking access.

SELIANORD GROUP required to encrypt sensitive data while it's 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 Database for PostgreSQL hyperscale 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 " kerry@allen.dev " WITH LOGIN SUPERUSER ;

Creates a new user with login and admin permissions.

Creates a new user with login and superuser permissions.

You want to make it easier for a colleague to insert data into a table. What should you do? .

Neither a stored procedure nor a function will address this requirement.

You've created a stored procedure that returns a country/region name. Which of the following options is the correct way to call the stored procedure?

Use the keyword CALL to call the stored procedure.

Use the keywords CALL PROCEDURE.

Write a SELECT query and include the stored procedure's return value with an alias.

SELIANORD GROUP uses Azure Database for PostgreSQL as the database for their expenses processing application. You need to write some code to calculate how much should be reimbursed to employees for mileage in their own car. The code will return a single decimal number. The result of the code will be used in SELECT statements. What should you do?

Neither a stored procedure nor a function will address this requirement.

SELIANORD GROUP maintains a busy shopping application. You want to provide near-time reporting, without affecting performance on the Azure Database for PostgreSQL server. Which option would best suit your needs?

Create a second Azure Database for PostgreSQL server and configure it as a subscriber. Configure your existing server as a publisher.

Configure High Availability on your Azure Database for PostgreSQL server and use the replicated copy for reporting.

Configure zone redundant High Availability on your Azure Database for PostgreSQL server and use the replicated copy for reporting.

CTU TRAINING SOLUTIONS uses Azure Database for PostgreSQL flexible server to maintain its stock system. You want to use the contents of the write-ahead log (WAL) for auditing purposes. What is the best way of doing this?

Install the pglogical extension and use logical streaming replication.

Configure zone redundant high availability.

Copy the log from pg_wal directory.

What is the purpose of Multi-Version Concurrency Control (MVCC)?

MVCC uses snapshots to prevent one transaction from blocking, or being blocked by, another transaction.

MVCC allows multiple versions of PostgreSQL Flexible Server to access the same underlying database.

MVCC blocks read access to a table if the table needs to be dropped or truncated.

Transactions with what lock type are blocked when you run a SELECT statement?

No other lock types are blocked by SELECT statements.

You've recently taken over support for an Azure Database for PostgreSQL database in your company. You've noticed that the amount of storage required for the database appears to be growing at a rate greater than you would expect. What should you do to investigate?

Run a SELECT query to find dead rows that are no longer needed in the database.

Prevent users from adding more data to the database until the problem has been solved.

Check the server parameters to ensure autovacuum is switched OFF.

You've tuned the server parameters to make autovacuum more efficient. However, users are complaining of slight delays when updating the single table in your database that has most updates. What could you do to resolve the problem?

Disable AUTOVACUUM and run VACUUM manually as required.

Increase the value for autovacuum_analyze_threshold.

As part of an annual routine, a large number of records have been updated. This has been done over a holiday when your Azure Database for PostgreSQL database isn't in use. Now that the updates are complete, what should you do to ensure lost disk space is reclaimed?

Disable AUTOVACUUM and manually run VACUUM.

Increase the autovacuum_work_mem.

What do you have to do to enable pg_stat_statements queries?

Nothing. Pg_stat_statements are already enabled.

In Server parameters , enable pg_qs.query_capture_mode .

Turn on the pg_stat_statements.track setting.

In the Query Store, how do you view the SQL syntax of queries?

Query the query_store.qs_view view.

Query the query_store.pgms_wait_sampling_view view.

Query the query_store.runtime_stats_view view.

Boot Camp DSD

Professional Development

•

45 Qs

Similar activities

Final Day Quiz for ICT Skill Share

4th Grade - Professional Development

•

41 Qs

QUIZ CARV INDONESIA JULY

Professional Development

•

40 Qs

Nilai Inti Challenge BAYA 2019

Professional Development

•

41 Qs

MC Aéro Module M13.17-22 - Entrainement

Professional Development

•

45 Qs

Rolling Sky Birthday Quiz

KG - Professional Development

•

50 Qs

Diklat Siswaskeudes

Professional Development

•

40 Qs

RIA Mock ver 3

University - Professional Development

•

40 Qs

Learning Premier League Sales July

Professional Development

•

40 Qs

Boot Camp DSD

Quiz

•

Other

•

Professional Development

•

Practice Problem

•

Medium

lusukama selemani

Used 13+ times

FREE Resource

Azure Backup for SQL Server

Availability Groups

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

$СУБД \\\ 2$

50 questions

СУБД \\\ 2

Quiz

•

Professional Development

50 questions

Seleksi LCT Guru

Quiz

•

Professional Development

49 questions

Worksheet BCA – Transaksi dan Produk Perbankan

Quiz

•

Professional Development

40 questions

800,000

Quiz

•

Professional Development

40 questions

AZ-900 Quiz

Quiz

•

Professional Development

50 questions

UJI PETIK SINTELIS

Quiz

•

Professional Development

50 questions

COMPUTER MOCK TEST - 2

Quiz

•

Professional Development

$СУБД \\\ 1$

50 questions

СУБД \\\ 1

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Other

10 questions

How to Email your Teacher

Quiz

•

Professional Development

6 questions

3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET

Quiz

•

Professional Development

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

22 questions

Multiplying Exponents with the Same Base

Quiz

•

9th Grade - Professio...

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

Boot Camp DSD

45 questions

What Azure storage is recommended for production data files that requires maximum throughput?

What option should you select to change the auto-pause setting of a serverless SQL Database?

Which SQL Server PaaS offering should you choose if you want to restore an on-premises database backup to Azure?

What type of storage offers the lowest latency in Azure?

To reduce the cost of an Azure SQL Server VM you intend to run full time for three years, which option should you choose?

Which option should you choose to spread workloads across data centers in a region?

Which service performs block level replication of your Azure virtual machine?

You need to migrate a set of databases that use distributed transactions from on-premises SQL Server. Which of the following options should you choose?

You're building a new cloud database that you expect to grow to 50 TB. Which is the best option for your database?

You're building a database for testing purposes that will be used less than 8 hours a day. It's expected to be 20 GB in size. What is your most cost-effective option?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other