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

Authored by lusukama selemani

Other

Professional Development

Used 13+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

45 questions

Show all answers

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

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

A. Premium SSD

Standard SSD

Ultra disks

Blob

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

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

Ensure that there are no active transactions in the database, as the auto-pause change will result in a disconnection

The Azure portal allows you to change the auto-pause setting at any time

The auto-pause setting can't be changed, and it's fixed at one hour

None

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

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

Azure SQL Managed Instance

Azure SQL Database

Azure SQL VM

You can use both Azure SQL Database and Azure SQL Managed Instance.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

What type of storage offers the lowest latency in Azure?

Standard SSD

Ultra SSD

Premium SSD

HHD

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

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

Pay as You Go Licensing

Availability set

Azure Reserved VM Instances

None

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

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

Availability units

Availability sets

Availability zones

None

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

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

Availability Set

Azure Site Recovery

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

46 questions

May 4, 2023 SE Trivia

Quiz

•

Professional Development

50 questions

LIB Test G

Quiz

•

Professional Development

40 questions

YNOV - CI/CD - QCM 1

Quiz

•

Professional Development

40 questions

T 4 (TEAM MURSAL)

Quiz

•

Professional Development

41 questions

Тест

Quiz

•

Professional Development

42 questions

Terik's Practice Test1

Quiz

•

Professional Development

50 questions

soal pedagogik 3

Quiz

•

Professional Development

40 questions

Week 4 - test

Quiz

•

Professional Development

Popular Resources on Wayground

10 questions

5.P.1.3 Distance/Time Graphs

Quiz

•

5th Grade

10 questions

Fire Drill

Quiz

•

2nd - 5th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

15 questions

Hargrett House Quiz: Community & Service

Quiz

•

5th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Other

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

35 questions

World War Two 8th G

Quiz

•

6th Grade - Professio...

7 questions

DOL REC: Solutions & Solubility Curves

Quiz

•

Professional Development

20 questions

Block Buster Movies

Quiz

•

10th Grade - Professi...

20 questions

NCAA Logo Quiz

Quiz

•

Professional Development

Boot Camp DSD

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