April 2023 - Page 166 of 374

21AprApril 21, 2023

What should you do first?

You have an Azure SQL database named DB1. You need to display the estimated execution plan of a query by using the query editor in the Azure portal. What should you do first?A . Run the set showplan_all Transact-SQL statement. B. For DB1, set QUERY_CAPTURE_MODE of Query Store to All....

By examsDP-300 V2DP-300 exam0 Comments

21AprApril 21, 2023

CORRECT TEXT

CORRECT TEXT Please wait while the virtual machine loads. Once loaded, you may proceed to the lab section. This may take a few minutes, and the wait time will not be deducted from your overall test time. When the Next button is available, click it to access the lab section....

By examsMD-100 V2MD-100 exam0 Comments

21AprApril 21, 2023

What should you include in the solution?

You have an Azure Synapse Analystics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone. You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column. What should you include...

By examsDP-203 V4DP-203 exam0 Comments

21AprApril 21, 2023

Which Azure Cognitive Services service should you use?

You need to measure the public perception of your brand on social media messages. Which Azure Cognitive Services service should you use?A . Text Analytics B. Content Moderator C. Computer Vision D. Form RecognizerView AnswerAnswer: A Explanation: Text Analytics Cognitive Service could be used to quickly determine the public perception...

By examsAI-102 V3AI-102 exam0 Comments

21AprApril 21, 2023

Based on the above output from the new node, what is most likely the cause of this issue?

Refer to the exhibit. An administrator is adding a new node to a cluster. The node has been imaged to the same versions of AHV and AOS that the cluster running, configured with appropriate IP addresses, and br0-up has been configured the same the existing uplink bonds When attempting to...

By examsNCP-MCI-6.5 V1NCP-MCI-6.5 exam0 Comments

21AprApril 21, 2023

How should you complete the command?

HOTSPOT You have an Azure subscription that contains a resource group named RG1. RG1 contains an instance of SQL Server on Azure Virtual Machines named SQL You need to use PowerShell to enable and configure automated patching for SQL. The solution must include both SQL Server and Windows security updates....

By examsDP-300 V2DP-300 exam0 Comments

21AprApril 21, 2023

Which combination of actions should a database specialist take to improve the cluster’s performance?

A company is using Amazon Redshift as its data warehouse solution. The Redshift cluster handles the following types of workloads: * Real-time inserts through Amazon Kinesis Data Firehose * Bulk inserts through COPY commands from Amazon S3 * Analytics through SQL queries Recently, the cluster has started to experience performance...

By examsDBS-C01 V1DBS-C01 exam0 Comments

21AprApril 21, 2023

What should you use?

You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?A . An Azure SQL Database elastic pool B. SQL Server on Azure virtual machines C. an Azure SQL Database...

By examsDP-300 V2DP-300 exam0 Comments

21AprApril 21, 2023

CORRECT TEXT

By examsMD-100 V2MD-100 exam0 Comments

21AprApril 21, 2023

Your organization-wide defaults for access rights to Price Books are set to Use, but only Sales Reps should have access to Price Books, What should be your first step? * (1 Point)

Your organization-wide defaults for access rights to Price Books are set to Use, but only Sales Reps should have access to Price Books, What should be your first step? * (1 Point)A . Change the organization-wide default setting to No Access. B. Change the organization-wide default setting to View Only....

By examsADX-211ADX-211 exam0 Comments

Monthly Archives - April 2023