Physical Address

304 North Cardinal St.
Dorchester Center, MA 02124

Explore SQL Server 2022 capabilities Microsoft Quiz Answers

Get Explore SQL Server 2022 capabilities Microsoft Quiz Answers

Learn about SQL Server 2022 enhancements, including:

  • Hybrid capabilities with the cloud and on-premises
  • Performance and data virtualization improvements
  • Improved security and availability
  • Enhanced analytics capabilities

Prerequisites:

  • Basic working knowledge of SQL Server, including deployment, security, query processing, and high availability
  • Fundamental knowledge of the T-SQL language
  • Basic knowledge of Azure concepts, including subscriptions, resource groups, Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS)

Enroll On Microsoft

Module 1: Introduction to SQL Server 2022

Learn about new major capabilities of SQL Server 2022 from cloud connected features to core engine capabilities.

Learning objectives:

In this module, you’ll be able to:

  • Describe the innovations introduced in SQL Server 2022
  • Determine if SQL Server 2022 can help modernize your data estate, while reducing the cost of ownership, and accelerate the performance of your applications
  • Leverage new security capabilities in SQL Server 2022 to protect your data and use cryptographic attestations that your data hasn’t been tampered with
  • Connect your data to Azure and data lakes

Prerequisites:

  • Basic working knowledge of SQL Server, including deployment, security, query processing, and high availability
  • Fundamental knowledge of the T-SQL language
  • Basic knowledge of Azure concepts, including subscriptions, resource groups, Infrastructure-as-a-Service and Platform-as-a-Service

This module is part of these learning paths:

Quiz 1: Build a hybrid data platform with SQL Server 2022

Q1. Which Azure service is used to provide managed disaster recovery with SQL Server 2022?

  • Azure Synapse Analytics
  • Azure SQL Managed Instance
  • Azure Blob Storage

Q2. What is the software installed with SQL Server 2022 that provides connectivity from on-premises to Azure?

  • The SQL Server IaaS Agent extension
  • Self-hosted integrated runtime
  • Azure extension for SQL Server

Quiz 2: Gain performance insights when you need it and accelerate performance with no code changes

Q1. What capability do query store hints provide?

  • An easy-to-use method for shaping query plans without changing application code
  • Change query plans by reverting back to a previous plan found in the Query Store.
  • Change query text when persisting a query in the Query Store

Q2. Parameter Sensitive Plan optimization can help which scenario?

  • Data is skewed and you use ad-hoc queries with your application.
  • Scenarios where more than one plan in cache would help with stored procedure performance.
  • Scenarios for queries that use parallelism

Quiz 3: Power your application with an industry proven database engine with security, scalability, and availability

Q1. Ledger for SQL Server provides tamper evident proof for data integrity using what capability?

  • Auditing of any T-SQL statement executed against SQL Server
  • End-to-end encryption of data associated with a database set with the LEDGER option
  • Built-in auditing and cryptographic hashes of transactions against a ledger table

Q2. Contained availability groups replicate what new types of data in SQL Server 2022 for a normal availability group?

  • SQL Server Agent Jobs
  • Windows registry keys for SQL Server
  • Changes to rows in user tables

Quiz 4: Use SQL Server 2022 as a data hub querying files and backup/restore to object storage providers

Q1. SQL Server 2022 uses REST API to provide data virtualization to which type of data sources?

  • S3 compatible object storage providers
  • Oracle data sources using ODBC
  • Hadoop data sources using Java

Q2. SQL Server 2022 data virtualization now supports which file format popular for data lakes?

  • JSON
  • Parquet
  • HDFS

Module 2: Understand hybrid data platform on SQL Server 2022

Learn about new major cloud connected capabilities of SQL Server 2022.

Learning objectives:

In this module, you’ll be able to:

  • Discover best practices for disaster recovery using Azure SQL Managed Instance
  • Describe how Azure Arc-enabled SQL Server works
  • Understand how to implement near real time analytics with Azure Synapse Link for SQL Server
  • Explain cloud connected technologies that support security with Azure Active Directory authentication
  • Explore Microsoft Purview access policies for SQL Server
  • Describe the services that support SQL Server data files in a hybrid platform

