You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The
packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to
download sales transaction data.
You create project parameters to store the username and password that are used to access the FTP site.
You need to ensure that the username and password values are encrypted when they are deployed.
What should you do?
A.
Set the Sensitive property of the parameters to True.
B.
Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.
C.
Change the parameters to package parameters.
D.
Change the project to the Legacy Deployment model.
option A
Set the sensitive property of the parameters to true
Just passed the exam with score 836
Only used this list to prepare. This list covers all questions in the exam.
Thank you seenagape for loading the list and all the input from all the people
@pangpang,
Thanks for the feedback…
Do you mean the 70-463(v.5) list???
And, did you just use the default answers???
Thanks again for the feedback…
Yes, v.5 version is what I used to prepare. V.5 contains several questions that v.4 doesn’t have.
For the answers I think most answers of v.5 are correct, but you also need to pay attention to comments and better compare it to v.4
Just passed about 7-8 new questions
Has anyone taken the 70-463 exam recently (March 2017) using this list and/or any other list????
Correct answer is
B.
Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.
The username and password saved in parameters. So A is correct.
Passed the exam yesterday. There was 6 new questions.
@sql trainee,
Congrats on passing your exam!!
Did you just use 70-463 (v.5) list to prepare for the exam, or a combination of something else??
Thanks for the feedback…
Has anyone taken the 70-463 exam recently using this list and/or any other list??
Would appreciate any feedback, thanks…
are this dumps reliable can I pass using this?
Any idea if this list of exam questions and answers is available in pdf and downloadable from somewhere? Please advise. Thanks.
scored 876, 5 to 7 new questions.
Cleared with 900+ score, around 5-6 questions are new. This dump v5 is good.
One of the new question was about moving OLDCUSTOMER table to new drive for archival purpose. You have to arrange 4 out of 6 options in sequence. I selected:
1) Create Filegroup
2) Remove clustered index
3) Use MERGE
4) Create clustered index
Remaining two options were:
5) Create File
6) I forgot 🙁
I passed 905 points, I met this question. I additional answer for fullly:
1: remove clustered index
2: Rebuild clustered index
3: Use Merge statement
4: Create filegroup
5: Create file
6: Enable compress page
My answer: 1-6-5-2
A is correct