Microsoft MCTS 70-463

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-463 Implementing a Data Warehouse with SQL Server 2012 Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-463

QUESTION: 1
You are designing a data warehouse for a fresh food distribution business that stores sates by individual product. It stores sales targets by product category. Products are classified into subcategories and categories. Each product is included in only a single product subcategory, and each subcategory is included in only a single category. The data
warehouse will be a data source for an Analysis Services cube. The data warehouse
contains two fact tables:
- factSales, used to record daily sales by product
- factProductTarget, used to record the monthly sales targets by product category Reports
must be developed against the warehouse that reports product sales by product, category
and subcategory, and product sales targets. You need to design the product dimension.
The solution should use as few tables as possible while supporting all the requirements.
What should you do?

A. Create two product tables, dimProduct and dimProductCategory. Connect
factSales to dimProduct and factProductTarget to dimProductCategory with foreign key
constraints. Direct the cube developer to use key granularity attributes.
B. Create one product table, dimProduct, which contains product detail, category, and
subcategory columns. Connect factSales to dimProduct with a foreign key constraint.
Direct the cube developer to use a non-key granularity attribute for factProductTarget.
C. Create three product tables, dimProduct, dimProductCategory, and dimProductSubcategory, and a fourth bridge table that joins products to their appropriate
category and subcategory table records with foreign key constraints. Direct the cube
developer to use key granularity attributes.
D. Create three product tables, dimProduct, dimProductCategory, and
dimProductSubcategory. Connect factSales to all three product tables and connect
factProductTarget to dimProductCategory with foreign key constraints. Direct the cube developer to use key granularity attributes.

Answer: B

QUESTION: 2
You are reviewing the design of a student dimension table in an existing data warehouse
hosted on SQL Azure. The current dimension design does not allow the retention of
historical changes to student attributes such as ParentOccupation. You need to redesign
the dimension to enable the full historical reporting of changes to multiple student
attributes including ParentOccupation. What should you do?

A. Add CurrentValue and PreviousValue columns to the student dimension.
B. Enable Snapshot Isolation on the data warehouse.
C. Add an IsCurrent column to the student dimension.
D. Add StartDate and EndDate columns to the student dimension.

Answer: C

Microsoft MCTS 70-463

Microsoft MCTS 70-462

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-462 Administering SQL Server 2012 Databases Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-462

QUESTION: 1
You create an availability group that has replicas named HA/Server01 and
HA/Server02. Currently, HA/Server01 is the primary replica. You have multiple
queries that read data and produce reports from the database. You need to offload the
reporting workload to the secondary replica when HA/Server01 is the primary replica.
What should you do?

A. Set the Availability Mode property of HA/Server02 to Asynchronous commit.
B. Set the Readable Secondary property of HA/Server02 to Read-intent only.
C. Set the Connections in Primary Role property of HA/Server01 to Allow read/write
connections.
D. Set the Availability Mode property of HA/Server01 to Asynchronous commit.

Answer: C

QUESTION: 2
You administer two SQL Server 2012 servers. Each server resides in a
different, untrusted domain. You plan to configure database mirroring. You need to be
able to create database mirroring endpoints on both servers. What should you do?

A. Configure the SQL Server service account to use Network Service.
B. Use a server certificate.
C. Use a database certificate.
D. Configure the SQL Server service account to use Local System.

Answer: B

QUESTION: 3
You administer a SQL Server 2012 instance that has several SQL Server
Agent jobs configured. When SQL Server Agent jobs fail, the error messages returned
by the job steps do not provide the required detail. The following error message is an
example error message:
“The job failed. The Job was invoked by User CONTOSO\ServiceAccount. The last
step to run was step 1 (Subplan_1).”
You need to ensure that all available details of the job step failures for SQL Server
Agent jobs are retained.
What should you do?

A. Configure output files.
B. Expand agent logging to include information from all events.
C. Disable the Limit size of job history log feature.
D. Configure event forwarding.
Answer: A

Microsoft MCTS 70-462

Microsoft MCTS 70-461

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-461 Querying SQL Server 2012 Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-461

1.You use SQL Server 2012 to develop a database application. You create a stored procedure named dbo.ModifyData that can modify rows. You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
Does not return an error
Closes all opened transactions
Which Transact-SQL statement should you use?

A. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ TRANCOUNT = 0
ROLLBACK TRANSACTION;
END CATCH
B. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
C. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@TRANCOUNT = 0
ROLLBACK TRANSACTION;
THROW;
END CATCH
D. BEGIN TRANSACTION
BEGIN TRY
EXEC dbo.ModifyData
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@ERROR != 0
ROLLBACK TRANSACTION;
END CATCH

Answer: D

2.You are developing a database application by using SQL Server 2012. An application that uses a database begins to run slowly. You discover that during reads, the transaction experiences blocking from concurrent updates. You need to ensure that throughout the transaction the data maintains the original version. What should you do?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: M

3.You are developing a database application by using SQL Server 2012. You have a query that runs slower than expected. You need to capture execution plans that will include detailed information on missing indexes recommended by the query optimizer. What should you do?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: K

Microsoft MCTS 70-461

Microsoft MCTS 70-453

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-453 Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-453

