This class was created by Brainscape user Cody Smith. Visit their profile to learn more about the creator.
By:
Cody Smith
- decks
- flashcards
- learners
Decks in this class (18)
Backup and Restore
What are the four different media...,
What is the syntax to restore a d...,
What are the different recovery m...
26
cards
Manage Logins and Server Roles
What is the difference between a ...,
What is the t sql syntax for crea...,
What are the default server roles
39
cards
Implement and Maintain Indexes
What is a table called when it do...,
What are the two fixes for index ...,
What does reorganize do for an index
14
cards
Import and Export Data
Besides backup and restore whats ...,
What are the gui ways for importi...,
What is the t sql syntax for bulk...
4
cards
Manage SQL Server Agent
How do you see what jobs are runn...,
What is the system table to get j...,
What system table is used for the...
8
cards
Manage and Configure Databases
What is auto_close,
What is auto_shrink,
How can you make sure that all da...
23
cards
Compression
What are the negatives with compr...,
What does row compression do for you,
What is prefix compression
9
cards
Identify and Resolve Concurrency Problems
What is live locking,
What is deadlocking,
What is blocking
27
cards
Collect and Analyse Troubleshooting Data
What is sql server profiler,
How do you get to sql server prof...,
What is going to replace sql serv...
17
cards
Audit SQL Server Instances
What is sql server auditing,
What are the components to a sql ...,
How many audit specifications can...
14
cards
Plan Installation
What are all of the types of hard...,
What should you install first bef...,
What are the different editions o...
22
cards
Install SQL Server and Related Services
What is an instance of sql server,
What are the instance features th...,
What are the instance features th...
14
cards
Implement a Migration Strategy
What are the attributes of detatc...,
What are the attributes of backin...,
How can you solve the issue that ...
4
cards
Additional SQL Server Components
What is full text indexing,
What are the steps to use a full ...,
What is a full text stoplist for ...
13
cards
Isolation Levels
What are the isolation levels in ...,
What is the default isolation lev...,
Read uncommitted dirty read
31
cards
Other Index Questions
What is a columnstore index,
What benefits does a columnstore ...,
What do columnstore not do well
5
cards
Important System Tables
What is the system table that you...,
What is the system table that has...,
What is the system dm view that s...
20
cards
Important System Stored Procedures
Enables collection of natively co...,
Enable the collection of natively...,
Create an application lock for a ...
4
cards
More about
70-762 Certification
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Cody Smith's 70-762 Certification flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
Looking for something else?
70-762 Developing SQL Databases
- 3 decks
- 23 flashcards
- 9 learners
Decks:
Design And Implement Database Objects, Dmvs, In Memory Tables, And more!
MCSA 70-740
- 4 decks
- 220 flashcards
- 157 learners
Decks:
1 Install Windows Server In Host And Com, 2 Implement Storage Solutions, 3 Implement Hyper V, And more!
Flight Paramedic Certification
- 15 decks
- 946 flashcards
- 1612 learners
Decks:
Respiratory, Pediatrics, High Risk Ob, And more!
