Test failures are not included on your public transcript, nor is the score on tests you passed.

After you've reviewed the topics listed on the Microsoft page for the test, you...

Another key point is that you don't use SET inside a SELECT statement to assign a value to a variable, you just assign a value:

DECLARE @MyVal varchar(64);
SELECT...

You can't encrypt a read-only database. You can store a read-only database's files in an encrypted file system, though.

You have a few options:

• Use SQL Server TDE to encrypt the...

My question is, where did all memory go since buffer pool is size of 300+GB. Where should I be looking into?

At a basic level, SQL Server prefers to keep 75%...

Element names may not have spaces in them.

When the parser looks at <Shipper Reference> it sees an element named Shipper and an attribute named Reference, for which it is expecting...

Are you looking to transfer ownership (which does NOT change the schema), or to change the schema of the view from [viewschema] to [tableschema]?

If you wish to change [viewschema].[viewName] to...

What is the result of the query when run on Node B? Is the encryption showing progress in any of the AG replicas? The secondary replica will show 0% until...

Snapshots are not backups. They aren't even copies of the database. They don't become backups until they have been transferred off of the SAN in a format that can be...

Configure the client connection string to include MultiSubnetFailover=True so the client will try each of the addresses.

Under the 'Multi-Subnet Failovers' heading in the doc at https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-ver15 :

This is because the...

To show all employees:

1. Remove the filter on EmployeeID from the WHERE clause
2. Add EmployeeID to the grouping

Using Example 2:

-- Add Emp to groups so it can...

Have you taken a full backup of the database since it was placed in the Full Recovery Model? Until the first full backup completes, the transaction log acts as if...

The deadlock graph contains the SQL statements involved in the deadlock, which may include parameter values.

If your database contains PII or other data that must follow regulations (GDPR, HIPAA, etc.),...

First, you need to deal with the XML Namespaces xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" and xmlns="urn:partner.soap.sforce.com" :

WITH XMLNAMESPACES ('http://www.w3.org/2001/XMLSchema-instance' AS xsi, DEFAULT 'urn:partner.soap.sforce.com')

Then you can shred each row's address XML column...

I used Microsoft's Data Experimentation Assistant (DEA) on my last upgrade project. The databases upgraded included 100TB+ databases pushing billions of transactions per day: https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant-overview?view=sql-server-ver15

DEA is a system for...

Just run setup.exe from the install media, and specify everything as parameters of that. Here's the doc on those parameters:

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15