Exam Prep Questions


1.

You are working with a table structure that contains a column that has the xml data type. You need to alter the contents of the column. What method of the xml data type do you use?

  • A. query()

  • B. value()

  • C. exist()

  • D. modify()

  • E. nodes()

2.

You are producing a report that will combine the contents from xml data type and SQL data type columns. Which method of the xml data type do you use?

  • A. query()

  • B. value()

  • C. exist()

  • D. modify()

  • E. nodes()

3.

You are trying to connect to an endpoint to perform an ad hoc SQL query. You are able to connect, but when you try a query, it fails to execute. Your endpoint creation script looks as follows:

CREATE ENDPOINT sql_endpoint STATE = STARTED AS HTTP(PATH = '/sql',    AUTHENTICATION = (INTEGRATED),    PORTS = ( CLEAR ),    SITE = 'SERVER') FOR SOAP ( WEBMETHOD 'GetSqlInfo'            (name='master.dbo.xp_msver',             SCHEMA=STANDARD ),             WEBMETHOD 'DayAsNumber'             (name='master.sys.fn_MSdayasnumber'),    WSDL = DEFAULT,    SCHEMA = STANDARD,    DATABASE = 'master',    NAMESPACE = 'http://tempUri.org/') 


What needs to be corrected with the endpoint settings?

  • A. Change the authentication to Kerberos.

  • B. Change the WSDL to custom through stored procedures.

  • C. Change the state attribute.

  • D. Add a parameter for batches to be enabled.

  • E. Change the database to the correct execution database.

4.

You need to store a large amount of data in an xml data type column of a database. The column must be indexed. You want to establish the fewest possible indexes and still provide the best performance for queries that utilize a lot of XQuery path operations. How would you set up the indexing? (Select two answers.)

  • A. Create a standard clustered index on the primary key field.

  • B. Create a primary XML index on the xml data type column.

  • C. Create a secondary XML index configured for properties.

  • D. Create a secondary XML index configure for paths.

  • E. Create a secondary XML index configured for values.

5.

You are executing a query that needs to provide the results, with no attributes at all. The results should contain the namespace for the data. Which option would you use?

  • A. FOR XML

  • B. FOR XML RAW

  • C. FOR XML RAW, ELEMENTS

  • D. FOR XML RAW, ELEMENTS XSINIL

  • E. FOR XML AUTO




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net