QUESTION 1
You are the administrator of your company network. You are in charge of three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of them runs on a separate server.
Between Instance1 and Instance2, a mission-critical database is mirrored. At present Instance1 currently acts as the Principal, while Instance3 acts as the witness. You intend to apply a patch on both servers. The server needs to restart itself. You have to identify the sequence of steps necessary to ensure that the patching process is completed with the minimum time and the database is online on the partner that currently does not apply the patch. Besides this two, you have to ensure that the database does not failover to the other partner during this time.So what should you do?

A. You should apply the patch to the server which runs Instance2. Apply the patch to the server which
runs Instance1.
B. You should apply the patch to the server that runs Instance2. Manually failover the mirroring
session. Apply the patch to the server that runs Instance1.
C. You should remove the mirroring session. Apply the patch to the server that runs Instance2.
Apply the patch to the server that runs Instance1. Re-establish the mirror
D. You should suspend the mirroring session. Apply the patch to the server that runs Instance2.
Resume the mirroring session. Manually failover the mirroring. Apply the patch to the server that
runs Instance1.

Answer: D

QUESTION 2
You are the administrator of your company network. You are in charge of a SQL Server 2008 instance.
You have to make sure that the names of all user-defined stored procedures contain the prefix usp_ on all instances. Besides this, you have to make sure that you cannot create stored procedures that do not contain this prefix. So what should you do?

A. You should create a policy that targets the name of the stored procedure that is evaluated
on demand.
B. You should create a policy that targets the name of the stored procedure that is evaluated
on change.
C. You should create a condition that targets the name of stored procedure that is evaluated
on demand.
D. You should create a condition that targets the name of the stored procedure that is evaluated
on change.

Answer: B

QUESTION 3
You are the administrator of your company network. You are in charge of a SQL Server 2008 instance that contains a database named DBx1. DBX1 contains a stored procedure called ProcedureX1 and a table named TableX1. By using a sp_executesql Transact-SQL statement, ProcedureX1 selects data from TableX1. As you know, there’s a rule in your company, which is users are not permitted to access tables directly in any database.When ProcedureX1 is run by users, the following exception pops up: “Msg 229, Level 14, State 5, Line 1The SELECT permission was denied on the object ‘Table1′, database ‘DB1′, schema ‘dbo’.” Now you must enable the user to execute ProcedureX1 successfully, while you have to make sure that it will not break the rule of the company. So what should you do to achieve this?

A. You should execute the GRANT SELECT ON dbo.TableX1 TO User1 Transact-SQL statement.
B. You should alter ProcedureX1 and add the WITH EXECUTE AS OWNER option to its header.
C. You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
D. You should alter ProcedureX1 and add the EXECUTE AS USER = ‘dbo’ option immediately before
the call to the sp_executesql stored procedure.

Answer: B

Microsoft MCTS 70-453

Microsoft MCTS 70-432

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-432 TS:MS SQL Server 2008,Implementation and Maintenance Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-432

QUESTION 1
You administer a remote SQL Server 2008 instance.
Users report that the performance of the application is poor.

You use SQL Profiler to capture a workload of the remote instance to a trace table on the remote SQL Server instance.

You need to analyze the workload of the remote SQL Server instance on a local SQL Server instance by using the Database Engine Tuning Advisor.

What should you do?

A. Use the data collector to recapture the workload.
B. Use SQL Profiler to recapture the workload to a trace file.
C. Enable the XP_MSVER stored procedure on the local server.
D. Enable the XP_MSVER stored procedure on the remote server.

Answer: B

QUESTION 2

You administer a SQL Server 2008 instance.

A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked.

Which tool should you use?

A. The Windows System Monitor tool
B. The Database Engine Tuning Advisor tool
C. The Activity Monitor tool in SQL Server Management Studio
D. The Job Activity Monitor tool in SQL Server Management Studio

Answer: C

QUESTION 3
You maintain a SQL Server 2008 instance that runs on a computer that hosts several applications.

You configure the SQL Server Agent service to run by using the SERVER1\AGENT account.

You create a job named MailingList that requires a file to be written to a file server. The job fails to run because it does not have appropriate access to the file server. You plan to configure the SQL Server Agent service.
You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server.
Which account type should you use? A. Domain account
B. Local System account
C. Local Service account
D. Network Service account

Answer: A

Microsoft MCTS 70-432

Microsoft MCTS 70-417

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-417 Upgrading Your Skills to MCSA Windows Server 2012 Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-417

QUESTION 1
Which terminology is being described below:
These trusts are sometimes necessary when users need access to resources that are located in a Windows NT 4.0 domain or in a domain that is in a separate Active Directory Domain Services (AD DS) forest that is not joined by a forest trust

A. Shortcut Trusts
B. Realm Trusts
C. Forest Trusts
D. External Trust

Answer: D

Explanation: You can create an external trust to form a one-way or two-way, nontransitive trust with domains that are outside your forest

QUESTION 2
OCSetup is available as part of the Windows Vista and Windows Server 2008 operating system. This tool replaces Sysocmgr.exe, which is included in the Windows XP and Windows Server 2003 operating systems. This new tool can be used to perform which one of the following operations?

A. All of these
B. System Installer (MSI) files that are passed to the Windows Installer service (MSIExec.exe)
C. Component-Based Servicing (CBS) components that are passed to Package Manager
D. CBS or MSI packages that have an associated custom installer .exe file

Answer: D

Microsoft MCTS 70-417