Microsoft 70-432 learning materials
If you are learning Microsoft 70-432 exam, you will definitely need 70-432 learning materials, in addition to Microsoft company official textbooks, you may also need to participate in the training courses organized by the training center to you master 70-432 answers knowledge points. Most of the training courses is to start from the basics, then gradually deepening the focus on the content of the curriculum, which generally takes a lot of study time. However, this is not for everyone. Youre probably also hesitant, after all, to participate in the training program, it takes a lot of time and money.
QUESTION 2
You are the administrator of a SQL Server 2008 instance with a database named DB1. In the Services schema there is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs.
Which Transact-SQL statement should you execute?
A. ALTER TABLE Service.Table SWITCH TO Costs.Table1;
B. ALTER SCHEMA Costs TRANSFER Service.Table;
C. ALTER USER Service WITH DEFAULT_SCHEMA = Costs;
D. ALTER AUTHORIZATION ON Service.Table1 TO Costs;
Answer: B
QUESTION 3
You are the administrator of a SQL Server 2008 instance with a database named DB1. wich contains the following stored procedure. (Line numbers are useded for reference only.)
01 CREATE PROCEDURE Sales.Procedure1
02 AS
03 IF OBJECT_ID('Service.Table') IS NOT NULL
04 DROP TABLE Service.Table;
06 CREATE TABLE Service.Table (
07 Id int PRIMARY KEY CLUSTERED,
08 Name varchar(100);
09 );
11 ...
12 GO
The following exception is raised when a user tries to invoke Procedure1,
"Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'."
You should grant the user access to execute Procedure1, you must assign only the required permissions. Which action should you perform?
A. Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause.
B. Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement.
C. You should give the user the ALTER permission on the Service schema
D. You should give the CREATE TABLE permission and permit the user to drop the Service.Table table.
Answer: A