MC_AzureSqlDatabaseFundamentals_Session6_1

What is the purpose of Data Manipulation Language (DML) in a database?

• Affect the information stored in the database

• Store data persistently

• Define data structures

• Create virtual tables

What is an important consideration in Tables Management related to data model design?

• Define clustered indexes

• Implement stored procedures

• Use materialized views

• Choose appropriate data types

What is the row limit size in SQL Server tables?

• A. 4KB

• D. 32KB

• B. 8KB

• C. 16KB

What is the purpose of a primary key in a library database?

• Store book titles

• Ensure accurate book inventory

• Define reader borrowing limits

• Identify unique library members

What is the main function of a view in a database?

• Store data persistently

• Control access to data

• Precompute query results

• Dynamically generate result sets

What is the purpose of a stored procedure in a database?

• Create virtual tables

• Define data structures

• Group multiple SQL statements that can be reused

• Execute ad-hoc queries

What is SSIS used for in Microsoft SQL Server?

• D. Stored procedure management

• C. Materialized view creation

• B. Indexing strategy optimization

• A. Extract, transform and load data

What is an important consideration when creating a primary key?

• Non-unique key selection

• Use of volatile column values

• Stability of key values

• Performance of secondary keys

What is the main benefit of using foreign keys in a database?

• Improving data retrieval efficiency

• Preventing data duplication

• Enhancing data consistency

• Ensuring data accuracy

What is the purpose of normalization in database design?

• Minimize data redundancy and dependency

• Maximize data duplication for performance

• Ignore data consistency for flexibility

• Optimize data storage for speed