← Back to exam page

DP-200 – Implementing an Azure Data Solution (beta)

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Mixed Questions)

You need to migrate data from an Azure Blob storage account to an Azure SQL Data warehouse.

Which of the following actions do you need to implement for this requirement? (Choose four.)

Select all that apply, then click Submit answer.

  • ○

    Provision an Azure SQL Data Warehouse instance

  • ○

    Create an Azure Blob storage container

  • ○

    Run the T-SQL statements to load the data

  • ○

    Connect to the Azure SQL Data warehouse via SQL Server Management Studio

  • ○

    Build external tables by using Azure portal

  • ○

    Build external tables by using SQL Server Management Studio
Question 11 (Mixed Questions)

An application is currently making use of a database on the Azure platform. Below is a snippet of the code base:

private static readonly string XYZendpointUrl = ConfigurationManager.AppSettings[“EndpointUrl”];

private static readonly SecureString XYZkey=ToSecureString(ConfigurationManager.AppSettings[“AuthorizationKey”]); var XYZ_client= new DocumentClient(new Url(XYZendpointUrl), XYZkey);

Database database= await XYZ_client.CreateDatabaseAsync(new Database { Id=”XYZdb” );

Which of the following is the key type used in the code?

Select an option, then click Submit answer.

  • ○

    Resource token

  • ○

    Master key

  • ○

    Certificate

  • ○

    Password
Question 12 (Mixed Questions)

You have to design a Hadoop Distributed File System architecture. You are going to be using Microsoft Azure Data Lake as the data storage repository. You have to ensure the data repository has a

resilient data schema.

Which of the following would be used to run operations on files and directories on the file system?

Select an option, then click Submit answer.

  • ○

    DataNode
  • ○

    NameNode
  • ○

    PrimaryNode
  • ○

    SecondaryNode