DP-200

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3. To complete...

HOTSPOT You are a data engineer. You are designing a Hadoop Distributed File System (HDFS) architecture. You plan to use Microsoft Azure Data Lake as a data storage repository. You must provision the repository with a resilient data schema. You need to ensure the resiliency of the Azure Data Lake...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region. To complete this task, sign in...

You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support Scola and SQL. Which switch should you use to switch between languages?A . %<language>B . \[<language>]C . \(<language>)D . @<Language>View AnswerAnswer: A Explanation: You can override the primary language...

DRAG DROP You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your user account has contributor access to the storage account, and you have the application ID access key. You plan to use PolyBase to load data into Azure SQL data warehouse. You need to...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3. To complete...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You plan to query db3 to retrieve a list of sales customers. The query will retrieve several columns that include the email address of...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You plan to enable Azure Multi-Factor Authentication (MFA). You need to ensure that [email protected] can manage any databases hosted on an Azure SQL server...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You need to ensure that users in the West US region can read data from a local copy of an Azure Cosmos DB database...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You need to create an Azure Storage account named account10543936. The solution must meet the following requirements: - Minimize storage costs. - Ensure that...