Prerequisites:

  • Basic working knowledge of SQL Server, including deployment, security, query processing, and high availability
  • Fundamental knowledge of the T-SQL language
  • Basic knowledge of Azure concepts, including subscriptions, resource groups, Infrastructure-as-a-Service and Platform-as-a-Service

This module is part of these learning paths:

Quiz 1: Knowledge check

Q1. Which of the following is a limitation of the Azure SQL Managed Instance link feature?

  • The link feature can only replicate databases of a certain size.
  • The link feature cannot replicate databases that use In-Memory OLTP objects on the General Purpose service tier.
  • The link feature cannot replicate databases that use columnstore indexes.

Q2. How many databases can be placed into a single availability group for one Azure SQL Managed Instance link?

  • Only one database
  • Multiple databases
  • Multiple databases, as long as the database size is less than a certain limit

Q3. What is one way in which Microsoft Purview policies can provide access to SQL Server?

  • Creating a login and mapping it to a Purview policy
  • Creating a policy in Purview based on an Azure Active Directory (Azure AD) account
  • Creating a role in SQL Server that maps to a Purview policy

Module 3: Understand the built-in query intelligence enhancements of SQL Server 2022

Learn about and use the Intelligent Query Processing feature enhancements in SQL Server 2022.

Learning objectives:

At the end of this module, you’ll be able to:

  • Understand the key functionality behind Intelligent Query Processing and when to implement the feature
  • Understand Automatic performance healing with memory grant feedback persistence
  • Know how to get consistent performance with Parameter Sensitive Plan optimization
  • Gain parallel efficiency with DOP Feedback

Prerequisites:

  • Basic working knowledge of SQL Server and query processing
  • Fundamental knowledge of the T-SQL language
  • Installed SQL Server 2022

This module is part of these learning paths:

Quiz 1: Exercise – Parameter Sensitive Plan

Q1. Parameter Sensitive Plan (PSP) optimization can help which scenario:

  • A. Data is skewed and you use ad-hoc queries with your application.
  • B. Scenarios where more than one plan in cache would help with stored procedure performance.
  • C. Stored procedure performance using parameters in filters with the >= operators.
  • D. All of the above.

Quiz 2: Exercise – Degree of Parallelism feedback

Q1. Parallel efficiency is defined as:

  • A. Dynamically calculating the best setting for sp_configure.
  • B. The lowest DOP setting for a query to achieve similar duration across executions while lowering CPU.
  • C. A MAXDOP setting for the database that lowers the overall CPU for the system.
  • D. B and C.

Module 4: Explore new capabilities in security, scalability, and availability in SQL Server 2022

Learn about the new capabilities in security, scalability, and availability in SQL Server 2022.

Learning objectives:

By the end of this module, you’ll be able to:

  • Describe what ledger for SQL Server is, and use ledger tables to enhance your auditing capabilities.
  • Be familiar with the security feature enhancements, like the added granular fixed server roles, Always Encrypted enhancements, strict connection encryption, and granular UNMASK permissions for dynamic data masking.
  • Understand the enhancements to memory management, tempdb, and how SQL Server 2022 can help you scale large-memory environments with no code or application changes.
  • Describe the new capabilities around SQL Server 2022 availability, including contained availability groups, cross-platform snapshot backups, and Intel® QuickAssist Technology backup compression.

Prerequisites:

  • SQL Server 2022 installed.
  • Basic working knowledge of SQL Server security, performance, and availability features.
  • Fundamental knowledge of the Transact-SQL (T-SQL) language.

This module is part of these learning paths:

Quiz 1: Exercise – Ledger

Q1. Ledger tables are introduced in two forms in SQL Server 2022. What are they?

  • A. Updatable ledger tables and read-only ledger tables.
  • B. Blockchain ledger tables and updatable ledger tables.
  • C. Append-only ledger tables and audit ledger tables.
  • D. Updatable ledger tables and append-only ledger tables.

