3.Question 3Which of the following statements is correct about modifying the configuration of a cloud-based relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5Which of the following key considerations is perhaps the most important?1 pointExpand6.Question 6Transaction logs typically have which of the following characteristics?1 pointExpand7.Question 7Which type of backup is simple to create and restore, but can be slow to run and results in large files?1 pointExpand8.Question 8Assume that a particular database issue, such as extremely low drive space, would require your urgent attention should it occur. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Together authentication, authorization, encryption, and auditing provide system and data security. Which security method provides information that you can analyze to determine and find weak spots?1 pointExpand10.Question 10When creating a backup and restore policy, you must consider the frequency with which you should backup data. Which of the following factors should determine this frequency?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12Which of the following statements can you use to override a user’s permission for a certain object or action?1 pointExpand13.Question 13In MySQL, you can use which command to specify a different default storage engine?1 pointExpand14.Question 14Which of the following is an action you can take to help you identify potential future attacks, such as brute force attempts, on your system?1 pointExpand15.Question 15Which type of encryption uses a public and a private key?1 pointExpand

1.Question 1In which phase of the database lifecycle does the database administrator work on logical and physical design?1 pointExpand2.Question 2Which of the following database objects defines a set of actions performed in response to an insert, update, or delete on a specified table?1 pointExpand3.Question 3What is the first step to modify the configuration of an on-premises relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5What is one advantage of physical backups over logical backups?1 pointExpand6.Question 6What does a database management system (DBMS) use transaction logs to do?1 pointExpand7.Question 7What is one advantage of differential backups over full backups?1 pointExpand8.Question 8Assume that a particular database issue, should it occur, is important but does not require your immediate attention. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Which security method verifies that users are who they say they are?1 pointExpand10.Question 10When creating a backup and restore policy, you must determine an appropriate schedule. Which of the following factors should impact your decision regarding this schedule?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12The GRANT connect statement connects a user or group to a database. What else does the GRANT statement do?1 pointExpand13.Question 13In MySQL, you can use

. • 2h 5m. • 25 total points available.25 total pointsEnglishDueJul 22, 11:59 PM PDT1.Question 1In which phase of the database lifecycle does the database administrator work on logical and physical design?1 pointExpand2.Question 2Which of the following database objects defines a set of actions performed in response to an insert, update, or delete on a specified table?1 pointExpand3.Question 3What is the first step to modify the configuration of an on-premises relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5What is one advantage of physical backups over logical backups?1 pointExpand6.Question 6What does a database management system (DBMS) use transaction logs to do?1 pointExpand7.Question 7What is one advantage of differential backups over full backups?1 pointExpand8.Question 8Assume that a particular database issue, should it occur, is important but does not require your immediate attention. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Which security method verifies that users are who they say they are?1 pointExpand10.Question 10When creating a backup and restore policy, you must determine an appropriate schedule. Which of the following factors should impact your decision regarding this schedule?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12The GRANT connect statement connects a user or group to a database. What else does the GRANT statement do?1 pointExpand

considerations for cloud databases

1.Question 1Which of the following cloud database solutions provides the capabilities of schema-less data, and lets you build highly responsive and always-on applications to support constantly changing data?1 pointAzure Database for PostgreSQL Azure Database for MySQL Cosmos DBAzure SQL Database2.Question 2True or False?One major benefit of using Azure Cosmos DB is the flexibility it allows developers to use the APIs they are most familiar with.1 pointTrueFalse3.Question 3True or False?Azure Cosmos DB only supports proprietary APIs.1 pointTrueFalse4.Question 4True or False?Migration of on-premises SQL databases to Azure SQL Databases is not supported. The databases must be recreated from scratch.1 pointTrueFalse5.Question 5Azure Database for MySQL is a relational database service in the Microsoft cloud, which is based on the MySQL Community Edition database engine. One feature of the Azure database for MySQL is support for Automatic backups and point-in-time-restore for up to how many days?1 point152535456.Question 6Microsoft Azure supports a broad range of technologies and services to provide big data and analytic solutions. Some of the most common big data and analytic service types in Azure are Azure Synapse Analytics, HDInsight, Databricks, and Data Lake Analytics. Which of the following provides a fully managed, open-source analytics service for enterprises that makes it easier and more cost-effective to process massive amounts of data while running popular open-source frameworks?1 pointAzure Synapse AnalyticsAzure DatabricksAzure Data Lake AnalyticsAzure HDInsight

5.Question 5Which of the following is an advantage of using relational databases?1 point