CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-900

Free DP-900 Exam Braindumps (page: 24)

Page 23 of 72
PDF with 306 Questions

Which statement is an example of Data Definition Language (DDL)?

  1. SELECT
  2. INSERT
  3. DELETE
  4. DROP

Answer(s): D

Explanation:

Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
-ALTER
-Collations
-CREATE
-DROP
-DISABLE TRIGGER
-ENABLE TRIGGER
-RENAME
-UPDATE STATISTICS
-TRUNCATE TABLE
-UPDATE


Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements



A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as
IntelliSense.
What should the developers use?

  1. sqlcmd
  2. Microsoft SQL Server Management Studio (SSMS)
  3. Azure Data Studio
  4. Azure Data Explorer

Answer(s): C

Explanation:

Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.


Reference:

https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio



HOTSPOT (Drag and Drop is not supported)
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal



You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?

  1. service principal authentication
  2. Azure Active Directory (Azure AD) authentication
  3. SQL authentication
  4. certificate authentication

Answer(s): B


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview






Post your Comments and Discuss Microsoft DP-900 exam with other Community members:

DP-900 Discussions & Posts