CTS4408 quiz 1
docx
keyboard_arrow_up
School
Florida International University *
*We aren’t endorsed by this school
Course
4408
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by MegaTank13330
Assuming that the SQL Browser is activated on a destination SQL Server 2014 DB server, which if the following would be a valid connection string for the ADO.NET provider for the .NET Framework trying to connect to the "AdventureWorks2014" database available at IP address "1.2.3.4" and the named instance "Adventure" with integrated security. (5 points)
Integrated Security=true; database=AdventureWorks2014; server=1.2.3.4\Adventure
Instance=Adventure; database=AdventureWorks2014;Integrated Security=true
Integrated Security=false; database=AdventureWorks2014; server=1.2.3.4\Adventure
Integrated Security=true; database=AdventureWorks2014; server=1.2.3.4
Instance=Adventure; database=AdventureWorks2014;Integrated Security=false
Match the system database with its contents.
Tempdb = Stores temporary data and data objects
Distribution = This database is utilized during replication
Master = contains server-wide information
Model = this database is a template MSDB = used to store information
Resource = contains all the system
If you are going to perform a SQL Server upgrade in-place, there are several steps that should be taken prior to performing the upgrade. Please check ALL that apply list from the list below (15 points)
Create full, verified backups of your existing SQL Server databases.
Run the appropriate DBCC consistency checks (for example, DBCC CHECKDB and DBCC CHECKFILEGROUP).
Use the Copy Database wizard to have the database structures upgraded
Detach all user databases.
Make sure the system databases on your existing older instances (for example, master, msdb, tempdb,
and model) are all set to auto-grow and have sufficient free space to grow.
Ensure that database replication is working properly
Match the tool to the functions that it provides
SSMS = an integrated application
Object Explorer = is adaptive to the type of server
Activity Monitor = presents detailed Log Viewer = can display log files that are
Configuration Manager = Allow for the modification
Query Editor = The editing tool for writing
SQLCMD = Provides the capability to Select ALL of the TRUE statements. Select one or more (15 points):
DBCC CHECKDB should be executed at all times to ensure data integrity
A SQL Server data file can be a part of multiple filegroups
You can control the location of objects within a database onto specific disks/SAN LUNs only if multiple filegroups are created for each disk or SAN LUN
SQL Server always writes to the transaction log on disk before any data page is updated in the memory buffers
Dirty pages are data pages that have been updated in memory, but not yet written to disk
Filegroups apply only to data files and not to log files
SQL Server data files and log files perform best on network shares as opposed to locally connected drives
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help