You need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3

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...

May 27, 2020 No Comments READ MORE +

You need to create an Azure Storage account named account10543936

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...

May 27, 2020 No Comments READ MORE +

You need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3

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...

May 27, 2020 No Comments READ MORE +

You need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3

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...

May 27, 2020 No Comments READ MORE +

You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region

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...

May 27, 2020 No Comments READ MORE +

You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region

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...

May 27, 2020 No Comments READ MORE +

Which three actions should you perform in sequence?

DRAG DROP Your company has on-premises Microsoft SQL Server instance. The data engineering team plans to implement a process that copies data from the SQL Server instance to Azure Blob storage. The process must orchestrate and manage the data lifecycle. You need to configure Azure Data Factory to connect to...

May 27, 2020 No Comments READ MORE +

Which type of cluster should you create?

You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data. The analytical data store performs poorly. You must implement a solution that meets the following requirements: - Provide data warehousing - Reduce ongoing management activities...

May 27, 2020 No Comments READ MORE +

Which consistency level should you select?

You plan to implement an Azure Cosmos DB database that will write 100,000,000 JSON every 24 hours. The database will be replicated to three regions. Only one region will be writable. You need to select a consistency level for the database to meet the following requirements: - Guarantee monotonic reads...

May 26, 2020 No Comments READ MORE +

Which type of cluster should you create?

You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data. The analytical data store performs poorly. You must implement a solution that meets the following requirements: - Provide data warehousing - Reduce ongoing management activities...

May 26, 2020 No Comments READ MORE +