Q2. Independent verification for ledger in SQL Server 2022 is done by:

  • A. The database ledger through system tables.
  • B. The ledger history view.
  • C. Database digest.
  • D. Blockchain data in SQL Server tables.

Quiz 2: Enhancements in SQL Server 2022 to help scalability

Q1. SQL Server 2022 eliminates what type of bottleneck for tempdb?

  • A. PAGEIOLATCH.
  • B. PAGELATCH.
  • C. Spinlocks.
  • D. A and B.
  • E. Row locks on system pages.

Quiz 3: Availability enhancements in SQL Server 2022

Q1. A contained availability group replicates which objects?

  • A. Linked Servers.
  • B. SQL Agent Jobs.
  • C. Logins.
  • D. A, B, and C.
  • E. B and C.

Module 5: Introduction to SQL Server 2022 data virtualization

Data virtualization and enhanced PolyBase features introduced in SQL Server 2022.

Learning objectives:

By the end of this module, you’ll be able to:

  • Understand the benefits and principles of data virtualization
  • Know what PolyBase is, and how you can leverage its capabilities
  • Be familiar with object storage solutions
  • Install and configure PolyBase on SQL Server 2022
  • Access external data on SQL Server 2022 using PolyBase

Prerequisites:

  • Basic working knowledge of SQL Server
  • Fundamental knowledge of the T-SQL language and be able to execute queries in SQL Server Management Studio on a SQL Server 2022 instance

This module is part of these learning paths:

Quiz 1: Introduction to PolyBase

Q1. Object storage is the recommended solution for a high-transactional workload

  • True
  • False

Q2. To run the PolyBase feature, you need to install the PolyBase Query Service for External Data option.

  • True
  • False

Q3. SQL Server 2022 supports any type of object storage.

  • True
  • False

Quiz 2: Understand credentials and data sources with PolyBase

Q1. SQL Server 2022 can now access external data sources through:

  • A. Using REST API to S3 compatible object storage providers.
  • B. Query delta table files on REST API data sources from a SELECT.
  • C. Access Parquet files on ODBC data sources.
  • D. A and B.

Q2. PolyBase allows SQL Server to connect to:

  • A. SQL Server.
  • B. Oracle.
  • C. Azure Blob Storage.
  • D. Azure Data Lake Storage Gen2.
  • E. Teradata.
  • F. All of the above.

Module 6: Introduction to SQL Server 2022 T-SQL enhancements

Learn the new and improved SQL Server 2022 functions that will enhance the querying and creation of T-SQL objects.

Learning objectives:

In this module, you’ll be able to:

  • Understand the new and enhanced T-SQL features in SQL Server 2022.
  • Utilize new functions and capabilities to optimize database performance and maintainability.
  • Adapt to the evolving needs of modern database administrators and developers.

Prerequisites:

  • SQL Server 2022.
  • Basic working knowledge of SQL Server and query processing.
  • Fundamental knowledge of the Transact-SQL (T-SQL) language.
  • Familiarity with SQL Server functions and operators.

This module is part of these learning paths:

Quiz 1: Create index and resumable constraint enhancements

Q1. Which of the following SQL Server 2022 commands allows you to pause and resume an ALTER TABLE ADD CONSTRAINT operation?

  • ALTER INDEX
  • ALTER TABLE
  • ALTER CONSTRAINT

Q2. In SQL Server 2022, to which command was the WAIT_AT_LOW_PRIORITY clause extended?

  • ALTER TABLE ADD CONSTRAINT
  • CREATE INDEX
  • ALTER INDEX

Quiz 2: Named window definition with the SELECT WINDOW clause

Q1. In the context of the WINDOW clause, what does a named window specification refer to?

  • A specific table in the database
  • A definition that can be used across multiple data calculations
  • A predefined set of SQL functions

