DP-200

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

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: 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 create an Azure SQL database named db3 on an Azure SQL server named SQL10277521....

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

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. You need to implement the Azure SQL Database elastic pool to minimize cost. Which option...

DRAG DROP You have a table named SalesFact in an Azure SQL data warehouse. SalesFact contains sales data from the past 36 months and has the following characteristics: - Is partitioned by month - Contains one billion rows - Has clustered columnstore indexes All the beginning of each month, you...

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

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

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 increase the size of db2 to store up to 250 GB of data. To complete this task, sign in to the...

You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. Developers need to access data in the database using an API. You need to determine which API to use for the database model...