How many years of experience do you have in configuring any version of SQL Server?
How many years of experience do you have in configuring any version of SQL Server?
Rate your level of proficiency with applying additional SQL Server query techniques, including subqueries, CTE
Rate your level of proficiency with applying additional SQL Server query techniques, including
subqueries, CTE queries, ranking functions, and execution plans.
Rate your level of proficiency in working with query fundamentals, including using SELECT, INSERT, UPDATE, DEL
Rate your level of proficiency in working with query fundamentals, including using SELECT, INSERT,
UPDATE, DELETE, OUTPUT, and MERGE statements, implementing aggregate queries, combining
datasets, and applying builtin
scalar functions.
Rate your level of proficiency with implementing programming objects in SQL Server…
Rate your level of proficiency with implementing programming objects in SQL Server, including
creating and altering stored procedures, userdefined
functions, DML and DDL triggers, and CLRbased
objects; managing transactions; and implementing error handling.
Rate your level of proficiency with creating, implementing, and altering tables, views, and indexes in SQL Ser
Rate your level of proficiency with creating, implementing, and altering tables, views, and indexes in
SQL Server, including implementing data types and partitioning solutions.
Rate your level of proficiency with using additional SQL Server components, including Database Mail, Fulltext
Rate your level of proficiency with using additional SQL Server components, including Database Mail,
Fulltext search, Windows PowerShell?, SQL Server Management Objects, and Service Broker.
Rate your level of proficiency with using XML data, including retrieving relational data as XML, transforming
Rate your level of proficiency with using XML data, including retrieving relational data as XML,
transforming XML into relational data, and querying and managing XML data.
Rate your level of proficiency with gathering performance information, including capturing execution plansR
Rate your level of proficiency with gathering performance information, including capturing execution
plans, gathering trace information by using SQL Server Profiler, collecting output from Database
Engine
Tuning Advisor, and collecting information from system metadata.
How can you view the available resources within the next 30 days to plan on task assignment based on resource
You are a project manager in your organization. You have several activities that need to be
completed within the next thirty days for your project to reach its deadline on time. How can you
view the available resources within the next 30 days to plan on task assignment based on resource
availability?
Which one of the following is NOT a site group that is created automatically?
Project Server automatically creates four site groups within the project workspace. Which one of the
following is NOT a site group that is created automatically?