Which two settings can you configure at the container level?
You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point. A. the throughput B. the read region C. the partition key D. the API Reference: […]
At which two levels can you set the throughput for an Azure Cosmos DB account?
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point. A. database B. item C. container D. partition Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput
When should you implement a read-only database replica?
You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica? A. You need to generate reports without affecting the transactional workload. B. You need to audit the transactional application. C. You need to implement high availability in the event of a regional outage. […]
What should you use?
You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use? A. Microsoft SQL Server Data Tools (SSDT) B. Microsoft SQL Server Management Studio (SSMS) C. Azure Databricks D. Azure Data Studio Reference: https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database? A. built-in high availability B. native support for cross-database queries and transactions C. system-initiated automatic backups D. support for encryption at rest Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
Which type of authentication should you use?
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use? A. service principal authentication B. Azure Active Directory (Azure AD) authentication C. SQL authentication D. certificate authentication Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
Which statement is an example of Data Definition Language (DDL)?
Which statement is an example of Data Definition Language (DDL)? A. SELECT B. JOIN C. MERGE D. CREATE Reference: https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
Which command-line tool can you use to query Azure SQL databases?
Which command-line tool can you use to query Azure SQL databases? A. sqlcmd B. bcp C. azdata D. Azure CLI Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=single-database
What should you use?
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use? A. Microsoft SQL Server Management Studio (SSMS) B. Azure Data Studio C. Azure CLI D. Azure PowerShell Reference: https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/
Which Azure service should you use?
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use? A. Azure HDInsight B. Azure SQL Database C. Azure Cosmos DB D. SQL Server on Azure virtual machines Reference: https://azure.microsoft.com/en-us/services/sql-database/#features