Q2. What is the one advantage of using named window specifications in a WINDOW clause?

  • Reducing code duplication
  • Automatically optimizing query performance
  • Enforcing data consistency

Quiz 3: Enhance expression comparisons with IS [NOT] DISTINCT FROM

Q1. What is the primary difference between the ‘=’ operator and the ‘IS NOT DISTINCT FROM’ operator?

  • There’s no difference; they both compare values for equality in the same exact way.
  • IS NOT DISTINCT FROM handles NULL values in comparisons, while the = operator doesn’t.
  • The = operator can compare any data type, while IS NOT DISTINCT FROM can only compare string values.

Q2. How does the IS NOT DISTINCT FROM predicate treat NULL values in comparisons?

  • As unknown values
  • As known values
  • As zero values

Quiz 4: Time and series functions enhancements

Q1. In SQL Server 2022, which function is used to obtain a given date rounded down to a specified level of granularity, such as year, month, or day, without needing to specify the width of the datepart intervals from the origin time?

  • DATETRUNC
  • DATE_BUCKET
  • DATEPART

Q2. What enhancement was added to the FIRST_VALUE and LAST_VALUE functions in SQL Server 2022?

  • The ability to filter rows based on a condition before selecting the first or last value.
  • The ability to IGNORE NULLS or RESPECT NULLS.
  • The ability to compute the first and last value based on a sliding window of rows.

Quiz 5: String and other functions enhancements

Q1. In SQL Server 2022, which function is used to select the smallest value among multiple expressions?

  • MIN_VALUE
  • LEAST
  • FIRST_VALUE

Q2. What is the purpose of the optional ordinal parameter in the STRING_SPLIT function in SQL Server 2022?

  • It specifies the delimiter to use when splitting the string.
  • It enables the creation of a 1-based index value of each substring’s position in the input string.
  • It controls the maximum number of substrings to return.

Quiz 6: New and improved JSON functions

Q1. What is the purpose of the JSON_OBJECT function in SQL Server 2022?

  • To check if a JSON string is valid
  • To construct a JSON object using key-value pairs
  • To construct a JSON array using elements

Q2. What enhancement was made to the ISJSON function in SQL Server 2022?

  • Support for JSON type constraint
  • Support for JSON path expressions
  • Ability to create JSON arrays

Quiz 7: New aggregation functions

Q1. Which SQL Server function should be used to compute the approximate value at a specified percentile without interpolating between data points?

  • APPROX_PERCENTILE_CONT
  • PERCENTILE_DISC
  • APPROX_PERCENTILE_DISC

Q2. What is the primary difference between APPROX_PERCENTILE_DISC and APPROX_PERCENTILE_CONT functions?

  • APPROX_PERCENTILE_DISC returns the nearest existing data point, while APPROX_PERCENTILE_CONT interpolates between data points.
  • APPROX_PERCENTILE_DISC interpolates between data points, while APPROX_PERCENTILE_CONT returns the nearest existing data point.
  • APPROX_PERCENTILE_DISC calculates exact percentiles, while APPROX_PERCENTILE_CONT provides approximate percentiles.

Quiz 8: New bit manipulation functions

Q1. In SQL Server 2022, which function can be used to determine how many bits are turned on (set to 1) in a binary value?

  • GET_BIT
  • BIT_COUNT
  • SET_BIT

Q2. Which function in SQL Server 2022 can be used to modify the value of a specific bit within a binary value?

  • GET_BIT
  • BIT_COUNT
  • SET_BIT
Conclusion:

I hope this Explore SQL Server 2022 capabilities Microsoft Quiz Answers would be useful for you to learn something new from this problem. If it helped you then don’t forget to bookmark our site for more Coding Solutions.

This Problem is intended for audiences of all experiences who are interested in learning about Data Science in a business context; there are no prerequisites.

Keep Learning!

More Coding Solutions >>
Cognitive Class Answer

CodeChef Solution

Microsoft Learn

Leave a Reply

Your email address will not be published. Required fields are marked *