Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

70-462 > 70-462 > Flashcards

70-462 Flashcards

1
Q

What are the versions of SQL Server

A

Premium - Parallel Data Warehouse and Enterprise
Core -
Other - Developer, Express

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Tablular Data Stream TDS protocol

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

SQL Native Access Client (SNAC)

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Security user options

A

Window Logins, Window Groups, SQL Server Logins

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do you access things on the master database?

A

Views and other db tools

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are Named pipes?

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Parallelism

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

MAXDOP

A

? Max degree of parallelism

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

32 bit v. 64 bit

A

32 bit - 4GB of memory
64 bit - 8TB

You can be on a 64 bit machine with a 32 bit license…it runs like 64 bit.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Buffer Pool

A

The main membry object of SQL Server

  • It holds data cache
  • Provides memory for other SQL Server components
  • Is divided into 8K pages
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Physical I/O

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Logical I/O

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does Maximum worker threads = 0 mean?

A

It means there are unlimited thread, you can change it to an actual number to limit the threads.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

SQLIOSIM

A

-Unsupported but provided by Microsoft
-Can be run through command line or GUI
???

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

SQLIO

A

-Unsupported but provided by Microsoft

??

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are primary and secondary data files?

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Transactions logs

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

tempdb

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Windows Collation

A

based on the rules for the associated windows locale

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

SQL Server Collations

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Default Collation and Sort Rules

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

ServerProperty(‘Collation’)

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

DatabasePropertyEX(‘tempdb’,’Collation’)

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Layout the 4 parts of Collate

Latin1_General_CI_AS

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Changing Collation means you cannot actually compare two columns with = you will get an error

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What is the order to install SQL Server by command line?

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What is the order to Upgrade SQL Server by command line?

A

?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What is ndf file?

A

These are secondary data files, they should be stored on a second hard drive.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Extent

A

8 contiguous 8kb pages

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

How big is a page?

A

8kb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What are master system databases?

A

Stores all system-level configuration

32
Q

What is msdb?

A

Holds SQL Server Agent configuration including job, backup and restore history.

33
Q

What is model system database?

A

Is the template for new databases

34
Q

What is tempdb system database?

A

Holds temp data like temp tables, temp variables, table variagbles, hash tables, row version sotre

Microsoft recommends putting this on it’s own hard drive.

When you restart the SQL server it clears out the tempdb.

35
Q

What is resource system database?

A

Hidden read-only database that contains system objects that are mapped to the sys schema of databases.

36
Q

Why could a memory bottleneck lead to higher tempdb usage?

A

?

37
Q

Create db statement

A

?

38
Q

Database option - Auto Options

A

?

39
Q

Database option - Page Verify

A

?

40
Q

Database option - Recovery Model

A

?

41
Q

Database option - State Options

A

?

42
Q

sys.database_files

A

?

43
Q

Alter database

A

?

44
Q

Turstworthy

A

?

45
Q

Broker_Enabled

A

?

46
Q

Recovery Model - Simple

A

?

47
Q

Recovery Model - Full

A

?

48
Q

Recovery Model - Bulk Logged

A

?

49
Q

Backup types - Full

A

?

50
Q

Backup types - Differential

A

?

51
Q

Backup types - Partial

A

?

52
Q

Backup types - Transaction Log

A

?

53
Q

Backup types - ??? there are more

A

?

54
Q

Taillog backup?

A

Continue_After_Error

55
Q

With Init v NoInit

A

?

56
Q

restore labelonly

A

?

57
Q

restore headeronly

A

?

58
Q

restore filelistonly

A

?

59
Q

restore headeronly from disk = ‘[path]’

A

?

60
Q

restore filelistonly from disk = ‘[path]’

A

?

61
Q

restore verifyonly from disk = ‘[path]’

A

?

Do not use this as a substitute for testing the actual backup.

62
Q

restore labelonly from disk = ‘[path]’

A

?

Stripped set
Familycount
familysequencenumber

63
Q

Striped set

A

?

64
Q

SpaceSavings=(Uncompressed size–Compressed size)*100/Uncompressed size

A

?

65
Q

Restore phases

A

data copy
redo
undo

66
Q

StopAtMark

A

?

67
Q

STOPAT

A

?

68
Q

ETL

A

Data Transfer steps - Extract, Transform, Load

69
Q

Check_Policy

A

?

70
Q

SQLAgentUserRole

A

Control permission for jobs and schedules that they own.

71
Q

SQLAgentReaderRole

A

All permissions of the SQLAgentUserRole plus permission to view the list of all the available jobs and job schedules.

72
Q

SQLAgentOperatorRole

A

Permission to manage all local jobs, view properties for operators and proxies and enumerate available proxies and alerts (they cannot manage them only view)

73
Q

sysadmin

A

?

74
Q

DBCC CheckDB

A

?

75
Q

What are the CheckDB options?

A 
Physical_Only
NoIndex
Extended_Logical_Checks
Tablock
All_ErrorMsgs
No_InfoMsgs
EstimateOnly
76
Q

What the difference between rebuild versus reorganize an index?

A

?

70-462 (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions