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

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

Describe the differences between logical and physical database design. Discuss the objectives of logical design, such as minimizing redundancy and improving data integrity, and the considerations involved in physical design, such as storage allocation and indexing. with diagram or scoring material

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

Question 1What is a Database in computing?1 pointA collection of organized data stored and accessed electronically. A collection of tables of data stored and accessed electronically.

Question 1Which statement accurately describes the organization of a relational database?1 pointRelational databases consist of a single table with one primary key and one foreign key.Relational databases contain primary keys with at least two duplicate values.Relational databases consist of a single table containing related information.Relational databases contain tables that are related to each other through primary and foreign keys.2.Question 2What is SQL used for? Select two answers.1 pointFinding data to support security-related decisions and analysisSecuring an organization's systems and networksCreating, interacting with, and requesting information from a databaseAllowing users to access a specific machine3.Question 3A record of attempts to connect to an organization’s network is one example of a log. 1 pointTrueFalse4.Question 4Fill in the blank: A request for data from a database table or a combination of tables is called a _____.1 pointquerylogkeyrow