← Back to exam page

DP-300 – Administering Relational Databases on Microsoft Azure (beta)

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Mixed Questions)

A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table.

You need to recommend changes to the data types to reduce storage and improve performance.

Which two actions should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    Change Salary to the money data type.
  • ○

    Change PhoneNumber to the float data type.
  • ○

    Change LastHireDate to the datetime2(7) data type.
  • ○

    Change PhoneNumber to the bigint data type.
  • ○

    Change LastHireDate to the date data type.
Question 11 (Mixed Questions)

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log identifies that several tables are missing indexes.

You need to ensure that indexes are created for the tables.

What should you do?

Select an option, then click Submit answer.

  • ○

    Run the DBCC SQLPERF command.
  • ○

    Run the DBCC DBREINDEX command.
  • ○

    Modify the automatic tuning settings for db1.
  • ○

    Modify the Query Store settings for db1.
Question 12 (Mixed Questions)

You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.

You plan to create a database named DB1 in Pool1.

You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool.

Which format should you use for the tables in DB1?

Select an option, then click Submit answer.

  • ○

    JSON
  • ○

    CSV
  • ○

    Parquet
  • ○

    ORC