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?
