Textbook solutions
Students also studied
Study guides
Practice questions for this set
Indicates that the backup (even if full) should not reset "changed since last backup" flags in the extents of the database
Match the data formats below with the type of data that they contain (15 points).
Word Doc
Relational Database
XML
Blog
Hierarchical Database
EDI
Choose all of the statements that are true (10 points).
For you to tướng switch data from a partition to tướng a table or from a table into a partition, the source and target of the ALTER TABLE...SWITCH statement must reside in the same filegroup.
When switching data from a partition to tướng a table or from a table into a partition, the indexes for both bởi not need to tướng be identical
You use the ALTER PARTITION ...SPLIT RANGE T-SQL command in order to tướng drop a partition
Using RANGE LEFT partitions for datetime values is usually best because this approach makes it easier to tướng specify the limits of the ranges
You use the ALTER PARTITION ...MERGE RANGE T-SQL command in order to tướng drop a partition
Any filegroup referenced in the partition scheme must exist before the partition scheme is created.
Choose all of the statements that are true (10 points). For you to tướng switch data from a partition to tướng a table or from a table into a partition, the source and target of the ALTER TABLE...SWITCH statement must reside in the same filegroup. When switching data from a partition to tướng a table or from a table into a partition, the indexes for both bởi not need to tướng be identical You use the ALTER PARTITION ...SPLIT RANGE T-SQL command in order to tướng drop a partition Using RANGE LEFT partitions for datetime values is usually best because this approach makes it easier to tướng specify the limits of the ranges You use the ALTER PARTITION ...MERGE RANGE T-SQL command in order to tướng drop a partition Any filegroup referenced in the partition scheme must exist before the partition scheme is created.
For you to tướng switch data from a partition to tướng a table or from a table into a partition, the source and target of the ALTER TABLE...SWITCH statement must reside in the same filegroup. You use the ALTER PARTITION ...MERGE RANGE T-SQL command in order to tướng drop a partition Any filegroup referenced in the partition scheme must exist before the partition scheme is created.
Choose the statements below that are true (15 points). Compressing the backups of encrypted databases are generally a best practice because they compress more than vãn unencrypted databases When the database is in Bulk-logged recovery mode, a point in time recovery is not allowed Point-in-time recovery is not permitted with tệp tin or filegroup backups unless all filegroups are restored to tướng the same point-in-time to tướng maintain database consistency You should always perform a log tail backup prior to tướng beginning the restore process Individual tệp tin or filegroup backups can be restored from a full database backup A tệp tin or filegroup backup is used to tướng backup a portion of the transaction log.
Point-in-time recovery is not permitted with tệp tin or filegroup backups unless all filegroups are restored to tướng the same point-in-time to tướng maintain database consistency You should always perform a log tail backup prior to tướng beginning the restore process Individual tệp tin or filegroup backups can be restored from a full database backup
Used to tướng verify that the backup was performed without any corruption
Used to tướng create a second copy of the backup
Used to tướng create a tail log backup prior to tướng beginning restores
Only backup the extents that have changed since the last full backup
Indicates that all backups on the destination truyền thông (i.e. file) should be erased as the new backup is copied on it
Indicates that the backup (even if full) should not reset "changed since last backup" flags in the extents of the database
Match the data formats below with the type of data that they contain (15 points). Word Doc
Relational Database
XML
Blog
Hierarchical Database
EDI
Word Doc- Unstructured (any text can be written in any way)
Relational Database- Structured (has to tướng follow database format)
XML- Semi-structured (some code and some free-form writing)
Blog- Unstructured (just lượt thích word doc, anything can be written in any way)
Hierarchical Database- Structured (must be kept in a hierarchy which is structured and ordered)
EDI- Semi-structured (just lượt thích xml)
Can contain both transactional data (logged and recoverable) and non-transactional data where the BLOBs reside on a tệp tin system
Contains transactional data (logged and recoverable) where the BLOBs are stored within the database files
Contains non-transactional data where the BLOBs are stored on a tệp tin system
Contains transactional data (logged and recoverable) where the BLOBs reside on a tệp tin system
SQL Server uses the standard four-part naming convention when referencing database objects. Which of the following is the correct example of the four-part naming? (5 points) object_name.server_name.schema_name.database_name server_name.schema_name.database_name.object_name server_name.database_name.schema_name.object_name schema_name.object_name.server_name.database_name
server_name.database_name.schema_name.object_name
Which of the following statements are true in SQL Server? (15 points) Select ALL that apply: Indexes should be created on columns that have a low cardinality Page splits cannot occur on HEAP tables during the addition of a row An ALTER INDEX ... REBUILD on a CLUSTERED index cannot defrag the data pages of the table Indexes cannot be compressed A table can have multiple CLUSTERED indexes Indexes are best added to tướng columns referred to tướng by many queries and that are part of a table with many rows Filtered indexes require a WHERE clause
Page splits cannot occur on HEAP tables during the addition of a row Indexes are best added to tướng columns referred to tướng by many queries and that are part of a table with many rows Filtered indexes require a WHERE clause